I've added a field to my default record type and I'd like to display the field to the end user on the main form of the record type.
I want to populate the field with a single value (int) that is result of a fairly complex SQL query.
What is the best way to have CQ run the query dynamically each time the record is viewed by the end user?
Or should I ask the DBA to somehow populate the database column for me using PL/SQL?
I'd like to use CQ if at all possible. One thing to note is that the SQL query will access other tables in the CQ user database.
Daabase type is Oracle.