Forum Discussion

LAURARAMIREZ's avatar
LAURARAMIREZ
Qrew Trainee
7 years ago

Filter results using API_GenResultsTable query

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?

 

No RepliesBe the first to reply