Multi criteria search???

[Greg58]

I am using the id and parent_id fields above on the right to link related trades.  The 2 parent_id's in this case are the result of selling the 1 id buy.  Now I am trying to do a search for the id (all UUID's) and the parent_id's that are the same.  I want to isolate the 3 transactions as 1 completed trade.  I have ended up with the below script, but it does not work and returns no matching results.  the individual set fields return the correct results but not when I combine them.  Can anyone assist please??

210512.fmp12

[comment]

The Modify Last Find step makes no sense whatsoever. If you want to find records that have the given value in the id field OR in the parent_id field, you need to create a separate request for each field:

Set Variable [ $transID; Value:Transactions::id ]
Enter Find Mode [ ]
Set Field [ Transactions::id; $transID ]
New Record/Request
Set Field [ Transactions::parent_id; $transID ] 
Perform Find [ ]

 

[Greg58]

Thanks very much for this.  Greg.