GetFieldValues Query Question
GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}and{7.EX.'" & [Load # - Description] & "'}",[_DBID_PRICE_HISTORY]),19) Can anyone tell me what is wrong with this query, I...
Forum Discussion
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
- 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
------------------------------No spaces on the AND, it does need to be capitalized though.
So in the query it should look like:
GetFieldValues(GetRecords("{17.EX.'value'}AND{7.EX.'value'}",[_DBID_PRICE_HISTORY]),19)
------------------------------
Dwight Munson
------------------------------
