Inflectra Customer Forums: Custom Queries for Reports (Thread)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?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/540.aspxthreadId=540Vanessa Smith (vanessa.smith@flhosp.org)Custom Queries for ReportsIs 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?Fri, 15 Mar 2013 12:22:12 -04002013-04-02T13:36:35-04:00/Support/Forum/spirateam/issues-questions/540.aspxmessageId=996David J (support1@inflectra.com) Hi Vanessa We're using a form of query language called Entity Framework SQL (ESQL) provided 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 Fri, 15 Mar 2013 19:06:19 -04002013-03-15T19:06:19-04:00/Support/Forum/spirateam/issues-questions/540.aspx#reply996messageId=1011Vanessa Smith (vanessa.smith@flhosp.org)Thanks Adam. Is it possible to access or define Standard Fields Filters for use in Custom queries? 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? Tue, 02 Apr 2013 13:36:35 -04002013-04-02T13:36:35-04:00/Support/Forum/spirateam/issues-questions/540.aspx#reply1011