GetFieldValues Query Question

Question

GetFieldValues(GetRecords("{17.EX.'" &amp; [Consignee - Related Consumer] &amp; "'}and{7.EX.'" &amp; [Load # - Description] &amp; "'}",[_DBID_PRICE_HISTORY]),19)Can anyone tell me what is wrong with this query, I am not getting any results and I know that there are some.In addition when if I query for either of the 2 filters individually I do get results, eg:GetFieldValues(GetRecords("{17.EX.'" &amp; [Consignee - Related Consumer] &amp; "'}",[_DBID_PRICE_HISTORY]),19)------------------------------George Bramhall------------------------------

georgebramhall2 · Answer

Thank you all for your help ... using AND vs and and going with the variable approach gave results.------------------------------George Bramhall------------------------------

marcelobenavide · Answer

I have a question. Do you have records where the two fields match? because you use an AND statement.

Consulting them separately is not a good test.

A=XYZ and B=FGH , do you have record with the two conditions ?

Marcelo Benavides Torres

markshnier__you · Answer

I believe that the the "and" is incorrect. I believe it is case sensitive and also I think it needs spaces.

Try this standardized syntax. The syntax is so difficult and the formula editor does not help much for Formula Queries, I try to keep mine very standard like this.

var text QUERY =
"{17.EX.'" & [Consignee - Related Consumer] & "'}"
& " AND "
& "{7.EX.'" & [Load # - Description] & "'}";

GetFieldValues(
GetRecords($QUERY, [_DBID_PRICE_HISTORY]),19)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

dwightmunson1 · Answer

No spaces on the AND, it does need to be capitalized though.&nbsp;
So in the query it should look like:&nbsp;GetFieldValues(GetRecords("{17.EX.'value'}AND{7.EX.'value'}",[_DBID_PRICE_HISTORY]),19)------------------------------Dwight Munson------------------------------

Forum Discussion

GetFieldValues Query Question