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

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 6.20.0
    • Component/s: Scripted Fields
    • Labels:
      None
    • Sprint:
      SR4J Sprint 92
    • Critical Points:
      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

            Assignee:
            jechlin Jamie Echlin
            Reporter:
            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