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 originalHello,
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 originalHi
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!
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:
SELECT IFSAPP.Query_Designer_Sql_Util_API.Generate_Sql_Statement('QueryName') AS Query FROM dual
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.