Building a dynamic encoded Query using Flow variables and Set Flow variables

[utkarshusin]

Starting off with a look up records on Security incidents table, and then using it to Set a flow variable - 'encodedQuery'

I am progressing through the flow and based on if, else conditions.. i have to keep adding to my encodedQuery.

The problem is that i am missing some trick or syntax because after finishing, i am doing a Look up records on the Security incident table and it finds 0 records, while action status is Success.

Please help if anyone knows what i am missing. (Using Data field of set flow variables) to set it.

[utkarshusin]

Those are the sys ids of records found earlier in the flow, by using conditional look-up records.

I am building the query starting with that only.

[Kieran Anson]

With using those IDs, what do you want to query against on your table. As currently you're creating an invalid query 

[utkarshusin]

Hello Kieran, i know this is very late, so apologies.

What i have done is now i am making use of the script (using fd_data...) and have stored my dynamic encoded query in a flow variable, say test1.

For doing the Look up Records, through script.. Gliding over the sec. incident table i am making use of this flow variable (fd_data.flow_var.test1) in the addEncodedQuery.

Question is, in the same look up records action , through the same script if i make updates to the found records and the current trigger records..will it be correct or i need to use . For Each and then update..