OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

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 11 months, 3 weeks ago.

  • 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 11 months, 3 weeks 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)

You must be logged in to reply to this topic.

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

Yes No