Query in Flow Designer Condition

[BRUNO BANDEIRA]

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á

[Ankur Bawiskar · Accepted solution]

@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.

[BRUNO BANDEIRA · Accepted solution]

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

[Murthy Ch]

@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.

[BRUNO BANDEIRA · Accepted solution]

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

[Ankur Bawiskar · Accepted solution]

@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.

[BRUNO BANDEIRA · Accepted solution]

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