ListGrid Customize 'SELECT COUNT' for ListGrid Pagination

[zatix]

Hi folks,

I wondering to know a way to customize the SELECT COUNT executed by the ListGrid component before make pagination.

I need specifically this

SELECT /*+ PARALLEL(HISTORY_ENTRY,6) */ COUNT(1)

I already modified the DataSource xml but it not works.

Is it possible?

Best regards

Romero

[Isomorphic]

There isn't currently a way to modify the pieces of auto-generated SQL for doing paginated queries (these differ by DB, and even the different pieces of them have to differ by DB). However, you could use <customSQL> to do your own pagination by including SELECT COUNT and other SQL in your SQL template, and using dsRequest.startRow/endRow in your template, after turning off the built-in pagination (see operationBinding.sqlPaging).