Group heading not shown for first group in report if group is empty

[Ryan J Ollos]

For example, report {3}:

The group heading with value NULL is shown when it's not the first heading:

And it works correctly when there is only one group heading that is not a NULL value:

r10384 added or (empty), but not for the first heading.

[Ryan J Ollos]

One proposed change in [9f25cdfb3/rjollos.git].

When the group heading is NULL, it would be nice if Milestone (empty) was shown rather than just (empty). We could add an isnull function for each connection class and modify the reports. For example, on SQLite for report {3} we'd have:

-   'Milestone '||milestone AS __group__,
+   'Milestone '||ifnull(milestone,'(empty)') AS __group__,

I don't think it would be worth fixing up existing reports through a database upgrade step, but we could modify the reports in the database to affect new installations and add a note to TracUpgrade about how to manually modify reports.

[Ryan J Ollos]

Second issue described in comment:2 will be investigated in #12848.

[Jun Omae]

Replying to Ryan J Ollos:

For example, on SQLite for report {3} we'd have:

-   'Milestone '||milestone AS __group__,
+   'Milestone '||ifnull(milestone,'(empty)') AS __group__,

If '(empty)' is embedded in the report, (empty) cannot be translated.

[Ryan J Ollos]

Committed to 1.2-stable in r16056, merged to trunk in r16057.