I have multiple Derivedfields with a format similar to the below, each with different transition tasks.:
BGStaffingInitiated is a DerivedField
type is Boolean
if (TransitionTask = "STAFFING INITIATED" and ResourceTransitionTask.Status = 6)
return true
else
return false
Relation:
CandidateResourceTransitionTaskRel
one-to-many relation to ResourceTransitionTask
Field Mapping uses symbolic key
related.HROrganization = HROrganization
Instance Selection
where ((related.ResourceTransition.Candidate.JobRequisition = Candidate.JobRequisition
and related.ResourceTransition.Candidate = Candidate)
and (related.TransitionTask = "CLEARED BACKGROUND"
or related.TransitionTask = "STAFFING INITIATED"))
The problem I am having is that when I put just the "STAFFING INITIATED" task in the relation it works, when I put just the "CLEARED BACKGROUND" task it works, but when I try to do "or" statements to do multiple only the "STAFFING INITIATED" task.
Any clue how to get this to work?