Thread

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

What dialect of SQL does the custom reporting engine use? RSS Feed

Monday, February 11, 2013
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.
Tags:
(To Reply to this thread you first need to Sign-In)
2 Replies
Adam SAdam S
re: Mike Onderdonk on Monday, February 11, 2013
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
(To Reply to this thread you first need to Sign-In)
Mike OnderdonkMike Onderdonk
re: Adam S on Monday, February 11, 2013
Monday, February 11, 2013
Adam, thanks for the quick reply.  This is exactly what I needed.
(To Reply to this thread you first need to Sign-In)
Tagged
Statistics
  • Started: 2/11/2013
  • Last Reply: 2/11/2013
  • Replies: 2
  • Views: 565
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.