I'm having some trouble filtering a collection using a value that's stored as a data item. Let me explain what I'm trying to do:
I've got some Work Queue Items, which when retrieved from the WQ contain a field called "Resource ID", and the value for this field has in turn been stored as a data item. The value of this field should correspond with a field in a collection called "Work Order ID". The collection could contain multiple rows matching this Resource ID/Work Order ID and I need to extract all of them into a separate collection, hence the use of 'Filter Collection'.
However, I can't seem to get the Filter collection's 'Filter' input to retrieve the value of a data item. For example, the following will work:
"[Work Order ID] = 'ABC123456'"
but if I try and use the following:
[Work Order ID] = [Resource ID]
I get a null return.
I've tried a range of combinations including "[Work Order ID]" = [Resource ID] but nothing seems to work. When I entered [WO Entries.Work Order ID] = [Resource ID] it returned the whole collection.
Can Data Items not be used with the Filter Collection action?
