AnsweredAssumed Answered

Filter a portal based on two values.

Question asked by FM_DM on Jul 31, 2018
Latest reply on Aug 1, 2018 by FM_DM


I am sure this is something simple but I am scratching my head

I have a portal which shows parts used by engineers on a job. The relationship is between the jobs table and the parts table and is linked by job number.

I can get it all working fine when the portal is filtered on job number alone. But now I want it to also to filter only jobs with the same number but when the filed Usedrequired is set to used.


I have set the filter to:

Parts::JobNO & Parts::UsedRequired = "Used"


but this does not work. Can the filter only be applied to a single field or is my phrasing off?