Question4Replies287Views Adithya_Acharya Member since 2012 52 posts Virtusa Posted: May 30, 2019Last activity: May 30, 2019 Closed Solved Report Definition CustomizationHi ,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.VALUESELECT * FROM schema.tablename ORDER BY DBMS_RANDOM.VALUEbasically I am trying to aviod using connet-sql rule and see if any option using Report Definition Low-Code App Development Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agopedel PEGA replied to Adithya_AcharyapxRandom() 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. Posted: 1 year agoAdithya_Acharya Virtusa replied to pedelThanks 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 Posted: 1 year agopedel PEGA replied to Adithya_AcharyaAdd 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. Posted: 1 year agoAdithya_Acharya Virtusa replied to pedelThanks Lee , it worked .