This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Account limitations with Custom Properties

Hello all,

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.