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.

[Kieran Anson]

Can you share screenshots of your flow, additionally an example of the created encoded query. It may be malformed 

[utkarshusin]

Hey Kieran, i had earlier tried it writing in couple of other ways. 

- ${encodedQuery} + '^.....

-[the look up record data pill] += '^u_is_ntb_user_generic=true^u_ntb_user=' + [ntb_user reference data pill]

I am not sure what exactly will be the correct format, in the attached screen shots you can see i have used the Flow variable as a condition for look up records. Right now, it returns 0 records and the Action status in Output is Success.

[utkarshusin]

Hey Kieran, i had earlier tried it writing in couple of other ways. 

1 - ${encodedQuery} + '^.....

2 -[the look up record data pill] += '^u_is_ntb_user_generic=true^u_ntb_user=' + [ntb_user reference data pill]

I am not sure what exactly will be the correct format, in the attached screen shots you can see i have used the Flow variable as a condition for look up records. Right now, it returns 0 records and the Action status in Output is Success.

[Kieran Anson]

Your query starts with a series of sys_ids but doesn't indicate on what field to lookup on. Are they sys_ids of records on the security incident table? Or are they to a reference field/list collector field on the security incident table?