Filtering by Asset Objects: Data Center/ Server

Filter Scope (IQL) configuration

The additional filters for Assets custom fields in Advanced Requests Report show all possible Assets objects from the Assets Schema configured for that Assets custom field by default.

In order to access Assets Custom Field Configuration go to Jira administration → Issues → Custom fields (select Assets custom field) → Configure → Edit Assets Configuration (see screenshots below):

Open

Open

If you want to limit the results in the additional filter, you can use the Filter Scope (IQL) configuration setting when configuring the Assets object custom field.

Advanced Requests Report will take the objectType property into account (objectType is case insensitive and any spellings of objectType will be considered - objecttype, OBJECTTYPE, OBjeCtTypE). Several cases are supported and everything else in the IQL Filter Scope will be ignored. The templates are ordered by priority and if one of them is found, the others following it, will not be processed (see the Examples section for more information):

• objectType = “Object Type 1” → The objectType keyword followed by a single space and then the equals (=) sign. There is no limit on how many spaces can follow the equals (=) sign. The value must be surrounded by double quotes (“).

• objectType=“Object Type 1” → The objectType keyword followed immediately by the equals (=) sign. There is no limit on how many spaces can follow the equals (=) sign. The value must be surrounded by double quotes (“).

• objectType IN (“Object Type 1”, “Object Type 2”) → The objectType keyword followed by a single space and then the IN (case insensitive, so you can have IN, in, In or iN) keyword. There is no limit to how many spaces can follow the IN keyword before the opening brackets for listing the values. Each value must be surrounded by double quotes (“).

Examples

• There is no Filter Scope (IQL) configuration set → All Assets Objects created in the Schema will be shown.

• The Filter Scope (IQL) configuration is: objectType = “Object Type 1” → Only Assets objects of type “Object Type 1” will be shown.

• The Filter Scope (IQL) configuration is: objectType=“Object Type 1” → Only Assets objects of type “Object Type 1” will be shown.

• The Filter Scope (IQL) configuration is: objectType = ObjectType1 → All Assets Objects created in the Schema will be shown because the value is not surrounded by double quotes (“). The proper way to configure this use case would be objectType = “ObjectType1”

• The Filter Scope (IQL) configuration is: objectType in (“Object Type 1”, “Object Type 2”) → Only Assets objects of types “Object Type 1” and “Object Type 2” will be shown.

• The Filter Scope (IQL) configuration is: objectType = “Object Type 1” OR objectType in (“Object Type 2”, “Object Type 3”) → Only Assets objects of type “Object Type 1” will be shown because the second objectType clause will be ignored. Only one objectType clause will be resolved based on the priority described in the section above. The proper way to configure this case would be objectType in (“Object Type 1”, “Object Type 2”, “Object Type 3”)

Advanced Requests Report will also take the objectTypeId (objectTypeId is case insensitive and any spellings of objectTypeId will be considered - objecttypeid, OBJECTTYPEID, OBjeCtTypEiD) property into account. The same cases as the ones for the objectType property described above are also valid for the objetTypeId property. The difference with the objectType property is only in the value the objectTypeId property takes. The objectTypeId property supports only numbers and they must be enclosed in quotes otherwise they will not be taken into account.

For example:

• objectTypeId = “9” → Only Assets objects with ID “9” will be shown.

• objectTypeId in (“13“, “18“, “26“) → Only Assets objects with ID “13“ or “18“ or “26“ will be shown.

• objectTypeId = 22 → All Assets Objects created in the Schema will be shown because the objectTypeId clause will be ignored (the number is not enclosed in quotes).

• objectTypeId in (11, 14, 34) → All Assets Objects created in the Schema will be shown because the objectTypeId clause will be ignored (the numbers are not enclosed in quotes).