Fix the Advanced Search feature
Fix the Advanced Search feature with the following improvements:
- open the search in a modal window so we can see all the criteria in the search
- provide functionality to change the order of criteria
- Include previously used queries dropdown (either customizable or most recent X queries)
- return the closing parenthesis
- add a "power user" option for people to include their own SQL queries
Deron Staffen
shared this idea
AdminJohn Fulton
(Director of Product Management, SmartSimple, Foundant Technologies)
responded
Good usability suggestions, the only item not under consideration is the last one with the ability to leverage a user's SQL
-
Brett Otto
commented
Of the suggestions listed above, the ability to insert SQL code for more complex reports is the MOST important. Right now I struggle with report writer and spend hours figuring out how to get data, knowing that I could write a SQL statement that would pull what I need in a few minutes. This could be a true time saver that would allow users to create true "power reports".