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

AQL - compare values, support Attribute Placeholders in AQL

XMLWordPrintable

    • 1
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem definition

      AQL search that can compare attribute values, between an object attribute and an attribute from its referenced object, is not currently implemented.

      For example:

      • We have an object type "Sim card", which has "Cost Center" attribute (text value)
      • This same object type "Sim card" has reference to "Owner" user object.
      • "Owner" user object also has "Cost Center" attribute.
      • AQL that tries to find objects having different value in "Cost Center" attribute and in the referenced object's "Cost Center" attribute, does not give expected values:
        "Cost Center" != "Owner"."Cost Center"

      At the same time, the placeholders cannot be used in this case. This will not work:

      Name != ${Attribute Y.Name} 

      Suggested resolution

      Implement support for comparing attribute values with referenced attribute values, not only strings.
      Implement support for attribute placeholders in AQL.

              Unassigned Unassigned
              da0dd4439f59 Alex Cooksey
              Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated: