Forum Discussion

LAURARAMIREZ's avatar
LAURARAMIREZ
Qrew Trainee
7 years ago

Filter results checkbox is checked using API_GenResultsTable query

Hi out there!
I am trying to use an AND to only get fields where the checkbox is checked.  This is not working.  11 is the field ID (checkbox) I tried upper and lower case 'true' I also tried the number '1'. 

How to you filter on a checkbox using API_GenResutlsTable

,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?TRUE?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~

,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?true?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~

,"API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}AND{?11?.EX.?1?}^clist=103.101.80.31.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~
APIs and custom code

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I don't have an direct answer to your question but I know how to cheat on this quiz.  Fortunately, once we are out of school cheating and shortcuts are allowed.

    If you make any report, you can use the "more" button to show the expanded URL.  That will give you the exact syntax to copy and paste.