Improve the cascadeOption JQL function to search for the child value without having to specify the parent value

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: JQL
    • None
    • 0
    • 7

      Issue statement

      There is no way to search for only the (child value) in a cascade select using cascadeOption JQL function.

      This is confirmed by the documentation for the function, and only lists (parent), or, (parent)(child) search type - JQL Reference: cascadeOption()

      This can be a problem when we are trying to build a JQL query to search for a child value from cascading field, when this field contains a high number of parent option.

      Currently, the only way to search for a while value is to search for both the parent and the child value combination, resulting in a very long query, for example:

      yourCustomField IN cascadeOption("Option A", "Value A1") OR yourCustomField IN cascadeOption("Option B", "Value A1")  OR yourCustomField IN cascadeOption("Option C", "Value A1")  OR yourCustomField IN cascadeOption("Option D", "Value A1") OR etc...

      Suggestion

      Improve the cascadeOption JQL function, so that it allows to only search for the child value without having to specify the parent value.

      Workaround

      If the childOption string is not a value for parentOption as well, then the following JQL can be used:

      yourCascadingCustomField in ("childOptionValue")
      

            Assignee:
            Unassigned
            Reporter:
            Julien Rey (Inactive)
            Votes:
            8 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated: