Title: Sub-field query post order
Last modified: September 1, 2016

---

# Sub-field query post order

 *  [Scott](https://wordpress.org/support/users/sstracy/)
 * (@sstracy)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/sub-field-query-post-order/)
 * Hello!
 * I am using ACF PRO’s Repeater feature which allows for one or multiple subfield
   within a single post. I am utilizing this feature so that content editors can
   assign multiple dates to a post with an assigned priority level (high=1 and low
   =0) for each date.
 * The code below queries for posts that have an assigned date matching todays date.**
   Then I want to order the posts so that the assigned date priority level 1 posts
   are listed first. **Everything works as expected but when I have posts with more
   than one assigned date/priority level, the query just utilizes the first priority
   value it gets, not just the priority value which is assigned to the specific (
   today’s) date.
 * **I somehow need to identify the row # the assigned date is from so that I can
   only utilize the priority value from that sub-row. Any help would be amazing!
   Thank you in advance!**
 * —
    If you’re not familiar with ACF Repeater feature, they use a three-part naming
   convention for repeating sub-fields: **1. main-custom-field-name** **2. row#****
   3. sub-field-name** OR main-custom-field-name_row#_sub-field-name —
 *     ```
       <?php
   
       function my_posts_where( $where ) {
       	$where = str_replace("meta_key = 'ssm_assign_%", "meta_key LIKE 'ssm_assign_%", $where);
       	return $where;
       }
       add_filter('posts_where', 'my_posts_where');
   
       $datetoday = current_time('Ymd');
       $args = array(
       	'posts_per_page'=> 2,
       	'post_type'		=> 'ssm',
       	'meta_query' 	=> array(
               'relation' 			=> 'AND',
       		'assigned_dates' 	=> array(
       			'key'				=> 'ssm_assign_%_ssm_assigned_date',
       			'compare'			=> '=',
       			'value'				=> $datetoday,
       		),
               'assigned_priorities' => array(
                   'key'     			=> 'ssm_assign_%_ssm_date_priority',
       			'compare' 			=> 'EXISTS',
               ),
       	),
           'orderby' 		=> 'assigned_priorities',
           'order' 			=> 'DESC',
   
       );
       // query
       $the_query = new WP_Query( $args );
       if( $the_query->have_posts() ):
   
       	// Start the loop.
       	while ( $the_query->have_posts() ) : $the_query->the_post();
       		include(locate_template('content.php'));
       	endwhile;
       	// End the loop.
       		get_template_part( 'content', 'none' );
       	endif; //End of customized current day posts
   
       wp_reset_query();	 // Restore global post data stomped by the_post().
   
       ?>
       ```
   

The topic ‘Sub-field query post order’ is closed to new replies.

## Tags

 * [ACF](https://wordpress.org/support/topic-tag/acf/)
 * [custom](https://wordpress.org/support/topic-tag/custom/)
 * [field](https://wordpress.org/support/topic-tag/field/)
 * [order](https://wordpress.org/support/topic-tag/order/)
 * [orderby](https://wordpress.org/support/topic-tag/orderby/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [repeater](https://wordpress.org/support/topic-tag/repeater/)
 * [subfield](https://wordpress.org/support/topic-tag/subfield/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Scott](https://wordpress.org/support/users/sstracy/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/sub-field-query-post-order/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics