- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2023 10:55 PM
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2023 11:21 PM
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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2023 11:21 PM
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).