Inflectra Customer Forums: ESQL and custom selection filters (Thread) Our requirements have a custom selection filter that specifies type of Requirement Documents (User Needs, Functional Requirements, Regulatory and so on). When generating a standard Requirements Detailed Report I can choose the Req Type (or, more precise, Document type) and generate the required document. However, we are using ESQL to generate a specific format of the report and the selection is no longer available. What is the way to invoke report generating filtering with custom ESQL? en-US(C) Copyright 2006-2026 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/reports/2373.aspxthreadId=2373Vladimir Plotkin (vladimir.plotkin@midiagnostics.com)ESQL and custom selection filters Our requirements have a custom selection filter that specifies type of Requirement Documents (User Needs, Functional Requirements, Regulatory and so on). When generating a standard Requirements Detailed Report I can choose the Req Type (or, more precise, Document type) and generate the required document. However, we are using ESQL to generate a specific format of the report and the selection is no longer available. What is the way to invoke report generating filtering with custom ESQL? Thu, 15 Apr 2021 10:32:17 -04002024-11-12T03:51:50-05:00/Support/Forum/spirateam/reports/2373.aspxmessageId=3948David J (adam.sandman+support@inflectra.com) Hi Vlad Im afraid that is not possible at present. You can filter by Release only for custom (ESQL Hi Vlad Im afraid that is not possible at present. You can filter by Release only for custom (ESQL) reports. Standard sections that have customized XSLT can have the custom field filters. Another option coming soon is support for ODATA that will let you run custom reports in other tools such as PowerBI and Excel. Regards David Thu, 15 Apr 2021 13:55:04 -04002021-04-15T13:55:04-04:00/Support/Forum/spirateam/reports/2373.aspx#reply3948messageId=3950Vladimir Plotkin (vladimir.plotkin@midiagnostics.com) Thank you. Looks like we would have to create a special kind of reports in ESQL - one for each typ Thank you. Looks like we would have to create a special kind of reports in ESQL - one for each type of a document. I was hoping to avoid that. Thu, 15 Apr 2021 14:50:29 -04002021-04-15T14:50:29-04:00/Support/Forum/spirateam/reports/2373.aspx#reply3950messageId=3991Ilia Poliakov (ilya.polyakov@edetek.com) Yep, I am waiting for these features too. Moreover the option that support suggests (use BI too Yep, I am waiting for these features too. Moreover the option that support suggests (use BI tool and Odata) is available only for SpiraPlan version that is more expensive than SpiraTeam. Mon, 12 Jul 2021 07:53:44 -04002021-07-12T07:53:44-04:00/Support/Forum/spirateam/reports/2373.aspx#reply3991messageId=7013Erik Swedlund (erik.swedlund@ascom.com) Do we have an update on this feature? Do we have an update on this feature? Mon, 28 Oct 2024 11:54:21 -04002024-10-28T11:54:21-04:00/Support/Forum/spirateam/reports/2373.aspx#reply7013