Hello,
When using a standard "visual" Query object in a report, is it possible to run SQL code referencing custom DB tables, package functions, etc? I know we can already use "provider specific functions" such as {sysdate} in case of using Oracle.
Concretely I wish to compare a visually added field with a custom DB package function returned value as in a classic SELECT, for a Detail filter. I'm using Oracle RDBMS.
I could create the whole logic prepending a SQL object within the visual query, but I'd like to mix both styles within the standard/visual query.
Thank you.