List Order

How would I display a list in a specific order?

an Example would be to display based on a specific field value.So display users that have one values first , another value second, etc etc.

Thanks

Edit your list within CB > List Management and adjust what fields to sort by under the Sorting tab. For example you can select to sort ascending by the firstname then descending by the last name, etc...

I realize that but it does not allow for a specific order. I suspect this can be done via the Advanced tab but I have no idea what I would put in there.

If the field I am sorting by has a set list of values and I want to sort by those values in a predifned order. ie Value3 first, value6 next, value 1 next etc etc.

Do you have any documentation or examples of how the Advanced sorting works?

If the field I am sorting by has a set list of values and I want to sort by those values in a predifned order. ie Value3 first, value6 next, value 1 next etc etc.

Select your field and set it to sort by Ascending. Value 3, Value 6, Value 1 does not make any sense to ascending or descending ordering. You'd need some strange custom non-indexed ORDER BY added to the query to do that. Using Ascending and Descending you get results like Value 1, Value 3, then Value 6 or Value 6, Value 3, then Value 1.

Do you have any documentation or examples of how the Advanced sorting works?

No, advanced sorting adds directly to the database query using "ORDER BY".

I know!

Its the Query that I would need for the Advanced sorting!

I just have no idea what to put in the Query! that is what i am asking for.

What do I put in the Advanced box to accomplish what I want?

You need to write the needed MYSQL for an ORDER BY that'll order as you're wanting. Please see the below links for MYSQL tutorials and documentation.

MYSQL Documentation:
dev.mysql.com/doc/refman/5.6/en/index.html

MYSQL Tutorial:
www.w3schools.com/sql/default.asp

Advanced sorting adds directly to the userlist database query (you can omit ORDER BY as that's automatically added).