When one sets a runtime parameter in a report for credit or debit type, the dropdown one gets at runtime only includes the description. In many cases it'd be helpful to also include the code itself.
Created attachment 184602 [details] [review] Bug 40500: Include credit and debit codes in runtime dropdown To test: 1 - save and run a sql query using both debit type and credit type parameters 2 - run your report and see your dropdowns only include desciptions 3 - apply patch, restart services 4 - re-run your report and see your dropdowns have both the description and the code
Created attachment 184603 [details] [review] Bug 40500: Include credit and debit codes in runtime dropdown To test: 1 - save and run a sql query using both debit type and credit type parameters 2 - run your report and see your dropdowns only include desciptions 3 - apply patch, restart services 4 - re-run your report and see your dropdowns have both the description and the code
Nick suggested this would make sense as an option to be set in the parameter, applicable to all types of parameters. Something like "<<Debit type|debit_types:show_codes". This sounds like a good approach, but is more complicated than I can figure out just now. The current options ":in" and ":all" are exclusive so the code only knows how to take one option at a time. We'd want to be able to combine ":show_code" with either of the other two options.