Filter: ProductFilter

Filter type for Product.

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


Input Fields

NameTypeDescription
ANDProductFilter

A field that checks if all filters in the list apply

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

ORProductFilter

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.

absoluteRiskScoreFloat

Checks if absoluteRiskScore equals a specified value.

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

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_gtFloat

Checks if absoluteRiskScore is greater than a specified value.

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_gteFloat

Checks if absoluteRiskScore is greater or equal a specified value.

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_inFloat

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

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_ltFloat

Checks if absoluteRiskScore is less than a specified value.

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_lteFloat

Checks if absoluteRiskScore is less or equal a specified value.

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_notFloat

Checks if absoluteRiskScore does not equal a specified value

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

absoluteRiskScore_not_inFloat

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

The absolute risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

architectures_emptyBoolean

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

architectures_everyStringFilter

Makes sure all items in architectures match a certain filter.

architectures_noneStringFilter

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

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

architectures_someStringFilter

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

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

assets_emptyBoolean

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

assets_everyAssetVersionFilter

Makes sure all items in assets match a certain filter.

assets_noneAssetVersionFilter

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

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

assets_someAssetVersionFilter

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

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

businessUnits_emptyBoolean

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

businessUnits_everyGroupFilter

Makes sure all items in businessUnits match a certain filter.

businessUnits_noneGroupFilter

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

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

businessUnits_someGroupFilter

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

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

children_emptyBoolean

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

children_everyProductFilter

Makes sure all items in children match a certain filter.

children_noneProductFilter

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

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

children_someProductFilter

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

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

compilers_emptyBoolean

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

compilers_everyStringFilter

Makes sure all items in compilers match a certain filter.

compilers_noneStringFilter

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

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

compilers_someStringFilter

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

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

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

createdByUserFilter

Checks if createdBy is not null, and allows to filter based on its fields.

ctxEntityCtxFilter

Allows to filter on the fields of ctx.

Note that ctx is an entity extension and thus can never be null, so specifying null to this filter field has no effect.

deletedAtDateTime

Checks if deletedAt equals a specified value.

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

Timestamp of when this product was deleted

deletedAt_gtDateTime

Checks if deletedAt is greater than a specified value.

Timestamp of when this product was deleted

deletedAt_gteDateTime

Checks if deletedAt is greater or equal a specified value.

Timestamp of when this product was deleted

deletedAt_inDateTime

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

Timestamp of when this product was deleted

deletedAt_ltDateTime

Checks if deletedAt is less than a specified value.

Timestamp of when this product was deleted

deletedAt_lteDateTime

Checks if deletedAt is less or equal a specified value.

Timestamp of when this product was deleted

deletedAt_notDateTime

Checks if deletedAt does not equal a specified value

Timestamp of when this product was deleted

deletedAt_not_inDateTime

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

Timestamp of when this product was deleted

descriptionString

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

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

See also like for a case-insensitive filter.

A description of the product

description_containsString

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

A description of the product

description_ends_withString

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

A description of the product

description_gtString

Checks if description is greater than a specified value.

A description of the product

description_gteString

Checks if description is greater or equal a specified value.

A description of the product

description_inString

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

A description of the product

description_likeString

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

A description of the product

description_ltString

Checks if description is less than a specified value.

A description of the product

description_lteString

Checks if description is less or equal a specified value.

A description of the product

description_notString

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

A description of the product

description_not_containsString

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

A description of the product

description_not_ends_withString

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

A description of the product

description_not_inString

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

A description of the product

description_not_likeString

Checks if description 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);

A description of the product

description_not_starts_withString

Checks if description 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.

A description of the product

description_starts_withString

Checks if description 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.

A description of the product

environmentalControlsEnvironmentalControlsFilter

Allows to filter on the fields of environmentalControls.

Note that environmentalControls is an entity extension and thus can never be null, so specifying null to this filter field has no effect.

groupGroupFilter

Checks if group is not null, and allows to filter based on its fields.

iconString

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

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

See also like for a case-insensitive filter.

URL pointing to an icon associated with this product

icon_containsString

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

URL pointing to an icon associated with this product

icon_ends_withString

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

URL pointing to an icon associated with this product

icon_gtString

Checks if icon is greater than a specified value.

URL pointing to an icon associated with this product

icon_gteString

Checks if icon is greater or equal a specified value.

URL pointing to an icon associated with this product

icon_inString

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

URL pointing to an icon associated with this product

icon_likeString

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

URL pointing to an icon associated with this product

icon_ltString

Checks if icon is less than a specified value.

URL pointing to an icon associated with this product

icon_lteString

Checks if icon is less or equal a specified value.

URL pointing to an icon associated with this product

icon_notString

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

URL pointing to an icon associated with this product

icon_not_containsString

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

URL pointing to an icon associated with this product

icon_not_ends_withString

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

URL pointing to an icon associated with this product

icon_not_inString

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

URL pointing to an icon associated with this product

icon_not_likeString

Checks if icon 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);

URL pointing to an icon associated with this product

