AnsweredAssumed Answered

Conditional formatting help

Question asked by duncanbaker on Dec 14, 2013
Latest reply on Dec 14, 2013 by duncanbaker

Hi folks

 

I'm back with another query that I need to fast track through. I've given it a go but not been successful.

 

In brief, I have people and people are tagged to assignments via a join table. I tag them using a picker that is based on an assignment>people cartesian relationship. In this picker I want to highlight those that have been tagged to the assignment already. This I can do using this in the conditional formatting of the picker field:

 

FilterValues ( asn.PLP_People~Cartesian::__zkpPeopleID ; List ( asn.JPA_JoinPeopleAssignments::_zkfPeopleID ) )

 

That's all well and good, but for reasons that we don't need to go into, I only want to highlight those that are in the join table AND those that have a value of "Candidate" in another one of the join table fields. I've tried:

 

FilterValues ( asn.PLP_People~Cartesian::__zkpPeopleID ; List ( asn.JPA_JoinPeopleAssignments::_zkfPeopleID ) )

and

FilterValues ( "Candidate" ; List ( asn.JPA_JoinPeopleAssignments::Type ) )

 

But I can see this isn't right and of course it's not working... Any ideas? I'll keep trying in the meantime.

 

Thanks

Outcomes