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

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 [ ]

 

Thanks very much for this.  Greg.