-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
10.3.4, 10.3.5, 10.3.6
-
2
-
Severity 3 - Minor
-
9
-
Issue Summary
Selecting "Show my related objects" does not return the expected objects in a legacy Assets object's custom field. However, it works well on 5.12.x and on the non-legacy Assets object custom field
Steps to Reproduce
- For easy replication, create an Assets IT Service Management project with sample data.
- Create an Assets object (multiple) (legacy) custom field.
- Configure the field accordingly. We can leave everything as it is and configure just the object schema and object type root.
- Using the sample data, we can choose Business Services as the object type root.
- Make sure the field shows up in the issue screen for testing.
- Go to the issue screen, find the custom field and click on the Browse icon next to it.
- On the pop-up where objects are listed, click on the "Show my related objects".
Expected Results
There is a list of expected objects, which is the same or a subset of the objects visible when browsing the Assets User Information, which is available in the user's profile page. This works on 5.12.x.
Actual Results
The expected objects are not showing up.
No objects are available to be selected even though the user-related objects exist.
- This POST /rest/insight/1.0/customfield/deprecated/<FieldId>/objects with "filterUserObjects":true in the payload returns 0 results
- findObjectsByInsightCustomField method is returning this exception Could not get objects for AQL
2025-05-23 14:01:32,255+0000 http-nio-8080-exec-64 url: /jsm/rest/insight/1.0/customfield/deprecated/10520/objects; user: admin WARN admin 841x1667x2 1twfnhn 10.228.166.17,172.50.0.2 /rest/insight/1.0/customfield/deprecated/10520/objects [c.r.j.p.i.s.c.dal.impl.DeprecatedCustomFieldDalImpl] Could not get objects for AQL: objectType IN objectTypeAndChildren("22") AND objectSchemaId = 2 AND "Support" = "admin" OR "JIRA User" = "admin" OR "User Access" = "admin" OR "Manager" = "admin" OR "Service Group Email" = "admin@localhost" OR "Service Group" IN ("jira-administrators","jira-servicedesk-users") OR "Group Permission" IN ("jira-administrators","jira-servicedesk-users") and customFieldConfigId: 10520
Workaround
- Instead of selecting the object from the list of related objects, search and enter the object key directly. The object can still be selected, it's just not visible as the user's related object.
- As the legacy field is deprecated, replace it with the Assets object field.
The "Show my related objects" option on non-legacy Assets object custom field works differently than the one in legacy Assets object custom field. On the legacy field, selecting the "Show my related objects" option would launch a search on User, Group and Email attribute types with the user related information i.e. user key, email address, group memberships and group permissions. Here's an example AQL we could see with debug on com.riadalabs.jira.plugins.insight.services.core.iql enabled.
objectType IN objectTypeAndChildren("23") AND objectSchemaId = 3 AND "Manager" = JIRAUSER10000 OR "User Access" = JIRAUSER10000 OR "JIRA User" = JIRAUSER10000 OR "Support" = JIRAUSER10000 OR "Service Group Email" = "admin@nowhere" OR "Service Group" IN ("jira-administrators","jira-servicedesk-users","jira-software-users") OR "Group Permission" IN ("jira-administrators","jira-servicedesk-users","jira-software-users")
On non-legacy field, the AQL looks only with the user's user key under anyAttribute. For example,
objectSchemaId IN ("3") AND objectType IN objectTypeAndChildren("23") AND anyAttribute = JIRAUSER10000
Having said that, using the non-legacy Assets object custom field, only objects that are related to the user directly with the user key will show up with "Show my related objects" option selected. Hence when using this option on a non-legacy field, fewer objects than the list in the user profile might be available.
Versions Tested
Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below:
Testing Requirements | Version | Affected Version |
---|---|---|
Customers Reported Version | 10.3.4 | Yes |
Most Recent Bug-Fix Release | ||
Previous Major Release | ||
Most Recent LTS | 10.3.6 | Yes |
Previous Supported LTS | 5.12.23 | No |
Other Versions.. | ||
(Add rows as needed) |
- links to
[JSDSERVER-16233] Selecting "Show my related objects" does not return the expected objects on a legacy Assets object's custom field
UIS | New: 9 |
Support reference count | Original: 1 | New: 2 |
Status | Original: Needs Triage [ 10030 ] | New: Gathering Impact [ 12072 ] |
Support reference count | New: 1 |
Labels | New: ril |
Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 1023117 ] |