0Runtime Security formula - can I use "inlist" referencing a table from another schema?
I built schema MV_SCHEMA and want to use a formula like this - note the reference to ABC schema:
inList(
$user,
$ABCSuperUserFilter
)
Where $user is, er, the user and $ABCSuperUserFilter is:
query(
ABC.ABC_Security.area_supervisor,
ABC.ABC_Security.username = $user
)
Can I reference ABC from MV_SCHEMA in this formula? I'm getting an "undefined" error now, but am unsure if is me or a limitation of functionality.
-
Hi R. A. Dawson Sr , to your title question, you can reference a table in another schema within a physical table formula column/runtime security filter if that table is on the join path for the current table. Otherwise you want to consider the lookup() function.
For your specific example, it looks like you're on the right track in general (undefined suggests a typo in your session variable name and your syntax is a little off--inList wants a Field for the first argument) but I suggest following the approach/syntax for data security using this article as a reference. Double-check your variable names and case and review that data security article and ping us back if you are still running into issues.
