Query in Flow Designer Condition

BRUNO BANDEIRA
Tera Guru

Olá pessoal, estou com um problema relativo a um fluxo no FLOW DESIGNER. 

 

Eu preciso resgatar um valor da tabela QUESTION ANSWER relativo a um Priority para dar continuidade a um fluxo. O problema é que existem muitas QUESTIONS com o mesmo valor 'PRIORITY' e assim sendo, se eu procuro via data pill é impossível saber se estou selecionando a opção correta.

 

Na action LOOK UP RECORD existe a opção de incluir a condição via query, mas já tentei de tudo e não consigo sucesso, tipo:

"question=<SYS_ID>^table_name=sn_customerservice_case^table_sys_id=" fd_data.trigger.current.record.sys_id

"question=<SYS_ID>^table_name=sn_customerservice_case^table_sys_id=" + trigger.current.sys_id

 

Mas, tudo dá um erro ou outro. Alguém saberia me disponibilizar sintaxe CORRETA?

 

Agradeço desde já

3 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron
Tera Patron

@BRUNO BANDEIRA 

when record is generated via record producer entry is made into "question_answer" table

Why not use the condition to get the record based on the record sysId?

In "question_answer" table you have Table sys ID field which holds record sysId

If your flow for example is running on incident table then to get the question_answer record you can give that condition

Table sys ID = Trigger -> Record -> SysId

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Thank you for your suport @Ankur Bawiskar, I Just have find a workaround!

View solution in original post

Thank you for your suport @Murthy Ch . I Just have found a workaround!

View solution in original post

4 REPLIES 4

Murthy Ch
Giga Sage

@BRUNO BANDEIRA 
Firstly, querying a "question_answer" table is not recommended because as it contains lot of records. What is the value you need to find? So, that I can give you the efficient approach to get that value.

Thanks,
Murthy

Thank you for your suport @Murthy Ch . I Just have found a workaround!

Ankur Bawiskar
Tera Patron
Tera Patron

@BRUNO BANDEIRA 

when record is generated via record producer entry is made into "question_answer" table

Why not use the condition to get the record based on the record sysId?

In "question_answer" table you have Table sys ID field which holds record sysId

If your flow for example is running on incident table then to get the question_answer record you can give that condition

Table sys ID = Trigger -> Record -> SysId

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you for your suport @Ankur Bawiskar, I Just have find a workaround!