Solved

Trac - How to do useful reporting in one query....

Posted on 2008-06-16
3
318 Views
Last Modified: 2012-08-13
Hi I am using Trac to manage my bugs for a particular project. The problem is, when I create a report, it only allows for me to do ONE Sql query.

Is there a way to allow multiple queries? What I basically want to do is have a Trac report show the number of open bugs and closed bugs for the week IN ADDITION to a query that pulls up a report of current bugs...

0
Comment
Question by:eecosmo01
3 Comments
 
LVL 21

Expert Comment

by:oleggold
ID: 21899443
In sql You can combine several subqueries with joins to get it to 1 query,one report is genrally a one sql query,just pretty complex one.
If You'd give more details and the code You're using it would be possible to advise You further.
Anyway,subqueries,joined in one sql should provide enough detils for Your report
0
 
LVL 8

Expert Comment

by:mhunts
ID: 22273848
To show open and closed bugs on one report makes sense, but if you want completely different information, such as details of current bugs, then you should write a separate report for that one.

If the field columns are the same, then you could use SQL features such as GROUP BY, but if the columns of data are different, then that really means a separate report.
0
 

Accepted Solution

by:
eecosmo01 earned 0 total points
ID: 22404296
I found out how to do it myself. Basically I had to rewrite the Trac code to accept multiple queries. It was the only way =(
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Creating and Managing Databases with phpMyAdmin in cPanel.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now