Skip to main content
Question

Formula Query Syntax question?

  • October 22, 2021
  • 0 replies
  • 20 views

Is it possible to have a text field that could be used inside the function query?

For example, suppose I had a field named Query, could I use a function query like this?

GetFieldValues(GetRecords([Query]))

------------------------------
Paul Peterson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Yes 

Also you can do this as a best practice recommendation 

var text QUERY = "{ query string goes here}";

GetFieldValues(GetRecords([Query]), [_DBID_table_ alias])

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------