Filter results using API_GenResultsTable query

  • 0
  • 1
  • Question
  • Updated 8 months ago
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”

 

Photo of LAURA RAMIREZ

LAURA RAMIREZ

  • 132 Points 100 badge 2x thumb

Posted 8 months ago

  • 0
  • 1

Be the first to post a reply!