how do I make groups/subgroups view in alphabetical order in admin section
5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 9, 2010 (RSS)
By Codee - February 8, 2010
Re: [equinox69] how do I make groups/subgroups view in alphabetical order in admin section
By Dave - February 9, 2010
How is the 'model' field setup in the field editor?
Specifically, what is "List Options" set to?
Let me know and I'll see what I can come up with.
interactivetools.com
Re: [Dave] how do I make groups/subgroups view in alphabetical order in admin section
By Codee - February 9, 2010
Inside the "inventory" section, the field "model" has the following parameters:
display - pull down (single)
list - Get options from MySQL query (advanced) and the code Chris installed in the box there is:
SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>model`
WHERE manufacturer = '<?php echo $ESCAPED_FILTER_VALUE ?>'
and then Advanced Filter, refresh list when this field changes - "manufacturer"
Let me know if you need anything else. You may or may not need to know is that there was a custom plugin installed on this site by Chris (prior to the following release) that enabled an ability to work across the tables for some functionaility. Let me know if you want me to email ftp/admin access off list.
Re: [equinox69] how do I make groups/subgroups view in alphabetical order in admin section
By Dave - February 9, 2010
Thanks! Try adding this code (in red):
SELECT num, title
FROM `<?php echo $TABLE_PREFIX ?>model`
WHERE manufacturer = '<?php echo $ESCAPED_FILTER_VALUE ?>'
ORDER BY titleLet me know if that works for you.
interactivetools.com
Re: [Dave] how do I make groups/subgroups view in alphabetical order in admin section
By Codee - February 9, 2010
that did the trick! Thank you EVER SO much!