Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Custom Queries for Report...

Custom Queries for Reports

Friday, March 15, 2013

vsmith

Is it possible to create calculated fields, use data manipulation functions, use agrregate functions, etc. using SQL within the report custom query sections? I can't seem to get get things like count(), or group by to work - is there a reference standard available for this?

2 Replies

Friday, March 15, 2013

inflectra.david

re: vsmith Friday, March 15, 2013

Hi Vanessa

We're using a form of query language called Entity Framework SQL (ESQL) provided by Microsoft's Entity Framework (EF). So if you search on Microsoft's websites there should be a trove of information. For example: http://msdn.microsoft.com/en-us/library/bb738626.aspx

Here's some examples:

Aggregate Canonical Functions

Discusses aggregate Entity SQL canonical functions.

Math Canonical Functions: Discusses math Entity SQL canonical functions.

String Canonical Functions: Discusses string Entity SQL canonical functions.

Date and Time Canonical Functions: Discusses date and time Entity SQL canonical functions.

Bitwise Canonical Functions: Discusses bitwise Entity SQL canonical functions.

Other Canonical Functions: Discusses functions not classified as bitwise, date/time, string, math, or aggregate.

Regards

Adam

Tuesday, April 2, 2013

vsmith

re: inflectra.david Friday, March 15, 2013

Thanks Adam. Is it possible to access or define Standard Fields Filters for use in Custom queries? I am looking to report across Project Groups, based on a custom Implementation Date field on the Release artifact. I can copy the Release Summary Report and customize it, but can't get access across Project Groups. I can create a new Custom Report, but then don't have input fields for the user to select from. Is this possible, or planned as an enhancement?

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Friday, March 15, 2013
Last Reply: Tuesday, April 2, 2013
Replies: 2
Views: 9500

Custom Queries for Reports

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results