How to create a custom report?

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
leongtmnn
TestLink user
Posts: 4
Joined: Tue Mar 23, 2021 7:22 pm

How to create a custom report?

Post by leongtmnn »

How do you create your own reports? Is there a collection of existing custom reports somewhere?
Creating a custom report is my task right now but none of the tutorials / steps in TL documentation seem to work as theyre all outdated (often referencing folders that don't exist)
Would it be possible to create a configurable report where the user can create a report with the data he chooses?

Thanks for any help with this.
fman
Member of TestLink Community
Posts: 3110
Joined: Tue Nov 15, 2005 7:19 am

Re: How to create a custom report?

Post by fman »

The only way to create a custom report is to write it from scratch.
My suggestion is to understand what is the data you want to extract, create the queries (views, store procedures) and use Grafana as visualization tool.
This approach has some minor drawbacks:
- you will need to create your users also in Grafana and will not inherit the test project/test plan permissions
- you will need to use another tool/system (Grafana)

But due to the power of Grafana you will be able to do things that will be difficult using PHP and the testlink code.
Using views, and store procedures you will be able to extract the data and then choose where to display it:
an excel (I hope no :( ), Grafana or any other visualization tool.

I'm using this approach on TESISQUARE (www.tesisquare.com) to govern the certification cycles of TESISQUARE PLATFORM.
leongtmnn
TestLink user
Posts: 4
Joined: Tue Mar 23, 2021 7:22 pm

Re: How to create a custom report?

Post by leongtmnn »

fman wrote: Tue Mar 30, 2021 7:21 pm The only way to create a custom report is to write it from scratch.
My suggestion is to understand what is the data you want to extract, create the queries (views, store procedures) and use Grafana as visualization tool.
This approach has some minor drawbacks:
- you will need to create your users also in Grafana and will not inherit the test project/test plan permissions
- you will need to use another tool/system (Grafana)

But due to the power of Grafana you will be able to do things that will be difficult using PHP and the testlink code.
Using views, and store procedures you will be able to extract the data and then choose where to display it:
an excel (I hope no :( ), Grafana or any other visualization tool.

I'm using this approach on TESISQUARE (www.tesisquare.com) to govern the certification cycles of TESISQUARE PLATFORM.
Thanks for the reply fman. Unfortunately I think implementing another tool like Grafana would go beyond the scope of my project. I will continue to try to extract all the necessary data through the available excel reports that TestLink provides automatically and assemble the data with VBA in excel, especially because my result should be an automated powerpoint-presentation.

Cheers
fman
Member of TestLink Community
Posts: 3110
Joined: Tue Nov 15, 2005 7:19 am

Re: How to create a custom report?

Post by fman »

Using Grafana is not complicated and a good investment, while the excel way is ... well not a good thing to do IMHO.
Post Reply