Security Filter with INTERSECT need HELP

Hello, really need some help.
I have a user table with a manually added list of “resource ids” that they will be allowed to update.
Then I have a table of Scope items with the “list of resource ids” that will be used for that scope item.
I was trying to drop an INTERSECT in the security filter, and I’ve even tried count, and i’m just not getting anywhere… It’s starting to feel buggy

    ISNOTBLANK(
	INTERSECT(
    LIST()+[_THISROW].[scope_metadata_list],
    LIST()+USERPERM_CURRENT[userperm_ANY_tags]
    )
    )

Also here is a video of my setup if you think it will help. @Steve I know you’ve been hitting this particular area hard, and even alerted me of the bug. Do you have any input?

0 16 511
16 REPLIES 16
Top Labels in this Space