I'm making an "author list" which grabs all the users (like this). I added extra user fields for titles and such with the Cimy User Extra Fields plugin. I also added a "chain of command" field. It's just a number from 1-6. How can I reference the CHAIN_OF_COMMAND field in the following code to replace display_name?
$authors = $wpdb->get_results("SELECT ID, user_nicename from $wpdb->users ORDER BY display_name");
An unresolved topic from three years ago asks the same question I'm dealing with. See ordering-in-kafs-all-authors for more info.
Thank you!