datagrid.yml with subselect

Hello guys,
is it possible to create a datagrid configuration that generates a query similar to the one above ?

SELECT id, ..., num_field, (SELECT COUNT(id)+1 FROM tableName t2 WHERE t1.num_field < t2.num_field) as rank FROM tableName t1

1 2 3 4

SELECT id, ..., num_field, (SELECT COUNT(id)+1 FROM tableName t2 WHERE t1.num_field < t2.num_field) as rank FROM tableName t1

“tableName” is the same table.
I need the subquery to get the rank of the record

Thank you !

Topic

[RodolfoParticipant]

Hi, check this:

https://github.com/orocrm/platform/blob/master/src/Oro/Bundle/DataGridBundle/Resources/doc/backend/extensions/totals.md

[Author]

Replies