So, I have the following script that I am pretty sure is almost there:
Lines 11 to 15 make up the 'AND' part of the find request. If any of these fields are completed, they should be used in a cumulative way. Note, that these three sind fields may all be empty, part completed or all completed. These work fine on their own.
Lines 18 to 23 are lifted from a post from philmodjunk, and work very well on their own.
The problem arises when I try to combine both of these different things into the single find script.
From the following find request (ignore the job acceptance status checkbox set as I have not put this into the script yet!)
.... I would expect to get all the Job results for Nike Limited, in Dublin, in June 2017, where the job status is 'Report Delivered' OR 'Ready for Invoice' OR 'Complete (Invoiced)'.
Any help would be great. I have trawled for a similar request, but not found anything so posting this up.
Hopefully I will have my answer when I wake up (UK time its way past midnight).