Filter: TestingToolFilter

Filter type for TestingTool.

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


Input Fields

NameTypeDescription
ANDTestingToolFilter

A field that checks if all filters in the list apply

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

ORTestingToolFilter

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

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.

Description of the testing tool

description_containsString

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

Description of the testing tool

description_ends_withString

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

Description of the testing tool

description_gtString

Checks if description is greater than a specified value.

Description of the testing tool

description_gteString

Checks if description is greater or equal a specified value.

Description of the testing tool

description_inString

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

Description of the testing tool

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

Description of the testing tool

description_ltString

Checks if description is less than a specified value.

Description of the testing tool

description_lteString

Checks if description is less or equal a specified value.

Description of the testing tool

description_notString

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

Description of the testing tool

description_not_containsString

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

Description of the testing tool

description_not_ends_withString

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

Description of the testing tool

description_not_inString

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

Description of the testing tool

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

Description of the testing tool

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.

Description of the testing tool

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.

Description of the testing tool

externalReferences_emptyBoolean

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

externalReferences_everyExternalReferenceFilter

Makes sure all items in externalReferences match a certain filter.

externalReferences_noneExternalReferenceFilter

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

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

externalReferences_someExternalReferenceFilter

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

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

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 child entity uniquely within this collection of child entities

id_gtID

Checks if id is greater than a specified value.

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_gteID

Checks if id is greater or equal a specified value.

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_inID

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

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_ltID

Checks if id is less than a specified value.

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_lteID

Checks if id is less or equal a specified value.

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_notID

Checks if id does not equal a specified value

An auto-generated string that identifies this child entity uniquely within this collection of child entities

id_not_inID

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

An auto-generated string that identifies this child entity uniquely within this collection of child entities

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 of the testing tool

name_containsString

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

Name of the testing tool

name_ends_withString

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

Name of the testing tool

name_gtString

Checks if name is greater than a specified value.

Name of the testing tool

name_gteString

Checks if name is greater or equal a specified value.

Name of the testing tool

name_inString

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

Name of the testing tool

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 of the testing tool

name_ltString

Checks if name is less than a specified value.

Name of the testing tool

name_lteString

Checks if name is less or equal a specified value.

Name of the testing tool

name_notString

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

Name of the testing tool

name_not_containsString

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

Name of the testing tool

name_not_ends_withString

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

Name of the testing tool

name_not_inString

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

Name of the testing tool

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 of the testing tool

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 of the testing tool

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.

Name of the testing tool

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

updatedAt_gtDateTime

Checks if updatedAt is greater than a specified value.

The instant this object has been updated the last time

updatedAt_gteDateTime

Checks if updatedAt is greater or equal a specified value.

The instant this object has been updated the last time

updatedAt_inDateTime

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

The instant this object has been updated the last time

updatedAt_ltDateTime

Checks if updatedAt is less than a specified value.

The instant this object has been updated the last time

updatedAt_lteDateTime

Checks if updatedAt is less or equal a specified value.

The instant this object has been updated the last time

updatedAt_notDateTime

Checks if updatedAt does not equal a specified value

The instant this object has been updated the last time

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

vendorString

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

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

See also like for a case-insensitive filter.

The name of the vendor who created the tool

vendor_containsString

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

The name of the vendor who created the tool

vendor_ends_withString

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

The name of the vendor who created the tool

vendor_gtString

Checks if vendor is greater than a specified value.

The name of the vendor who created the tool

vendor_gteString

Checks if vendor is greater or equal a specified value.

The name of the vendor who created the tool

vendor_inString

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

The name of the vendor who created the tool

vendor_likeString

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

The name of the vendor who created the tool

vendor_ltString

Checks if vendor is less than a specified value.

The name of the vendor who created the tool

vendor_lteString

Checks if vendor is less or equal a specified value.

The name of the vendor who created the tool

vendor_notString

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

The name of the vendor who created the tool

vendor_not_containsString

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

The name of the vendor who created the tool

vendor_not_ends_withString

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

The name of the vendor who created the tool

vendor_not_inString

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

The name of the vendor who created the tool

vendor_not_likeString

Checks if vendor 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 vendor who created the tool

vendor_not_starts_withString

Checks if vendor 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 vendor who created the tool

vendor_starts_withString

Checks if vendor 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 vendor who created the tool

versionString

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

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

See also like for a case-insensitive filter.

Version of the testing tool

version_containsString

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

Version of the testing tool

version_ends_withString

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

Version of the testing tool

version_gtString

Checks if version is greater than a specified value.

Version of the testing tool

version_gteString

Checks if version is greater or equal a specified value.

Version of the testing tool

version_inString

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

Version of the testing tool

version_likeString

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

Version of the testing tool

version_ltString

Checks if version is less than a specified value.

Version of the testing tool

version_lteString

Checks if version is less or equal a specified value.

Version of the testing tool

version_notString

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

Version of the testing tool

version_not_containsString

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

Version of the testing tool

version_not_ends_withString

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

Version of the testing tool

version_not_inString

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

Version of the testing tool

version_not_likeString

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

Version of the testing tool

version_not_starts_withString

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

Version of the testing tool

version_starts_withString

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

Version of the testing tool


This page was generated: 2024-11-06