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

Hello, one of my clients has a section for "inventory" and a separate section for "manufacturer" that has a subsection for "models". It functions great BUT when the client adds an inventory item and chooses a manufacturer from the dropdown list (which pulls from the database) the subsequent list of models is not appearing in alphabetical order. They appear to appearing in datefieldentered order. How do I make the models automatically display in alphabetical order instead of alphaPATHETICal order?

Re: [equinox69] how do I make groups/subgroups view in alphabetical order in admin section

By Dave - February 9, 2010

Hi equinox69,

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.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] how do I make groups/subgroups view in alphabetical order in admin section

By Codee - February 9, 2010

Hi Dave,

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: [Dave] how do I make groups/subgroups view in alphabetical order in admin section

By Codee - February 9, 2010

Dave,

that did the trick! Thank you EVER SO much!