
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2025 12:04 PM
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á
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2025 07:53 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2025 02:29 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2025 02:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2025 06:37 PM
@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.
Murthy

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2025 02:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2025 07:53 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2025 02:29 PM