Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-3996

Allow Database Picker Fields queries to allow a value to be specified from a field on the issue.

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Done
    • High
    • Resolution: Done
    • None
    • 6.6.0
    • None
    • None
    • SR4J Sprint 71, SR4J Sprint 72, SR4J Sprint 73, SR4J Sprint 74, SR4J Sprint 75, SR4J Sprint 76, SR4J Sprint 77, SR4J Sprint 78, SR4J Sprint 79, SR4J Sprint 80, SR4J Sprint 81, SR4J Sprint 82
    • 7.1

    Description

      When creating the SQL query to select the issues for a database picker field, it would be good to be able to specify fields from the issue in the field in order to only select values to be returned that match a value on the issue to constrain the number of results returned.

      An example of this would be having a query below where we only return results where the customer name matches the value in the custom field with the id of customfield_1234.

      example query:

      select name from customer where name = ${customfield_1234}

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. SRJIRA-4127 database picker fields missing highlighting info when searching

          • High - Serious problem that could block progress.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. SRJIRA-4138 previewing an editable script field does not show current value

          • High - Serious problem that could block progress.
          • Done
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SRJIRA-3653 Database Picker field - feedback

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Done

          New Feature - A new feature of the product, which has yet to be developed. SRJIRA-3774 Allow the use of $issue.customfield_1 or $issue.key in Issue Picker

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Done
          is related to

          New Feature - A new feature of the product, which has yet to be developed. SRJIRA-4409 Database picker field items delimiter

          • Low - Minor problem or easily worked around.
          • Triage
          mentioned in

          Page Loading...

          Activity

            People

              jechlin Jamie Echlin
              kwalker Kristian Walker
              Votes:
              2 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: