Forum Discussion
When it's all said and done - your syntax all looks functionally ok from below so at face value it's not a syntax issue.
var text QUERY =
"{362.EX.'" & [Testing ESL Level] & "'}" & "AND"&
"{3.LTE.'" & [Placement ID] & "'}" & "AND"&
"{344.CT.'" & "ESL" & "'}" ;
If you're not getting a value at all or not getting a value you're expecting - then it likely has something to do with how you're forming the query. I would suggest picking an arbitrary record and trying to test the 'Ranking' query syntax your testing in a report. So pick a record that you know the general ranking it should be potentially - and then make a temporary report where you set the report filters to be the same as your query and plug in the values for Testing ESL Level and Placement ID against Field 362 and Record ID# and see if the report spits out the # of records you're trying to match. If the number of records is 1007 then you know it's working as intended. If it returns 0 then you know it's not. Then you can modify the report filters to get the results you want to make whatever updates might be needed in the query itself.
------------------------------
Chayce Duncan
------------------------------
Thank you for your follow-up. I find that part of the issue is fields used on the query are lookup field formulas.
------------------------------
Data System Analyst (Administrator)
------------------------------