Hi All,
I have a requirement to provide
record-level access based on the role hierarchy. For this purpose, I have created list filters from the top-level role to the lowest level, such as Manager 1, Manager 2, … up to Manager 6.However, I am facing the following issues while implementing this logic:
- When I use a Left Join in the recipe, the recipe takes a long time to process and eventually fails.
- When I use Lookup (Multivalue), I receive the following warning:
“One or more cell values of the Mgr4Name field exceeded 32000 characters in length and had to be truncated in node OUTPUT0.”
The Mgr4Name field contains not more than 1,906 characters, which is causing the multivalue field to exceed the 32,000-character limit.
I have attached the recipe screenshot for reference. I have applied multivalue lookup join from 'Role ID Rung 1' to 'Role ID Rung 6' join.
Could you please suggest an efficient approach or alternative logic to implement the role-hierarchy-based record access while avoiding the 32,000-character truncation warning and ensuring the recipe completes successfully?
Write an answer...
0/9000