Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-5126

Query Analytics Dashboard: Search by query substring or dimension

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.10.0
    • Component/s: PMM UI
    • Labels:
    • Story Points:
      3
    • Sprint:
      Platform Sprint 23
    • Needs Review:
      Yes
    • Needs QA:
      Yes
    • Needs Packaging:
      No
    • Needs Doc:
      Yes

      Description

      The problem: 

      We  need an additional Search filter for the full-text search against  "Dimension" (Query, Server  name, Use, etc  )

      UX: 

      Use cases: 

      • as a PMM User, I need to be able to search by QueryID so that I can easily find query I was working before and saved it's ID 
      • As a PMM User, I need to be able to search by part of Query fingerprint or Service Name or other dimensions together with applied filters so that I can narrow my search in QAN 

      DoD

      • In addition to selected filters user can search by part of the text in value of Dimension selected for presentation in QAN 
      • User can enter part of Query ID  key when they looking into Query dimension view 

      Out Of Scope

      •   nice error / "404 message" with suggestions to remove some filters or etc. 

       

      DOC:

      • Updates screens for QAN 
      • the feature mentioned in ou rQAN documentation 

      ----------------

      In PMM v1 we had ability to search by query abstract substring, like described in the doc here: https://www.percona.com/doc/percona-monitoring-and-management/qan.html

       

      In PMM v2 there is no such search bar, and I do not see any ability to filter queries based on some substring / query pattern. PMM v2 documentation still says it's possible to do this: https://www.percona.com/doc/percona-monitoring-and-management/2.x/qan-filtering.html On screenshot there is "Search by Query Abstract, Fingerprint or ID" 

       

      Was this search field removed intentionally, or this is some bug? This was very useful thing and I can't believe it was removed

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              debug Mikhail Solovyev
              Votes:
              3 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 3 days
                  3d

                    Smart Checklist