List -> Data -> Pre-filter -> Grouped issue

[monkframes]

Hi there,

I found since the last update (J3.5/F3.4.3) that in "List -> Data -> Pre-filter" the "Grouped" option do not "group" the conditions:

The end part of the generated code corresponding to the screenshot attached, is:

WHERE ( #__mydriveme_servicios.estado IN ('1','2') OR #__mydriveme_servicios.fecha_inicio >= '2016-03-30 22:00:00' AND #__mydriveme_servicios.id_conductor = (SELECT `id` FROM `#__mydriveme_conductores` WHERE `joomla_user_id` = 456) ) AND ( `#__mydriveme_servicios`.`fecha_inicio` BETWEEN '2016-03-30 22:00:00' AND '2016-03-31 21:59:59' )
ORDER BY `#__mydriveme_servicios`.`fecha_inicio` ASC, `#__mydriveme_servicios`.`hora_inicio` ASC

And the correct one must be:

WHERE ( ( #__mydriveme_servicios.estado IN ('1','2') OR #__mydriveme_servicios.fecha_inicio >= '2016-03-30 22:00:00' ) AND #__mydriveme_servicios.id_conductor = (SELECT `id` FROM `#__mydriveme_conductores` WHERE `joomla_user_id` = 456) ) AND ( `#__mydriveme_servicios`.`fecha_inicio` BETWEEN '2016-03-30 22:00:00' AND '2016-03-31 21:59:59' )
ORDER BY `#__mydriveme_servicios`.`fecha_inicio` ASC, `#__mydriveme_servicios`.`hora_inicio` ASC

 

[monkframes]

Friendly bump

 

[cheesegrits]

This is fixed in both the 343 build branch and in the main joomla3 branch of github.

-- hugh

 

[monkframes]

Thanks Hugh !!!