The following threads have been tagged with 'sql'

16 Threads
 
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...
1 posts
17876 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
16675 views
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
13041 views
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
10592 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...
Report Displaying Projects, Project Groups and Releases
We had a request from a customer looking for a custom report with the following information: We ...
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...
SQL Server question
Hi, We have a new Enterprise SQL Server Cluster designed to host disparate application databa...
1 posts
7248 views
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
6322 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
5706 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
5484 views
Workflow validation idea
Another interesting idea is to execute sql code during the transition and if it returns zero, than ...
2 posts
2838 views
Invalid database revision expected v676 installed v674
Good afternoon, I have a problem after migrating from spirateam to another server. The same executa...
1 posts
2648 views
Custom report for latest test results per release
In order to get the current state of test case execution in specified release, an ESQL query is req...
1 posts
2098 views
Requirement Summary Graph code
Dear community, I have an application that would be interesting to create a graph similar to the s...
2 posts
1757 views
Displaying pageof 2