The following threads have been tagged with 'SQL'

14 Threads
 
Reporting queries... or a "Spira db for Dummies"
Where is the best place to find a reference guide to the Spira db ? We have created a nu...
3 posts
4521 views
FYI: how to create a report the outputs JavaScript object data
FYI, here is how to create a report that puts data into a JavaScript object. (It uses the out-of-th...
Generating reports across multiple projects?
We're trying to gather data across projects, but SpiraTeam does not provide portfolio functionali...
1 posts
3725 views
FYI: workaround for report sql and the error "System.Xml.XmlException: The '#' character, hexadecimal value 0x23, cannot be included in a name."
FYI: If you are writing report SQLand run into the following error: "System.Xml.XmlException: The...
1 posts
3422 views
Report Displaying Projects, Project Groups and Releases
We had a request from a customer looking for a custom report with the following information: We ...
SQL Server question
Hi, We have a new Enterprise SQL Server Cluster designed to host disparate application databa...
1 posts
2473 views
Custom Report Query to Find Tasks Linked to Deleted Requirements
We had a customer that was looking for a custom report to find all of the Tasks in SpiraTeam that a...
Connect to a secure database and execute queries using Rapise
Hi, I would like to connect to a database which requires login credentials. I was trying diffe...
1 posts
2039 views
Date Compare in ESQL Query
Im trying to do a date comparison in my custom query so that I can create a report that always repo...
3 posts
1913 views
Custom report of test cases linked to incidents
A customer asked how to write a custom Entity SQL report that displayed: Incident ID Incident St...
Creating a custom graph or report with time as function
Hi! Im looking for a way to create a burndown chart from all the test cases not in Passed, grouped...
1 posts
857 views
Creating a form for custom reports
Dear All, I would like to ask You, if there is an option to create a form when generating the repo...
3 posts
572 views
Default reports' SQL queries
Dear All, I have a question connected to the default reports. I can see all the templates but no ...
1 posts
547 views