Custom Queries for Reports

Friday, March 15, 2013
Avatar
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
Avatar
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
Avatar
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: 9592