KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to create native SQL query with couple of unions and subqueries. It'll look approximately like this: SELECT res.id, COUNT(*) as count_ids FROM ( SELECT a.id FROM ... a WHERE ... LIKE ('%:param%') UNION ALL SELECT b.id FROM ... b WHERE ... LIKE ('%:param%') UNION ALL ... ) res GROUP BY res.id ORDER BY count_ids asc Result won't match any Entity I use in my application. Is it possible to create ResultSetMapping with "anonymous" object? Or is it, at least, possible to create an Entity that wouldn't create table next time I update schema, so I can map results to it? Or is there any other Doctrine-friendly way to deal with such query? Making changes to database isn't possible though, as I'm dealing with legacy stuff that cannot be touched. I'd also strongly prefer if I did everything on database side, not involving much of PHP in it.
Tags (comma-separated)
Save Edits
Cancel