search

Pretius / apex-nested-reports

Pretius APEX Nested Reports
http://http://apex.pretius.com/apex/f?p=105:NESTED_REPORTS
MIT License
38 stars 8 forks source link

More a question than an issue #29

Open StormingMovies opened 4 years ago

StormingMovies commented 4 years ago

In the query details, is there a way to setup a dynamic returning query? I am in need to change the query depending on some factors, and make it automated so I do not need to have several DAs querying for specific factor and depending on that which query to use. if I use something like " return 'select 1 from dual'; " it says that the query must start with select or with, which is not the case, since I am using a return to get a dynamic query. Thanks!

bostrowski commented 4 years ago

Hi @StormingMovies

yes the current version of the plug-in supports only static SQL query.

StormingMovies commented 4 years ago

Hi! Is there a chance that a future version will support dynamic returns? Thank you!

bostrowski commented 4 years ago

@StormingMovies There won't be future version of Pretius Nested Reports under my name so I can't answer this question - I'm no longer Pretius employee.

But I can tell you that I'm working on premium version of the plug-in which will incllude dynamic SQL (and much much more).