Discussions

Expand all | Collapse all

Filter results checkbox is checked using API_GenResultsTable query

  • 1.  Filter results checkbox is checked using API_GenResultsTable query

    Posted 04-16-2018 21:27
    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");~


  • 2.  RE: Filter results checkbox is checked using API_GenResultsTable query

    Posted 04-16-2018 21:34
    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.


  • 3.  RE: Filter results checkbox is checked using API_GenResultsTable query

    Posted 04-16-2018 22:17
    Awesome!  I am flying now!  Thank you!