Not able to GlideRecord from Journal Entries table

Shikha12
Tera Contributor

Hi All,

 

I have created a flow designer that will trigger a notification based on the work notes present on record.

When I tested that flow in nonprod I was able to run the flow successfully and it was able to query from the sys_journal_field table and trigger the notification.

 

But in my production instance, it somehow din't find any record from the sys_journal_field  table even though record exist, because of that it didn't send the notification.

 

It was also not GlideRecording from the sys_journal_field  table in the mail script.

 

The only difference I see I had admin rights in the nonprod instance and in the Prod instance I do not have admin rights.

When I am querying manually the sys_journal_field   table it is showing me 0 records.

 

Does access impact the querying from the sys_journal_field   table? If so how I can fix that so it queries the record correctly from the sys_journal_field   table in my flow and mail script?

 

Thanks in Advance.

 

1 ACCEPTED SOLUTION

OlaN
Giga Sage
Giga Sage

Hi,

If the Flow is run by You (a user without admin access) then yes it would matter.

You can bypass this and set the Flow to run as system user (which should have access to all records in all tables).

Flow-run-as-user.png

View solution in original post

1 REPLY 1

OlaN
Giga Sage
Giga Sage

Hi,

If the Flow is run by You (a user without admin access) then yes it would matter.

You can bypass this and set the Flow to run as system user (which should have access to all records in all tables).

Flow-run-as-user.png