Filter: OrganizationalEntityFilter

Filter type for OrganizationalEntity.

All fields in this type are and-combined; see the or field for or-combination.


Input Fields

NameTypeDescription
ANDOrganizationalEntityFilter

A field that checks if all filters in the list apply

If the list is empty, this filter applies to all objects.

OROrganizationalEntityFilter

A field that checks if any of the filters in the list apply.

If the list is empty, this filter applies to no objects.

Note that only the items in the list or-combined; this complete OR field is and-combined with outer fields in the parent filter type.

contact_emptyBoolean

Checks if contact is an empty list (true) or a non-empty list or null (false).

contact_everyOrganizationalContactFilter

Makes sure all items in contact match a certain filter.

contact_noneOrganizationalContactFilter

Makes sure none of the items in contact match a certain filter.

Note that you can specify the empty object for this filter to make sure contact has no items.

contact_someOrganizationalContactFilter

Makes sure at least one of the items in "contact" matches a certain filter.

Note that you can specify the empty object for this filter to make sure contact has at least one item.

nameString

Checks if name equals a specified string, case-sensitively.

If an index exists on name, it can be used.

See also like for a case-insensitive filter.

The name of the organization

name_containsString

Checks if name contains a specified string, case-sensitively.

The name of the organization

name_ends_withString

Checks if name ends with a specified string, case-sensitively.

The name of the organization

name_gtString

Checks if name is greater than a specified value.

The name of the organization

name_gteString

Checks if name is greater or equal a specified value.

The name of the organization

name_inString

Checks if name is equal to one of the specified values.

The name of the organization

name_likeString

Matches name against a pattern case-insensitively with the following placeholders:

% matches any sequence of characters, including the empty string; _ matches exactly one character; \ can be used to escape the placeholders (use \\ for a literal backslash);

If an index exists on name, it can be used for the literal prefix (the part until the first placeholder).

The name of the organization

name_ltString

Checks if name is less than a specified value.

The name of the organization

name_lteString

Checks if name is less or equal a specified value.

The name of the organization

name_notString

Checks if name does not equal a specified string, case-sensitively.

The name of the organization

name_not_containsString

Checks if name does not contain a specified string, case-sensitively.

The name of the organization

name_not_ends_withString

Checks if name does not end with a specified string, case-sensitively.

The name of the organization

name_not_inString

Checks if name is not equal to one of the specified values.

The name of the organization

name_not_likeString

Checks if name does not match a pattern case-insensitively with the following placeholders:

% matches any sequence of characters, including the empty string; _ matches exactly one character; \ can be used to escape the placeholders (use \\ for a literal backslash);

The name of the organization

name_not_starts_withString

Checks if name does not start with a specified string, case-sensitively.

Never uses an index. Consider using not_like (with the % placeholder) for a case-insensitive filter that can use an index.

The name of the organization

name_starts_withString

Checks if name starts with a specified string, case-sensitively.

Never uses an index. Consider using like (with the % placeholder) for a case-insensitive filter that can use an index.

The name of the organization

url_emptyBoolean

Checks if url is an empty list (true) or a non-empty list or null (false).

url_everyStringFilter

Makes sure all items in url match a certain filter.

url_noneStringFilter

Makes sure none of the items in url match a certain filter.

Note that you can specify the empty object for this filter to make sure url has no items.

url_someStringFilter

Makes sure at least one of the items in "url" matches a certain filter.

Note that you can specify the empty object for this filter to make sure url has at least one item.


This page was generated: 2024-11-06