0

Runtime 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.  

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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.

    Like 1
Like Follow
  • 13 days agoLast active
  • 1Replies
  • 16Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available