Filter results checkbox is checked using API_GenResultsTable query

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • Answered
  • (Edited)
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");~
Photo of LAURA RAMIREZ

LAURA RAMIREZ

  • 132 Points 100 badge 2x thumb

Posted 7 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Photo of LAURA RAMIREZ

LAURA RAMIREZ

  • 132 Points 100 badge 2x thumb
Awesome!  I am flying now!  Thank you!