I get a problem trying to set up an account limitation on NPM with pattern.
I want my account to see only nodes where custom properties TEST is equal to "AAA" and is empty.
I've went to Account Limitation Builder, add the custom properties TEST with pattern and try a lot of things ("ISNULL AND *AAA*", " * EXCEPT *BBB* ", etc.).
I'm for sure missing something because I can easily get the "AAA" but can't get the empty part.
Could someone give me some help here ?
Thanks in advance
There is no way to do empty values in the account limitation builder. This has to do with how SQL works, it won't directly compare null values against real values and behind the scenes the web ui is sanitizing your sql input and forming it into a LIKE statement.