OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM OroCRM – How do I? Questions Subquery/Subselect with datagrid

This topic contains 1 reply, has 1 voice, and was last updated by oro_newbie oro_newbie 1 year, 10 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #37465
    oro_newbie
    oro_newbie
    Participant

    Hi,

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

    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 1 year, 10 months ago by oro_newbie oro_newbie.
Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #37467
    oro_newbie
    oro_newbie
    Participant

    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.

Viewing 1 replies (of 1 total)

The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No