Filter: SecurityAdvisoryFilter

Filter type for SecurityAdvisory.

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


Input Fields

NameTypeDescription
ANDSecurityAdvisoryFilter

A field that checks if all filters in the list apply

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

ORSecurityAdvisoryFilter

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.

createdAtDateTime

Checks if createdAt equals a specified value.

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

The instant this object has been created

createdAt_gtDateTime

Checks if createdAt is greater than a specified value.

The instant this object has been created

createdAt_gteDateTime

Checks if createdAt is greater or equal a specified value.

The instant this object has been created

createdAt_inDateTime

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

The instant this object has been created

createdAt_ltDateTime

Checks if createdAt is less than a specified value.

The instant this object has been created

createdAt_lteDateTime

Checks if createdAt is less or equal a specified value.

The instant this object has been created

createdAt_notDateTime

Checks if createdAt does not equal a specified value

The instant this object has been created

createdAt_not_inDateTime

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

The instant this object has been created

idID

Checks if id equals a specified value.

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

An auto-generated string that identifies this root entity uniquely among others of the same type

id_gtID

Checks if id is greater than a specified value.

An auto-generated string that identifies this root entity uniquely among others of the same type

id_gteID

Checks if id is greater or equal a specified value.

An auto-generated string that identifies this root entity uniquely among others of the same type

id_inID

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

An auto-generated string that identifies this root entity uniquely among others of the same type

id_ltID

Checks if id is less than a specified value.

An auto-generated string that identifies this root entity uniquely among others of the same type

id_lteID

Checks if id is less or equal a specified value.

An auto-generated string that identifies this root entity uniquely among others of the same type

id_notID

Checks if id does not equal a specified value

An auto-generated string that identifies this root entity uniquely among others of the same type

id_not_inID

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

An auto-generated string that identifies this root entity uniquely among others of the same type

securityAdvisoryIdString

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

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

See also like for a case-insensitive filter.

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_containsString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_ends_withString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_gtString

Checks if securityAdvisoryId is greater than a specified value.

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_gteString

Checks if securityAdvisoryId is greater or equal a specified value.

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_inString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_likeString

Matches securityAdvisoryId 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 securityAdvisoryId, it can be used for the literal prefix (the part until the first placeholder).

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_ltString

Checks if securityAdvisoryId is less than a specified value.

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_lteString

Checks if securityAdvisoryId is less or equal a specified value.

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_notString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_not_containsString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_not_ends_withString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_not_inString

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

The ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_not_likeString

Checks if securityAdvisoryId 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 ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_not_starts_withString

Checks if securityAdvisoryId 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 ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

securityAdvisoryId_starts_withString

Checks if securityAdvisoryId 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 ID of the security advisory from its original reporting source, e.g. "ICSMA-19-274-01"

typeSecurityAdvisoryType

Checks if type equals a specified value.

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

The type or security advisory

type_inSecurityAdvisoryType

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

The type or security advisory

type_notSecurityAdvisoryType

Checks if type does not equal a specified value

The type or security advisory

type_not_inSecurityAdvisoryType

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

The type or security advisory

updatedAtDateTime

Checks if updatedAt equals a specified value.

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

The instant this object has been updated the last time (not including relation updates)

updatedAt_gtDateTime

Checks if updatedAt is greater than a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_gteDateTime

Checks if updatedAt is greater or equal a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_inDateTime

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

The instant this object has been updated the last time (not including relation updates)

updatedAt_ltDateTime

Checks if updatedAt is less than a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_lteDateTime

Checks if updatedAt is less or equal a specified value.

The instant this object has been updated the last time (not including relation updates)

updatedAt_notDateTime

Checks if updatedAt does not equal a specified value

The instant this object has been updated the last time (not including relation updates)

updatedAt_not_inDateTime

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

The instant this object has been updated the last time (not including relation updates)


This page was generated: 2024-10-16