In my scenario, I have a restrictedrole, which, off all the apps, only has access to a customapp (I do not want the restrictedrole to have access to the Search and Reporting app). In the Search and Reporting app, there is a lookuptable and lookupdefinition, both of which have permissions set to Global (all apps), Everyone can Read. However, the dashboard panels in my customapp which reference the lookup_definition fail to run, with:
"Error in 'lookup' command. The lookup table 'lookup_definition' does not exist or is not available."
If I extend the permissions for the Search and Reporting app to include restricted_role, the panels run fine. However, I do not want this role to have access to the Search and Reporting app.
I'm looking for advice for how to resolve this. I know I could create a new lookupfile and lookupdefinition in the custom_app, but, I'd prefer not to have duplicate knowledge objects to maintain. Any advice is welcome. Thank you.
Have you tried creating up a lookup definition in the target app against the global lookup table? Then at least it same underlying file and you won't have maintain 2 copies of the data.
I have had good luck on global lookups by creating them using the outputlookup command. If above doesn't work, try making a copy of table using outputlookup and point a lookup definition from each app at the new file.