Filter: ProductFilter

Filter type for Product.

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

Product

Input Fields

Name	Type	Description
AND	ProductFilter	A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects.
OR	ProductFilter	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.
absoluteRiskScore	Float	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_gt	Float	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_gte	Float	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_in	Float	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_lt	Float	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_lte	Float	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_not	Float	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_in	Float	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_empty	Boolean	Checks if `architectures` is an empty list (true) or a non-empty list or null (false).
architectures_every	StringFilter	Makes sure all items in `architectures` match a certain filter.
architectures_none	StringFilter	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_some	StringFilter	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_empty	Boolean	Checks if `assets` is an empty list (true) or a non-empty list or null (false).
assets_every	AssetVersionFilter	Makes sure all items in `assets` match a certain filter.
assets_none	AssetVersionFilter	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_some	AssetVersionFilter	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_empty	Boolean	Checks if `businessUnits` is an empty list (true) or a non-empty list or null (false).
businessUnits_every	GroupFilter	Makes sure all items in `businessUnits` match a certain filter.
businessUnits_none	GroupFilter	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_some	GroupFilter	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_empty	Boolean	Checks if `children` is an empty list (true) or a non-empty list or null (false).
children_every	ProductFilter	Makes sure all items in `children` match a certain filter.
children_none	ProductFilter	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_some	ProductFilter	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_empty	Boolean	Checks if `compilers` is an empty list (true) or a non-empty list or null (false).
compilers_every	StringFilter	Makes sure all items in `compilers` match a certain filter.
compilers_none	StringFilter	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_some	StringFilter	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.
createdAt	DateTime	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_gt	DateTime	Checks if `createdAt` is greater than a specified value. The instant this object has been created
createdAt_gte	DateTime	Checks if `createdAt` is greater or equal a specified value. The instant this object has been created
createdAt_in	DateTime	Checks if `createdAt` is equal to one of the specified values. The instant this object has been created
createdAt_lt	DateTime	Checks if `createdAt` is less than a specified value. The instant this object has been created
createdAt_lte	DateTime	Checks if `createdAt` is less or equal a specified value. The instant this object has been created
createdAt_not	DateTime	Checks if `createdAt` does not equal a specified value The instant this object has been created
createdAt_not_in	DateTime	Checks if `createdAt` is not equal to one of the specified values. The instant this object has been created
createdBy	UserFilter	Checks if `createdBy` is not null, and allows to filter based on its fields.
ctx	EntityCtxFilter	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.
deletedAt	DateTime	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_gt	DateTime	Checks if `deletedAt` is greater than a specified value. Timestamp of when this product was deleted
deletedAt_gte	DateTime	Checks if `deletedAt` is greater or equal a specified value. Timestamp of when this product was deleted
deletedAt_in	DateTime	Checks if `deletedAt` is equal to one of the specified values. Timestamp of when this product was deleted
deletedAt_lt	DateTime	Checks if `deletedAt` is less than a specified value. Timestamp of when this product was deleted
deletedAt_lte	DateTime	Checks if `deletedAt` is less or equal a specified value. Timestamp of when this product was deleted
deletedAt_not	DateTime	Checks if `deletedAt` does not equal a specified value Timestamp of when this product was deleted
deletedAt_not_in	DateTime	Checks if `deletedAt` is not equal to one of the specified values. Timestamp of when this product was deleted
description	String	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_contains	String	Checks if `description` contains a specified string, case-sensitively. A description of the product
description_ends_with	String	Checks if `description` ends with a specified string, case-sensitively. A description of the product
description_gt	String	Checks if `description` is greater than a specified value. A description of the product
description_gte	String	Checks if `description` is greater or equal a specified value. A description of the product
description_in	String	Checks if `description` is equal to one of the specified values. A description of the product
description_like	String	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_lt	String	Checks if `description` is less than a specified value. A description of the product
description_lte	String	Checks if `description` is less or equal a specified value. A description of the product
description_not	String	Checks if `description` does not equal a specified string, case-sensitively. A description of the product
description_not_contains	String	Checks if `description` does not contain a specified string, case-sensitively. A description of the product
description_not_ends_with	String	Checks if `description` does not end with a specified string, case-sensitively. A description of the product
description_not_in	String	Checks if `description` is not equal to one of the specified values. A description of the product
description_not_like	String	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_with	String	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_with	String	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
environmentalControls	EnvironmentalControlsFilter	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.
group	GroupFilter	Checks if `group` is not null, and allows to filter based on its fields.
icon	String	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_contains	String	Checks if `icon` contains a specified string, case-sensitively. URL pointing to an icon associated with this product
icon_ends_with	String	Checks if `icon` ends with a specified string, case-sensitively. URL pointing to an icon associated with this product
icon_gt	String	Checks if `icon` is greater than a specified value. URL pointing to an icon associated with this product
icon_gte	String	Checks if `icon` is greater or equal a specified value. URL pointing to an icon associated with this product
icon_in	String	Checks if `icon` is equal to one of the specified values. URL pointing to an icon associated with this product
icon_like	String	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_lt	String	Checks if `icon` is less than a specified value. URL pointing to an icon associated with this product
icon_lte	String	Checks if `icon` is less or equal a specified value. URL pointing to an icon associated with this product
icon_not	String	Checks if `icon` does not equal a specified string, case-sensitively. URL pointing to an icon associated with this product
icon_not_contains	String	Checks if `icon` does not contain a specified string, case-sensitively. URL pointing to an icon associated with this product
icon_not_ends_with	String	Checks if `icon` does not end with a specified string, case-sensitively. URL pointing to an icon associated with this product
icon_not_in	String	Checks if `icon` is not equal to one of the specified values. URL pointing to an icon associated with this product
icon_not_like	String	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_with	String	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_with	String	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
id	ID	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_gt	ID	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_gte	ID	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_in	ID	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_lt	ID	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_lte	ID	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_not	ID	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_in	ID	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
image	String	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_contains	String	Checks if `image` contains a specified string, case-sensitively. URL pointing to an image of this product
image_ends_with	String	Checks if `image` ends with a specified string, case-sensitively. URL pointing to an image of this product
image_gt	String	Checks if `image` is greater than a specified value. URL pointing to an image of this product
image_gte	String	Checks if `image` is greater or equal a specified value. URL pointing to an image of this product
image_in	String	Checks if `image` is equal to one of the specified values. URL pointing to an image of this product
image_like	String	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_lt	String	Checks if `image` is less than a specified value. URL pointing to an image of this product
image_lte	String	Checks if `image` is less or equal a specified value. URL pointing to an image of this product
image_not	String	Checks if `image` does not equal a specified string, case-sensitively. URL pointing to an image of this product
image_not_contains	String	Checks if `image` does not contain a specified string, case-sensitively. URL pointing to an image of this product
image_not_ends_with	String	Checks if `image` does not end with a specified string, case-sensitively. URL pointing to an image of this product
image_not_in	String	Checks if `image` is not equal to one of the specified values. URL pointing to an image of this product
image_not_like	String	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_with	String	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_with	String	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
name	String	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_contains	String	Checks if `name` contains a specified string, case-sensitively.
name_ends_with	String	Checks if `name` ends with a specified string, case-sensitively.
name_gt	String	Checks if `name` is greater than a specified value.
name_gte	String	Checks if `name` is greater or equal a specified value.
name_in	String	Checks if `name` is equal to one of the specified values.
name_like	String	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_lt	String	Checks if `name` is less than a specified value.
name_lte	String	Checks if `name` is less or equal a specified value.
name_not	String	Checks if `name` does not equal a specified string, case-sensitively.
name_not_contains	String	Checks if `name` does not contain a specified string, case-sensitively.
name_not_ends_with	String	Checks if `name` does not end with a specified string, case-sensitively.
name_not_in	String	Checks if `name` is not equal to one of the specified values.
name_not_like	String	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_with	String	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_with	String	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_empty	Boolean	Checks if `operatingSystems` is an empty list (true) or a non-empty list or null (false).
operatingSystems_every	OperatingSystemInstanceFilter	Makes sure all items in `operatingSystems` match a certain filter.
operatingSystems_none	OperatingSystemInstanceFilter	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_some	OperatingSystemInstanceFilter	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.
parent	ProductFilter	Checks if `parent` is not null, and allows to filter based on its fields.
processingStatuses_empty	Boolean	Checks if `processingStatuses` is an empty list (true) or a non-empty list or null (false).
processingStatuses_every	ProcessingStatusFilter	Makes sure all items in `processingStatuses` match a certain filter.
processingStatuses_none	ProcessingStatusFilter	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_some	ProcessingStatusFilter	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.
productFamily	ProductFamilyFilter	Checks if `productFamily` is not null, and allows to filter based on its fields.
productIdentifiers	ProductIdentifiersFilter	Checks if `productIdentifiers` is not null, and allows to filter based on its fields.
programmingLanguages_empty	Boolean	Checks if `programmingLanguages` is an empty list (true) or a non-empty list or null (false).
programmingLanguages_every	StringFilter	Makes sure all items in `programmingLanguages` match a certain filter.
programmingLanguages_none	StringFilter	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_some	StringFilter	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.
relativeRiskScore	Float	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_gt	Float	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_gte	Float	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_in	Float	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_lt	Float	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_lte	Float	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_not	Float	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_in	Float	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.
securityOwner	UserFilter	Checks if `securityOwner` is not null, and allows to filter based on its fields.
tags_empty	Boolean	Checks if `tags` is an empty list (true) or a non-empty list or null (false).
tags_every	TagFilter	Makes sure all items in `tags` match a certain filter.
tags_none	TagFilter	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_some	TagFilter	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.
updatedAt	DateTime	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_gt	DateTime	Checks if `updatedAt` is greater than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_gte	DateTime	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_in	DateTime	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_lt	DateTime	Checks if `updatedAt` is less than a specified value. The instant this object has been updated the last time (not including relation updates)
updatedAt_lte	DateTime	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_not	DateTime	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_in	DateTime	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)
url	String	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_contains	String	Checks if `url` contains a specified string, case-sensitively. The URL for the product's homepage, if it has one
url_ends_with	String	Checks if `url` ends with a specified string, case-sensitively. The URL for the product's homepage, if it has one
url_gt	String	Checks if `url` is greater than a specified value. The URL for the product's homepage, if it has one
url_gte	String	Checks if `url` is greater or equal a specified value. The URL for the product's homepage, if it has one
url_in	String	Checks if `url` is equal to one of the specified values. The URL for the product's homepage, if it has one
url_like	String	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_lt	String	Checks if `url` is less than a specified value. The URL for the product's homepage, if it has one
url_lte	String	Checks if `url` is less or equal a specified value. The URL for the product's homepage, if it has one
url_not	String	Checks if `url` does not equal a specified string, case-sensitively. The URL for the product's homepage, if it has one
url_not_contains	String	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_with	String	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_in	String	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_like	String	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_with	String	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_with	String	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
vendor	VendorFilter	Checks if `vendor` is not null, and allows to filter based on its fields.

This page was generated: 2024-11-06

Filter: ProductFilter

Related Types

Input Fields