Wait for condition in flow designer not supported by Transform map

[ankitsharma_487]

Hi All,

I have a scenario where once Import start and transform map finishes and populates the table then a notification should be triggered.

When I am trying to look for wait for condition in flow designer, transform map table is not supported by it 

in that case what would be the solution, I tried following

var gr = new GlideRecord("sys_import_set_run");
gr.addEncodedQuery("set.table_name=u_test_import_table^state=complete^set.number="+fd_data._9__look_up_record.record.number);
gr.orderByDesc('sys_created_on');
gr.query();
if(gr.next())
{
return true;
}

[Ankur Bawiskar · Accepted solution]

@ankitsharma_487 

you should have notification on this table (sys_import_set_run) and it will run when the transform is complete.

Ensure you give the correct condition for import set table name so that it runs only for your import set table completion.

Create a group with the email to whom it needs to be sent

you can then send the list of inserts, updates etc

Include the group in Who will receive section

Then include the body like this

If my response helped please mark it correct and close the thread so that it benefits future readers.

[ankitsharma_487]

Thanks @Ankur Bawiskar , this helped in getting the stats, also I read your suggestion on other article that wait for condition works on the table on which flow is running so I used some tweak to update some field on catalog task (flow is running on catalog task table . that works .
Thanks