Inflectra Customer Forums: What dialect of SQL does the custom reporting engine use? (Thread)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.en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/503.aspxthreadId=503Mike Onderdonk (mike.onderdonk@hmhco.com)What dialect of SQL does the custom reporting engine use?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.Mon, 11 Feb 2013 18:34:26 -05002013-02-11T20:56:06-05:00/Support/Forum/spirateam/issues-questions/503.aspxmessageId=932David J (support1@inflectra.com) Hi Mike The reporting engine doesn't use a database-specific SQL implementation, instead it 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 Mon, 11 Feb 2013 20:31:20 -05002013-02-11T20:31:20-05:00/Support/Forum/spirateam/issues-questions/503.aspx#reply932messageId=934Mike Onderdonk (mike.onderdonk@hmhco.com)Adam, thanks for the quick reply. This is exactly what I needed.Adam, thanks for the quick reply. This is exactly what I needed.Mon, 11 Feb 2013 20:56:06 -05002013-02-11T20:56:06-05:00/Support/Forum/spirateam/issues-questions/503.aspx#reply934