This topic contains 1 reply, has 2 voices, and was last updated by ibratsilo 6 years, 3 months ago.
- Topic
Hello,
I’m trying to add email body search filter for emails in OroEmailBundle.
I added a filter to email-grid via my custom bundle datagrid.yml12345datagrids:email-grid:filters:columns:body_content: { type: string, data_name: eb.textBody, label: 'Body' }base-email-grid has the following configuration
123456789101112datagrids:base-email-grid:source:query:select:...- eb.textBody AS body_content...join:left:- { join: e.emailBody, alias: eb }...But when searching the query is different and I’m getting the following error:
(obfuscated for readability)123456789101112131415[Semantical Error] line 0, col 581 near 'eb.textBody LIKE': Error: 'eb' is not defined.SELECT eu.id as _groupByPart0 FROM OroEmailBundle:EmailUser euLEFT JOIN eu.email eLEFT JOIN eu.folders fLEFT JOIN f.origin oWHERE o.isActive = true AND ((eu.id IN(SELECT MAX(u.id)FROM OroEmailBundle:EmailUser uINNER JOIN OroEmailBundle:Email mWITH u.email = m.idWHERE m.thread IS NOT NULL AND ((u.owner = 1 AND u.organization = 1) OR u.mailboxOwner IN(1))GROUP BY m.thread)) OR (e.thread IS NULL AND e.head = TRUE))AND ((eu.owner = :owner AND eu.organization = :organization) OR eu.mailboxOwner IN(:mailboxIds))AND e.internal_status = :internalStatusName1585151019AND eb.textBody LIKE :bodycontent571887603 GROUP BY _groupByPart0Does anyone know how to make the email body search work?
Thanks a lot!
The forum ‘OroPlatform’ is closed to new topics and replies.