gtm.workqueue Properties

gtm.workqueue.handleOrderByClause

26A

When set to false, work queue will display an error when a "order by" clause is present in the saved query.

When set to true, work queue will support the "order by" clause in the saved query given the SQL is in the format (only using spaces and not tabs):

select  <optional hints /*+ > <list of columns with/without- distinct/unique keyword> from <comma-separated table_names with alias> where(optional) <can include subquery/exists/not exists/union etc> order by(optional)

The first table after "from" keyword should be the table name of the object type for which the saved query is created, followed by the standard alias for that table.

There should be only one "order by" clause, at the end of the query.

Default: false