Question
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
Thanks Lee , I was mainly looking for pxRandom() function , how can we use that ? if we use if in column / filter condition in the report defination then Pega OOTB query would not generate ORDER BY RANDOM.VALUE .
Accepted Solution
Add a column to the Report Definition.
pxRandom() returns a double.
You can use @baseclass pyDecimalValue as the property to set.
Then configure the Sort type (ascending vs descending) and order (e.g., 1)
You can use pyDecimalValue in a filter condition if you wish.
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.