Question
3
Replies
77
Views
Virtusa
Posted: March 20, 2019
Last activity: March 30, 2019
Closed
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
Posted: 1 year ago
Hi ,
My requirement is not to sellect ALL but to add "ORDER BY DBMS_RANDOM.VALUE" to the query , just like Sorting
please refer to the link below to SELECT ALL Rows from table
https://community1.pega.com/community/product-support/question/select-all-option-report-definition