Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-16892

Referenced Object AQL Failed due to large number objects for reference attribute 

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • Assets - AQL
    • None

      Issue Summary

      If the referenced object attributes with the same name (e.g "referencedAttr") exist in many object types/child object types. Searching "referencedAttr = xx" could return 500 errors due to the query is executed in large number of object types.

      Steps to Reproduce

      1. Create a parent object type and enable inheritance on the parent.
      2. Create a reference object type attribute on parent (e.g "referencedAttr")
      3. Create many child object types (probably more than 100 child)
      4. Search "referencedAttr = xx"

      Expected Results

      Return results and respond with 200

      Actual Results

      Return 500

      Workaround

      Instead of searching across the entire parent object type, narrow the search to a smaller subset of object types/ child object types.

              89b86d167962 Manisha Singla
              2bdae6840bc9 Yunhan Li
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 55m
                  55m