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

Ability for search keyword to match multiple Search Attribute/Columns in Database Picker Script Field

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Done
    • Low
    • Resolution: Done
    • None
    • 6.20.0
    • Script Fields
    • None
    • SR4J Sprint 92
    • 0.5

    Description

      Currently, the Database Picker Script Field Search Attribute only accepts one attribute.

      As a user,
      I need to be able to search a Database Picker Script Field with a keyword that matches multiple Search Attributes/Column.
      So that I can return all entries (usually names) which match my search term across multiple attributes.

      Sample Use Case

      I have a database with the following columns
      Project table:
      ID, Pname, Pkey, ProjectType

      For example table:

      ID Pname Pkey PType
      1 IT Service Management ITSM Service Desk
      2 Scrum Project SC Software

      Now, when I set the Search attribute to pname and search the field with the keyword 'Scrum', my search result would return 1 scrum project. 

      Once this feature request is implemented, it should be possible to set multiple attributes/columns as the search attribute. For example, when I set the Search attribute to be pname and Ptype I should be able to search using project name and project type*.* 

      Attachments

        Activity

          People

            jechlin Jamie Echlin
            aomar Amirul Omar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 1 minute
                1m
                Remaining:
                Remaining Estimate - 1 minute
                1m
                Logged:
                Time Spent - Not Specified
                Not Specified