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