Find Script Omitting records where two fields don't match.
I have the following script: (Screenshot)
All the tables I speak of/reference are related.
When I run that script it works fine, but I need to add a step and i'm not sure how to work it in. I would like it to find as that script staes but take it a step further and if the date in Service Activity::Ax date do not match the date in StaffActivity::StartDate I want to omit the records.
How would I do that and what point do I add it? I've tried doing new record/request before the perform fidn option with an If statment saying if the Ax Date is not equalt to (using the = with the slash through it) start date then using omit records. It didn't work, still showed the records where the two dates were not the same.
Thanks in advance for the help!
define a calculation field in Service Activity as:
Ax date = StartDate
Select Number as the result type.
In your find request, specify a 1 in this calculation field.