Skip to Content
0
Jul 20, 2016 at 05:43 PM

How to check if an attribute IS NOT present

97 Views

Hello everyone,

So I have a fun one... As part of my current project, I need to write a query to check if a particular attribute is not assigned. Not NULL, but not a part of the IDM entry (as in an attribute that was once populated and was removed via {D})

So in essence, I want to see all entries (MX_PERSON to be exact) that do not have a given attribute(s). In my case it's MX_FIRSTNAME, MX_LASTNAME, and DISPLAYNAME. We have a process that's blanking those out, causing some issues so we need to go find and fix them.

If someone has a better way of considering this problem, I'm open to that too! 😊

I'm running this project on Oracle, but if you come up with something in MS SQL, hopefully I can work with it.

Thanks for your help!

Cheers,

Matt