Filtering when "allow_multiple_selection" enabled

[xdm]

LEFT JOIN causes wrong entries count ( it is obvious, when you join one-to-many table)

I fixed this problem using "SELECT DISTINCT" in entry manager, even their is no grouping

SELECT count(".($group ? 'DISTINCT ' : 'DISTINCT')."e.id) as count

[brendo]

@klaftertief, this seems familiar. Was this something you fixed while we were in Cologne?

[klaftertief]

Sounds familiar, yep. But it was for the select field, which didn't implement the requiresSQLGrouping(). The SBL implements it, and I couldn't reproduce the issue. The query should have a DISTINCT when the allow_multiple_selection is set.

@xdm, ehat version of the SBL are you using and how does your DS and filter look like?