Wpquery order by?

[lorax]

Hey Team, I have a Looper Provider set to Query String. I’d like to order the results by an ACF field (project_number) but I can’t quite figure out what syntax to use. The current query is:

post_type=finished-project&facetwp=true&posts_per_page=25

I’ve tried orderby (and order_by) = project_number but without success.

[tristup]

Hi Gregg,

Thanks for reaching out.

You need to set the orderby to meta_value and specify the meta_key with the specific field name. You can check the following threads, which explain how to use orderby with custom meta values:

CPT and Query String sorting Problem

Hey, sorry but i need further help, it was my fault. It was my mistake it did not work the first time. The order is working but the compare not. The Query not working: $meta_query[] = array( ‘key’ => ‘datum’, ‘value’ => date(‘j. F Y’), ‘compare’ => ‘>=’, ‘type’ => ‘DATE’ ); $query = array( ‘post_type’ => ‘short_news’, ‘meta_key’ => ‘datum’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ‘meta_query’ => $meta_query ); The Output: post_type=short_news&meta_key=dat…

Using a looper list to get monthly archive links

I’m trying to create a looper list that has monthly archive links in it (similar to the ‘Archives’ widget that comes default with Wordpress that you can put in a sidebar). Is there a way I can set up the looper provider in the list to fetch these monthly archive links?

Hope this helps.
Thanks!

[lorax]

Hey @tristup, Thanks - that worked. Mostly. The project numbers are actual numbers. When I set the order to ASC it doesn’t quite work as expected. We have 4 and 5 digit project numbers - example: 7169 and 13129. I was hoping these would be ordered as 7169 followed by 13129 but they are the opposite - 13129 then 7169. It’s like it’s ready them as text rather than numbers. Is there a way to fix this?

[tristup]

Hi Gregg,

This happens because ACF stores all field values as strings , so numeric values can sometimes be sorted alphabetically instead of numerically. To fix this, make sure your project number field in ACF is set to the Number field type.

Additionally, if you are sorting the values using a query, use:

'orderby' => 'meta_value_num'

This forces WordPress to treat the value as a number when sorting.

Hope this helps!
Thanks.

[lorax]

@tristup, excellent. Thank you again. That’s the kind of insight and answer I needed. Much appreciated.

[prakash_s]

You are most welcome, @lorax