hi there,
I am using a reference selection picker filter in my stepper.
The following two statements work fine on their own:
1) Referenced.Country.ID = 'AU'
2) Referenced.PL_REGION.PL_Region IS NOT NULL
Ideally id like to do something like the following within my picker filter reference selection:
CASE
WHEN Record.DistGrp_CVC.FID_Country = 'AU'
THEN (Referenced.Country.ID = 'AU' AND Referenced.FID_PL_REGION IS NOT NULL)
ELSE Referenced.PL_REGION.PL_Region IS NOT NULL
END
The ELSE statement works by itself, and the two statements in the THEN statement work individually.
Is it possible to use a case statement in a picker filter? If so, any suggestions on my SEMQL? Thank you
Michael BARTLEY
hi there,
I am using a reference selection picker filter in my stepper.
The following two statements work fine on their own:
1) Referenced.Country.ID = 'AU'
2) Referenced.PL_REGION.PL_Region IS NOT NULL
Ideally id like to do something like the following within my picker filter reference selection:
CASE
WHEN Record.DistGrp_CVC.FID_Country = 'AU'
THEN (Referenced.Country.ID = 'AU' AND Referenced.FID_PL_REGION IS NOT NULL)
ELSE Referenced.PL_REGION.PL_Region IS NOT NULL
END
The ELSE statement works by itself, and the two statements in the THEN statement work individually.
Is it possible to use a case statement in a picker filter? If so, any suggestions on my SEMQL? Thank you