Open for Voting
over 1 year ago

Better Dashboard and Advanced Search Options

How it works now

It is a very manual process to add items to search queries. You have to do it one at a time, scrolling through drop-down menus for each one.

Proposed changes

Add a string field that we can copy from and paste to. Adding items from the drop-down menus would add text to the string field. Copying that text to a new query would add the items to the list.Obviously you would need data validation for this.

Business Case

It's a lot easier to update and manipulate a text string than it is to hunt and peck for items in a drop-down menu. It would also give us the ability to share search queries and dashboards without being an Admin, simply by copying the query "code" and sending that via email.

Parents
  • There are a few changes that I would like to see with advanced search.

    • Allow for the use of a logic statement more than just all of these or these. I would like the ability to give each line a boolean (true/false), use parentheses to group lines, and the existing and/or operators.
    • The ability to say give me results where field A = field B (where client is not creator)
    • Filtering on custom fields is a nightmare. We have a field that is set to A, B, or C. The options to filter on that are is A, B, or C. There is no way for me to tell if there was an entry error and we have something set to 'a.'
Comment
  • There are a few changes that I would like to see with advanced search.

    • Allow for the use of a logic statement more than just all of these or these. I would like the ability to give each line a boolean (true/false), use parentheses to group lines, and the existing and/or operators.
    • The ability to say give me results where field A = field B (where client is not creator)
    • Filtering on custom fields is a nightmare. We have a field that is set to A, B, or C. The options to filter on that are is A, B, or C. There is no way for me to tell if there was an entry error and we have something set to 'a.'
Children
No Data