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.