Filter results using API_GenResultsTable query | Discussions

Filter results using API_GenResultsTable query

  • 1.  Filter results using API_GenResultsTable query

    Posted 04-12-2018 23:07
    I am lost trying to filter data for my custom forms. 

    This is my current query.

    ~=qdb.GetURL("bnezxxxxx","API_GenResultsTable^query={'40'.EX.'"+field["Name"]+"'}^clist=80.91.92^options=nvw.ned.phd.nfg.sortorder-A^slist=91");~

    How do I add filters to create form 1 and form 2?

    Form 1:   Display only rows where Activities: ?Key Activity? is checked (checkbox)

    Form 2:   Display only rows where Tasks-Level3:?Required? is checked (checkbox)

     

    I am working with 3 tables with relationships: 

    ?         Projects

    ?         Activities

    ?         Tasks-Level3

    Activates = ?bnezxxxxx? 

    40= (Text Lookup) (Value Field) Projects: Name  (Reference Field) Activities:RelatedProject2

    ?Name?=(Text Field) (Projects:Name)

    80= (Text Lookup( (Value Field) Tasks-Level3:Level 3 ? Name (Reference Field) Activities:Related Tasks -L32)

    91=(Date field) Activities:?Start-Display?

    92=(Date field )Activities:?Finish-Display?