Question : "Contains" or "Does not Contain" condition against "Journal Input" type field

aizawaken
Tera Guru

Hi Community members,

I have a question of setting IF condition in Workflow.

aizawaken_0-1728959156768.png


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, 

1 ACCEPTED SOLUTION

Omkar Mone
Mega Sage

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

OmkarMukeshMo_0-1728963296033.png

 

View solution in original post

2 REPLIES 2

Omkar Mone
Mega Sage

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

OmkarMukeshMo_0-1728963296033.png

 

aizawaken
Tera Guru

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!