Report Variable Forms

[tracsubmission@…]

This is basically a request for an enhancement to the report variables.

Basically what I was thinking off was something like the following: Instead of supplying a variable in the query like so:

priority='$PRIORITY'

You can (optionally) make it like so:

priority='${PRIORITY#Ticket Priority}'

Then what it would do is in case you specified it as above, and one of those variables are not set it would display a form (populated by those that are set), allowing you to enter values for them.

A few more suggestions regarding this would be default values, example:

priority='${PRIORITY#Ticket Priority#normal}'

This would give this one a default value.

Lists:

priority='${PRIORITY#Ticket Priority[low,lowest,normal,high,highest]#normal}'

This one would be a select list, with default value normal.

The reason I ask for this is the fact that our managers use the system to file requests and track how they come along. They many times want to see reports for specific periods, or types, etc. Many of them don't really grasp the url editing thing, and have asked countless times for forms.

What we eventually did was create HTML pages which allows displaying of the forms, and these pages link back to the reports.

It would be really nice though to be able to quickly create them by editing report queries.

One could even go as far as allowing a separate input field, and have the query list variables like priority='$PRIORITY' , and have the this other input field define variables. If undefined they act as they do now, if defined they display a form.

Example for variables $PRIORITY, $KEYWORDS:

PRIORITY.TYPE=list
PRIORITY.LIST=[low,lowest,normal,high,highest]
PRIORITY.DEFAULT=normal

KEYWORDS.TYPE=text
KEYWORDS.DEFAULT=

A few suggestions. Hope it was useful and understandable.

[Christian Boos]

Nice proposal.

[Christian Boos]

Milestone 2.0 deleted

[Remy Blank]

Report variables can be edited in a form in the report view since 0.12 (#7293). It's not yet as fancy as described here (no explicit label, no default value, no lists). The missing functionality could be added, PatchWelcome.

[Christian Boos]

Milestone triaging deleted