I am having a little bit of a head scratcher.
I have multiple lists that I want to compare.
I have 2 BOs
Works and ContractWorks
Contract Works has an attribute om_Works which contains multiple Works.
I am trying to do searches for Works that have previously been associated with Contracts, so I have one or more work to search within ContractWorks.om_Works.
The net result is I am checking the elements of an array for their existence in another array.
One way I can do this is serially
Find Works
Run SubProcess for the next element of the find and so on
This seems like it is a bit clunky so I was wondering if there is another way to do this as I have now developed quite a big chain of checks.
I know that I can do this as a stored proc and may well turn to that once everything is more stable, but in the mean time I have to work with processes.
