Hello,
I would like to know if it is possible to use a query designed with Query Designer in a quick report?
Thanks in advance.
Best answer by Charith Epitawatta
View original
Query Designer in a quick report
Userlevel 7
+31
Hi
I checked this in a 22R1 reference environment and it seems you cannot use queries from Query Designer in quick reports. In the ‘Type’ field, you can specify “Query Builder” as the type, but then you get an error message as follows that states Query Builder quick reports are no longer supported.
In the documentation, you can find the ways you can utilize queries.
Quick Reports are not listed here.
Hope this helps!
Userlevel 3
+5
Not at the moment, but is something R&D will be looking to support in the future. You can consume a QD projection via Lobby and Custom projection (i.e. Custom Page) at the moment (22R1).
In version 23R1 it is possible to create Quick Reports using Query Designer.
Here's a little nasty workaround to 22R2:
- With the following SQL query you can generate the SQL code using the "Query Name":
-
SELECT IFSAPP.Query_Designer_Sql_Util_API.Generate_Sql_Statement('QueryName') AS Query FROM dual - The result of the query returns a Select statement, which can be used in a quick report.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.