Subquery/Subselect with datagrid

Hi,

Can we not have a subquery/subject in datagrids.yml without going through the whole re-do with PHP process? For eg.

YAML

acme-grid: source: type: orm query: select: - t.id - SELECT id from Oro\Bundle\CaseBundle\Entity\CaseEntity c where c.id = t.caseId from: - { table: AcmeBundle:Table, alias: t }

1 2 3 4 5 6 7 8 9

acme-grid:             source:                 type: orm                 query:                     select:                         - t.id                         - SELECT id from Oro\Bundle\CaseBundle\Entity\CaseEntity c where c.id = t.caseId                     from:                         - { table: AcmeBundle:Table, alias: t }

The reason I’m not doing LEFT join for the same is because this table has too many rows, even with indexes the join is slow and on testing the subquery seems to be faster.

• This topic was modified 5 years, 7 months ago by  oro_newbie.

Topic

[oro_newbieParticipant]

Sorry, this is my mistake. One of my join columns were “string” type. Changed to integer and all works fine now. Make sure you have indexes on your join columns and they are of type integer.

[Author]

Replies