Question
4
Replies
328
Views
Virtusa
Posted: May 30, 2019
Last activity: May 30, 2019
Closed
Solved
Report Definition Customization
Hi ,
Can we customize report definition any way to form the below query , Sort or Group By forms ORDER BY ASC/DESC , How can we add ORDER BY DBMS_RANDOM.VALUE
SELECT * FROM schema.tablename ORDER BY DBMS_RANDOM.VALUE
basically I am trying to aviod using connet-sql rule and see if any option using Report Definition
pxRandom() is an OOTB SQL Function. You can order query results using a randomly generated number.
As for "SELECT * FROM schema.tablename", you can define an Int- class in an Int ruleset adding property names that match the table's column names.
Since this is an external database you need to define a Data-Admin-DB-Name record.
Then define a Data-Admin-DB-Table record that associates the Int- class to your table name within that external database.
Then define a Report Definition against that Int- class.