Flow Designer Look up record by table name

Rafał Rataj
Tera Contributor

Hi, 

 

I have an issue with look up record action on task table, in some cases it returns 'record not found' 

I see a possible solution is to use the dedicated table instead of the task table

as the trigger is the sys_attachment table there is no reference to the record table but there is the record table name 

 

the look up records requires the table type and is not working with table name (string type)

I tried a custom action but there is no 'table' output as well 

 

any suggestions?

 

Rafa_Rataj_0-1718265504551.png

 

6 REPLIES 6

Here:

Aleks5_0-1718289605869.png

Aleks5_1-1718289627889.pngAleks5_2-1718289655168.pngAleks5_3-1718289673609.png

 

Aleks5
Tera Contributor

Either you look up the dedicated task table OR

you use the INSTANCEOF condition. With INSTANCEOF you filter on the task table and every child table.

Like this: sys_class_nameINSTANCEOFcmdb_ci_server

In the Condition Builder the operation it is called "is a".

 

Please mark my answer as helpful if it fixed your problem.

 

Thanks
Aleks