This topic is locked

Another group by problem

12/31/2013 4:21:29 PM
Multiselect plugin support forum
T
Tim author

Hello,
I see an earlier post about problems with the group by function of this plugin. I'm not sure if what was sent to that person was incorporated into the release version, but I am also having problems. My plugin settings are:
this_object.settings("table") = "vJobTitles"

this_object.settings("link_field") = "JobID"

this_object.settings("display_field") = "JobTitle"

this_object.settings("order_by") = "JobTitle"

this_object.settings("group_by") = "StoreDepartmentName"
And the query that is generated (seen via debug=true) is:
SELECT DISTINCT [JobID],[JobTitle][StoreDepartmentName] FROM [vJobTitles] ORDER BY [JobTitle]
It looks like the group by field is just added to the end of the select field list.
Any help is much appreciated.

Thanks,

Tim

T
Tim author 1/8/2014

Has anyone gotten the grouping to work?