Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-16233

Selecting "Show my related objects" does not return the expected objects on a legacy Assets object's custom field

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 10.3.4, 10.3.5, 10.3.6

      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

      1. For easy replication, create an Assets IT Service Management project with sample data.
      2. Create an Assets object (multiple) (legacy) custom field.
      3. 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.
      4. Make sure the field shows up in the issue screen for testing.
      5. Go to the issue screen, find the custom field and click on the Browse icon next to it.
      6. 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)    

        1. image-2025-05-27-09-36-45-559.png
          36 kB
          Michelle Chin
        2. image-2025-05-27-09-36-56-243.png
          76 kB
          Michelle Chin

            [JSDSERVER-16233] Selecting "Show my related objects" does not return the expected objects on a legacy Assets object's custom field

            SET Analytics Bot made changes -
            UIS New: 9
            SET Analytics Bot made changes -
            Support reference count Original: 1 New: 2
            Benjamin Suess made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            SET Analytics Bot made changes -
            Support reference count New: 1
            Security Metrics Bot made changes -
            Labels New: ril
            Security Metrics Bot made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 1023117 ]
            Michelle Chin created issue -

              Unassigned Unassigned
              michin Michelle Chin
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated: