- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2024 07:27 PM
Hi Community members,
I have a question of setting IF condition in Workflow.
As above capture, what I want to do is to check by "Contains" against [Quote].[Work notes] field, but I seems not working.
If I do the same "Contains" checking against [Quote].[Short Description], it works.
The difference is data type.
[Quote].[Short Description] is string type, and [Quote].[Work notes] is Journal Input type.
Does anyone know whether "Contains" checking works against Journal Input type field, or not?
If not, are there any other way to do it?
Thanks,
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2024 08:35 PM - edited ‎10-14-2024 08:35 PM
Hello
ServiceNow does not allow filtering or adding conditions on journal fields directly. This is because journal fields are designed to capture a history of entries, and each entry is stored as a separate record in a related list, not directly on the record itself.
As an alternative, why cant you have this Manage approved in a field once the work notes are updated and then write condition on that newly created field?
Also,
in the flow, you can try to look up the sys_journal_field table with the intended value to check and write if the condition on that, but let me warn you, sys_journal_field is a big table, and you might have a performance impact there.
Somthing like below

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2024 08:35 PM - edited ‎10-14-2024 08:35 PM
Hello
ServiceNow does not allow filtering or adding conditions on journal fields directly. This is because journal fields are designed to capture a history of entries, and each entry is stored as a separate record in a related list, not directly on the record itself.
As an alternative, why cant you have this Manage approved in a field once the work notes are updated and then write condition on that newly created field?
Also,
in the flow, you can try to look up the sys_journal_field table with the intended value to check and write if the condition on that, but let me warn you, sys_journal_field is a big table, and you might have a performance impact there.
Somthing like below
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-15-2024 01:01 AM
Hi @Omkar Mone
Thanks for your quick response, and your answer would be a solution of what I want to do!
Let me try it. But your concern for the performance is important, I agree with you, so I will check it carefully.
Anyway, thank you so much!