icon_not_starts_withString

Checks if icon 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.

URL pointing to an icon associated with this product

icon_starts_withString

Checks if icon 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.

URL pointing to an icon associated with this product

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

imageString

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

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

See also like for a case-insensitive filter.

URL pointing to an image of this product

image_containsString

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

URL pointing to an image of this product

image_ends_withString

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

URL pointing to an image of this product

image_gtString

Checks if image is greater than a specified value.

URL pointing to an image of this product

image_gteString

Checks if image is greater or equal a specified value.

URL pointing to an image of this product

image_inString

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

URL pointing to an image of this product

image_likeString

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

URL pointing to an image of this product

image_ltString

Checks if image is less than a specified value.

URL pointing to an image of this product

image_lteString

Checks if image is less or equal a specified value.

URL pointing to an image of this product

image_notString

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

URL pointing to an image of this product

image_not_containsString

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

URL pointing to an image of this product

image_not_ends_withString

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

URL pointing to an image of this product

image_not_inString

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

URL pointing to an image of this product

image_not_likeString

Checks if image 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);

URL pointing to an image of this product

image_not_starts_withString

Checks if image 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.

URL pointing to an image of this product

image_starts_withString

Checks if image 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.

URL pointing to an image of this product

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.

name_containsString

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

name_ends_withString

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

name_gtString

Checks if name is greater than a specified value.

name_gteString

Checks if name is greater or equal a specified value.

name_inString

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

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).

name_ltString

Checks if name is less than a specified value.

name_lteString

Checks if name is less or equal a specified value.

name_notString

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

name_not_containsString

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

name_not_ends_withString

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

name_not_inString

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

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);

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.

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.

operatingSystems_emptyBoolean

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

operatingSystems_everyOperatingSystemInstanceFilter

Makes sure all items in operatingSystems match a certain filter.

operatingSystems_noneOperatingSystemInstanceFilter

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

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

operatingSystems_someOperatingSystemInstanceFilter

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

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

parentProductFilter

Checks if parent is not null, and allows to filter based on its fields.

processingStatuses_emptyBoolean

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

processingStatuses_everyProcessingStatusFilter

Makes sure all items in processingStatuses match a certain filter.

processingStatuses_noneProcessingStatusFilter

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

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

processingStatuses_someProcessingStatusFilter

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

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

productFamilyProductFamilyFilter

Checks if productFamily is not null, and allows to filter based on its fields.

productIdentifiersProductIdentifiersFilter

Checks if productIdentifiers is not null, and allows to filter based on its fields.

programmingLanguages_emptyBoolean

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

programmingLanguages_everyStringFilter

Makes sure all items in programmingLanguages match a certain filter.

programmingLanguages_noneStringFilter

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

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

programmingLanguages_someStringFilter

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

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

relativeRiskScoreFloat

Checks if relativeRiskScore equals a specified value.

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

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_gtFloat

Checks if relativeRiskScore is greater than a specified value.

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_gteFloat

Checks if relativeRiskScore is greater or equal a specified value.

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_inFloat

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

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_ltFloat

Checks if relativeRiskScore is less than a specified value.

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_lteFloat

Checks if relativeRiskScore is less or equal a specified value.

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_notFloat

Checks if relativeRiskScore does not equal a specified value

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

relativeRiskScore_not_inFloat

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

The relative risk score computed for the Product. This score is an aggregated score of all sub-products and Artifacts associated with the Product.

securityOwnerUserFilter

Checks if securityOwner is not null, and allows to filter based on its fields.

tags_emptyBoolean

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

tags_everyTagFilter

Makes sure all items in tags match a certain filter.

tags_noneTagFilter

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

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

tags_someTagFilter

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

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

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)

urlString

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

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

See also like for a case-insensitive filter.

The URL for the product's homepage, if it has one

url_containsString

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

The URL for the product's homepage, if it has one

url_ends_withString

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

The URL for the product's homepage, if it has one

url_gtString

Checks if url is greater than a specified value.

The URL for the product's homepage, if it has one

url_gteString

Checks if url is greater or equal a specified value.

The URL for the product's homepage, if it has one

url_inString

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

The URL for the product's homepage, if it has one

url_likeString

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

The URL for the product's homepage, if it has one

url_ltString

Checks if url is less than a specified value.

The URL for the product's homepage, if it has one

url_lteString

Checks if url is less or equal a specified value.

The URL for the product's homepage, if it has one

url_notString

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

The URL for the product's homepage, if it has one

url_not_containsString

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

The URL for the product's homepage, if it has one

url_not_ends_withString

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

The URL for the product's homepage, if it has one

url_not_inString

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

The URL for the product's homepage, if it has one

url_not_likeString

Checks if url 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 URL for the product's homepage, if it has one

url_not_starts_withString

Checks if url 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 URL for the product's homepage, if it has one

url_starts_withString

Checks if url 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 URL for the product's homepage, if it has one

vendorVendorFilter

Checks if vendor is not null, and allows to filter based on its fields.


This page was generated: 2024-05-17