Thread

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

Custom Queries for Reports RSS Feed

Friday, March 15, 2013
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
Adam SAdam S
re: Vanessa Smith on Friday, March 15, 2013
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

Vanessa SmithVanessa Smith
re: Adam S on Friday, March 15, 2013
Tuesday, April 2, 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?  
Tagged
Statistics
  • Started: 3/15/2013
  • Last Reply: 4/2/2013
  • Replies: 2
  • Views: 1984
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.