Filtering portal based on 2 fields

[Grimfool]

I am able to filter a portal based on one field but am unsure of how to filter a portal using 2 fields. I understand that it will require a script using an if statement but do not have sufficient knowledge of which functions I should use. 

 

Edited December 13, 2017 by Grimfool

[rwoods]

Hi Grimfool

If you are using the 'Filter' option in the 'Portal Setup' dialog, then you can just extend your filter calculation to include two fields, for example :-

( relatedTable::qty > 0 ) or ( relatedTable::qtyRequiredFlag = 0 )

where qty and qtyRequiredFlag are both fields in the table that he portal is based on.

Does that answer your question?

Edited December 13, 2017 by rwoods

[Grimfool]

So in my Go to Field statement I can put an 'or' option?