Page 1 of 1

Multimedia Query Query

Posted: 19 Mar 2022 12:00
by Little.auk
I am trying to modify a simple Media query, as per image, to include the Record ID field. The Fields list shows a Field named Automated Record ID, which I have added and which gives the code%OBJE.RIN%. However, when I run the query the ID column remains blank.

%OBJE.FILE% and %OBJE.KEYS% are working. I don't use Custom IDs, but I have created one to test, and %OBJE.REFN% also works.

So why doesn't %OBJE.RIN% - is the Media Record ID hidden somewhere else?

Screenshot 2022-03-19 114115.jpg
Screenshot 2022-03-19 114115.jpg (61.25 KiB) Viewed 510 times

Re: Multimedia Query Query

Posted: 19 Mar 2022 12:13
by tatewise
That is a popular question that many users have. You need to use the =RecordId() function.
Tips:
See FHUG Knowledge Base Understanding Expressions or Understanding Functions that give examples for =RecordId()
Look in any Query that provides Record Id in its Result Set and see how it produces that in the Columns tab.

See also FH V7 Help page Funcion: RecordId

The Automated Record Id is something quite different.