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.

    Details

    • Type: New Feature
    • Status: Done (View Workflow)
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 6.6.0
    • Component/s: None
    • Labels:
      None
    • Sprint:
      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
    • Critical Points:
      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

            Structure

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Structure Helper Panel