Picklists for parameters in stored procedure based views
Hi there, if this is not the right place to submit a feature request please let me know!
I would like to put forward an enhancement request to allow picklists for the parameters in views based on stored procedures to make things easier for the end user.
One of our stored proc views is to generate frequency rate calculations. In short, it is a way of measuring and comparing how often certain types of events happen, such as lost time injuries, restricted work injuries, total recordable injuries etc.
At present, the user must type in the frequency rate types that they want to view in the report, such as LTIFR, RWIFR, TRIFR.
There is a finite number of options they can choose from, and they can choose more than one. An input may be LTIFR, RWIFR or simply LTIFR itself.
It would be great if they could instead choose these from a picklist. We currently have 15 options.
In this particular view, every parameter except the start and end date come from a short list of options which never change.
A couple of extra points:
- The user should also be able to type options in - they shouldn't be forced to use the picklist
- It would be great to have hints available for each option so if they mouse over, they get a description of each available option e.g. for LTIFR they would mouse over and see "Lost time injury frequency rate".
Please let me know if any further information is required!