View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0007227 | mantisbt | reports | public | 2006-06-23 11:19 | 2024-04-24 12:56 |
Reporter | johnwebbcole | Assigned To | |||
Priority | normal | Severity | feature | Reproducibility | always |
Status | new | Resolution | open | ||
Summary | 0007227: Simple custom report engine for mantis... | ||||
Description | We needed a few custom reports for mantis to do a little analysis of issues pending for releases. I had a very simple sql based report engine that I ported over to PHP and added a custom_report table (and a few look up tables). When we needed a new report, we got the sql working and added to the list. I've gotten permission to give this little tool to the community, so here it is. | ||||
Additional Information | This is a VERY simple report engine, that formats everything in the select statement. You can justify columns by pre-pending R, C, or L_ for right, center, or left justification to the field name. If the form field is not null, then the contents of that column are shown before running the report. Note: there is no security checking, we run this on the intranet behind a firewall. You should protect your reports or check parameters for attacks. We use a few custom fields for determining if a readme note (also a custom field) should be included in our change log (generated from mantis using the fixed_in_version field and the include_in_readme custom field by our build system, NAnt). You will probably need to modify the sql of the existing reports to match your custom fields (for those reports that use them). They are meant to be used as templates rather than working reports. Some of the reports we have are: Resolved Bugs with Resolution Open - used when people update a bug and set it's status to resolved, instead of hitting the resolve bug button. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
You will need to rename the .phx files to php. We put these in a reports directory on the same level as the mantis directory. |
|
Seems your attachements were lost - could you upload them again? Thanks, Peter |
|
I wasn't able to remove the old file links (with the broken attachments), so I uplaoded new ones. |
|
I started working on a very basic plugin that adds custom sql reports: https://github.com/vincentsels/custom-reports |
|