Report templates cloned from those created on XUL client causing error or producing different results
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
High
|
Unassigned | ||
3.1 |
Fix Released
|
High
|
Unassigned | ||
3.2 |
Fix Released
|
High
|
Unassigned | ||
3.3 |
Fix Released
|
High
|
Unassigned |
Bug Description
This is related to fix in bug 1642344.
We deployed the fix and started to see issues.
Cloning process seems fine. Without updating anything the template can be saved.
When running reports from the cloned templates, there were errors complaining of either lacking field in Group By or missing From clause.
When cloning the templates, removing then putting back the complained fields solved the issue (report can run).
Some cloned templates seem working fine. But the results do not match those generated from the XUL templates.
It seems the issue is related to how the tables are joined. On the report interface, I do not see join type on templates cloned from XUL templates. But if I replace a field, I see join type. When I create a template from scratch I see the join type when choosing a field from a linked table.
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
tags: | added: reports |
Changed in evergreen: | |
milestone: | 3.3-beta1 → 3.3-rc |
Changed in evergreen: | |
milestone: | 3.3-rc → 3.3.1 |
Changed in evergreen: | |
assignee: | nobody → Dan Wells (dbw2) |
milestone: | 3.3.1 → none |
tags: | added: pullrequest |
tags: |
added: needsdiscussion removed: pullrequest |
Changed in evergreen: | |
assignee: | nobody → Dan Wells (dbw2) |
tags: | added: signedoff |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
Attached are two examples templates in 3 states: before being clone, cloned without editing, cloned with replaced fields from linked tables (following the same path).