[Closed] Query repeatable field with query arguments

[Author]

Posts

[kelvinL-2]

Dear Sir/Madam,

I have a custom post with repeatable field, I use toolset_get_related_posts() to query the repeatable records, I want to query the repeatable record with specific query arguments, timeslot is the repeatable field including application-id and timeslot-status, I want to query all record if application-id is empty or not exist, could you please advise how I can do

$reservation_ids = toolset_get_related_posts( $booking_id, 'timeslot', 'parent', 100, 0, array(), 'post_id', 'child');

I guess I should customize the array() within this toolset_get_related_posts() but no idea how, could you help?

[Minesh]

Hello. Thank you for contacting the Toolset support.

I would like to know you want to get posts where if application-id is empty or not exist for any specific booking detail (booking ID) or all the posts where application-id is empty or not exist irrespective of booking ID?

[kelvinL-2]

For all child booking related to the booking_id where application-id is empty or not exist

[Minesh]

What if you try to use the following code:

	$post_meta = array('meta_key' => 'wpcf-application-id',
			   'meta_compare' => '=',
			   'meta_value' => '');
						
	  
	$reservation_ids = toolset_get_related_posts( $booking_id, 'timeslot', 'parent', 999, 0, $post_meta, 'post_id', 'child');

The variable $reservation_ids should contain the post IDs where application ID is empty.

Now do you mean that if booking ID does not have any related timeslot repeating field group item you want those records as well?

[kelvinL-2]

Dear Minesh,

Thanks for your reply. I want to have AND condition to the post_meta() but not work, please advise what's wrong to my code snippet

		$post_meta = array(
			'relation' => 'AND',
			array(
				'meta_key' => 'wpcf-application-id',
				'meta_compare' => '=',
				'meta_value' => '',
			),
			array(
				'meta_key' => 'wpcf-timeslot-status',
				'meta_compare' => '=',
				'meta_value' => '1',
			),			
		);

		$reservation_ids = toolset_get_related_posts( $booking_id, 'timeslot', 'parent', 999, 0, $post_meta, 'post_id', 'child');

Refer to the screenshots, I want the query will only return the timeslot has no application id and timeslot-status is available, there are 3 timeslots, it should only return the 2 but my above query return all.

[Minesh]

It should work I'm not sure why its not working.

Can you please tell me where exactly you added the code as well as where exactly you want to display the results.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[kelvinL-2]

Dear Minesh,

As website is still under development, no public access to it. Any alternative solution?

[Minesh]

Another alternative is you can share the site copy using duplicator:
- https://toolset.com/faq/provide-supporters-copy-site/
OR
- https://wordpress.org/plugins/all-in-one-wp-migration/

I have set the next reply to private which means only you and I have access to it.