XF 2.3 HAVING supported in finder?

[Rene_V]

Does Finder support HAVING in its syntax? There was noting about it in the Developer Documentation section. Searches in the forums here didn't bring up any results at all either.

 

[Kirby]

Finders do not support grouping.

Depending on what you want to query it might be possible to use a subquery with whereSql.

 

[Rene_V]

Finders do not support grouping.

That's what I thought too. Thanks for confirming it.

Depending on what you want to query it might be possible to use a subquery with whereSql.

I want to get all duplicate records from a table and do a join with another table. I will give whereSql a try and see how it will go. Many thanks for the pointer. Appreciate the help.

 

[Rene_V]

I couldn't get HAVING to work with whereSql. I used the database adapter instead and it worked fine.

 

[digitalpoint]

XenForo 2.4 is getting some improvements to the query builder/finder system, so might not need to drop down to raw queries at that point (of course, doesn't help now though).

XF 2.4 Post in thread 'XenForo 2.4 status and what's new under the hood?'

Jun 13, 2025

Does the new query builder support subqueries?

Yes. Sub-queries, complex joins, CTEs, raw expressions. Basically everything you can imagine (hopefully).

• Chris D

• 
•