Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > What dialect of SQL does ...

What dialect of SQL does the custom reporting engine use?

Monday, February 11, 2013

monderdonk

I'm able to create some basic SQL SELECT statements to access the reportable entities in SpiraTeam and use in custom reports, but was wondering what is the full range of commands supported? In other words is there support for character conversions, mathematical functions, etc.

2 Replies

Monday, February 11, 2013

inflectra.david

re: monderdonk Monday, February 11, 2013

Hi Mike

The reporting engine doesn't use a database-specific SQL implementation, instead it uses Microsoft Entity SQL that queries the object representations of the database.

For more details, take a look at: http://msdn.microsoft.com/en-us/library/bb387118.aspx

Regards

Adam

Monday, February 11, 2013

monderdonk

re: inflectra.david Monday, February 11, 2013

Adam, thanks for the quick reply. This is exactly what I needed.

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: Monday, February 11, 2013
Last Reply: Monday, February 11, 2013
Replies: 2
Views: 7065

What dialect of SQL does the custom reporting engine use?

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

Edit Thread

Edit Message

Search Results