Existence

Search for InfoObjects that do or do not have a certain property.

Example

• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_DESCRIPTION != NULL

  (finds objects with a Description property—the result will include objects whose Description property has either a specified value or an empty value)

• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_DESCRIPTION = NULL

  (finds objects without a Description property)

Note:    Using NULL as a search criteria is different from using an empty value as a search criteria. The following queries retrieve objects that have a Description property, but whose value may or may not be empty:

• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_DESCRIPTION = ''

  (finds objects whose Description property has an empty value)

• SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_DESCRIPTION != ''

  (finds objects whose Description property has a non-empty value)