AnsweredAssumed Answered

Multiple Portal filters

Question asked by gregstock on Jan 2, 2019
Latest reply on Jan 2, 2019 by gregstock

Hi folks, I am trying to get a multiple filter to work.
I have a Global field with a script trigger to refresh that filters a self joined portal with the calculation :

If ( PUCWork 2::W_L_HSIDRegisterWork = PUCProject::P_G_FilterWrkHsid ; 1 ; 0 )

But I would like to add an additional filter on the portal where the field to filter is a Checkbox result.

The typical filter shoiúld be on the second item of the value list : "Complete, Waiting, Check".

I tried :  PUCWork 2::W_Complete= ¶&"Waiting"  AND If ( PUCWork 2::W_L_HSIDRegisterWork = PUCProject::P_G_FilterWrkHsid ; 1 ; 0 )

but I get a blank portal.  Thanks for any hints.

Outcomes