Formula Query - Size ?
I am trying to find the correct syntax to use a Size formula query for all items with a check in a checkbox. I am trying to use: Size(GetRecords("{##.EX.'yes'}", "????????")) but it is not returni...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
var text Query = "{'192'.EX.'1'}" checkbox fid is 192
Size(GetRecords($Query), [_DBID_Table Alias]))
Let me know if that works. One way to generate a query is to run a report or search with filters and then use the old report style and then "More" to show the expanded URL.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text Query = "{'192'.EX.'1'}" checkbox fid is 192
Size(GetRecords($Query), [_DBID_Table Alias]))
Let me know if that works. One way to generate a query is to run a report or search with filters and then use the old report style and then "More" to show the expanded URL.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I'm getting closer, had to tweak yours a little to get rid of a syntax error "Expecting )"
var text Query = "\"{'196'.EX.'0'}\", \"?????????\""; //checkbox fid is 196 and ????????? is the table ID
Size(GetRecords($Query))
I am getting something, but it is 0 for 1 and 0 and I know there are several thousand records in that table.
------------------------------
Paul Peterson
------------------------------
var text Query = "\"{'196'.EX.'0'}\", \"?????????\""; //checkbox fid is 196 and ????????? is the table ID
Size(GetRecords($Query))
I am getting something, but it is 0 for 1 and 0 and I know there are several thousand records in that table.
------------------------------
Paul Peterson
------------------------------
- @Paul Peterson The issue may be the extra escaped quotes in your Query that aren't necessary.
I'm not sure if you've seen my recent video Query Writing 101, I've added it here.
I also have a number of new Formula Query resources over on the Quick Base Junkie Blog that you may find helpful.
------------------------------
Quick Base Junkie
------------------------------- Finally found my problem. I wasn't handling the table ID correctly.
This version actually worked:
var text tableID = "????????";
var text Query = "{'192'.EX.'1'}AND{'1260'.EX." & [Month]& "}";// & $tableID; //checkbox fid is 192
Size(GetRecords($Query, $tableID))
I also wanted to refine the search by month.
THANK YOU both for your help!!!
------------------------------
Paul Peterson
------------------------------
- MarkShnier__Youthis tested OK for me
var text Query = "{'209'.EX.'1'}";
Size(GetRecords($Query,[_DBID_PARENT]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
