Page 1 of 1

Custom Query - Include parameter in sub title

Posted: 31 Mar 2020 11:31
by Seeker
Hi

I've seen this post Custom queries (6716)
and tried this as a custom subtitle
=Individual(['QueryRoot'])

The query works well, but when I look at print preview the subtitle is just the text of the function.
Any ideas as to what may be wrong?

Re: Custom Query - Include parameter in sub title

Posted: 31 Mar 2020 11:54
by tatewise
In FH V6, the parameter name must now be enclosed in "double string quotes" as elsewhere in your Query.
e.g.
=Individual(["QueryRoot"])
or
=Name(["QueryRoot"]) should work too.

However, it does depend on the data type of the "QueryRoot" parameter being an Individual Record.

Re: Custom Query - Include parameter in sub title

Posted: 31 Mar 2020 15:31
by Seeker
Many thanks. Both individual and name now work.
On my first attempt individual didn't work, so I tried name and that worked, so then I tried individual again and that then worked!