Support

Account

Search Results for 'q'

reply

In reply to Add filter on the relationship field inside a group
November 14, 2020 at 3:24 am

what name should it have?

In reply to Add filter on the relationship field inside a group
November 14, 2020 at 3:09 am

Hi,
with the filter you provided me the answer is this below.

The group is simple and is not contained in other groups or a clone.

- In reply to Display posts by category
- November 14, 2020 at 2:32 am
This is really a general WP question and not related to ACF.

First off, if this is showing only posts in one category then you need should have a taxonomy template "taxonomy-{$taxonomy}.php" or a term template "taxonomy-{$taxonomy}-{$term}.php" https://developer.wordpress.org/themes/basics/template-hierarchy/

If you are trying to show multiple terms and sort the posts by term, this is not something that is native to WP. You need to get the list of terms and then loop over them doing a separate post query for each term, https://wordpress.stackexchange.com/questions/151669/sort-posts-by-category
- In reply to WP Query closest locations by ACF Google Map values
- November 13, 2020 at 10:55 pm
Yeah, a cron job and a big lookup table would be the fastest. But this would not work for calculating nearby locations for random locations. Say, the location, as reported by the browser, of the current user.

For another project, I’m using a quick and dirty solution:

I take the location for which I want to retrieve nearby posts and round the latitude and longitude to the nearest degree. Then I search for posts with a location that match latitude and longitude, or one degree lower.
So, I end up with all posts in the same degree ‘square’ and three nearby ‘squares’. Then, if needed, I can perform a closest neighbour calculation on this subset of posts, and ignore those that are too far away (and are perhaps false positives).

Perhaps to clarify, this is my argument list:
```
$args = array(
	"post_type"			=> "any",
	"order"				=> "RAND",
	"post__not_in"		=> array(get_the_ID()),
	"meta_query"		=> array(
		'relation'		=> "OR",
		array(
			"relation"	=> "AND",
			array(
				"key"	=> "location",
				"value"	=> '"'.$law.'.',
				"compare"	=> "LIKE"
			),
			array(
				"key"	=> "location",
				"value"	=> '"'.$low.'.',
				"compare"	=> "LIKE"
			),
		),
	)
);
```
- In reply to Checkbox Field, Commas, Shortcode for get_field?
- November 12, 2020 at 9:17 pm
Thank you so much for your assistance on this thread. I’ve been pulling my hair out trying to figure this out. For anyone else looking for help paste the snippet below into your functions.php:
```
//Code to display ACF checkboxes as list
add_shortcode('acfBr', 'brListFunction');
function brListFunction($atts, $content) {
	extract(shortcode_atts(array("id"=>'','field'=>''),$atts));
	if($field){
		if($id=''){
			global $post;
			$id=$post->ID;
		}
		$content=get_field($field,$id);
		return implode('<br>',$content);
	}
    return '';
}
```
Then use the short code format to display the appropriate value:

[acfBr field="FIELD_NAME"]
- In reply to Checkbox Field, Commas, Shortcode for get_field?
- November 12, 2020 at 9:15 pm
Thank you so much for your assistance on this thread. I’ve been pulling my hair out trying to figure this out. For anyone else looking for help paste the snippet below into your functions.php:

`//Code to display ACF checkboxes as list
add_shortcode(‘acfBr’, ‘brListFunction’);
function brListFunction($atts, $content) {
extract(shortcode_atts(array(“id”=>”,’field’=>”),$atts));
if($field){
if($id=”){
global $post;
$id=$post->ID;
}
$content=get_field($field,$id);
return implode(‘<br>’,$content);
}
return ”;
}

Then use the short code:

[acfBr field="FIELD_NAME"]

In reply to Search contents by latitutine, longitude and radius
November 12, 2020 at 8:36 am

I’m doing something similar and using this DB call. This is using the Haversine formula.

  

global $wpdb;
  $tablePrefix = $wpdb->prefix;
  $query = $wpdb->prepare("SELECT ".$tablePrefix."posts.*,
  a.meta_value street_address,
  b.meta_value city,
  c.meta_value state,
  d.meta_value zip_code,
  e.meta_value phone,
  f.meta_value website,
  g.meta_value latitude,
  h.meta_value longitude,
  ( 3959 * acos( cos( radians('%s') ) * cos( radians( g.meta_value ) ) * cos( radians( h.meta_value ) - radians(%s) ) + sin( radians('%s') ) * sin( radians( g.meta_value ) ) ) ) AS distance
  FROM ".$tablePrefix."posts
  LEFT JOIN ".$tablePrefix."postmeta a ON ".$tablePrefix."posts.ID = a.post_ID AND a.meta_key='street_address'
  LEFT JOIN ".$tablePrefix."postmeta b ON ".$tablePrefix."posts.ID = b.post_ID AND b.meta_key='city'
  LEFT JOIN ".$tablePrefix."postmeta c ON ".$tablePrefix."posts.ID = c.post_ID AND c.meta_key='state'
  LEFT JOIN ".$tablePrefix."postmeta d ON ".$tablePrefix."posts.ID = d.post_ID AND d.meta_key='zip_code'
  LEFT JOIN ".$tablePrefix."postmeta e ON ".$tablePrefix."posts.ID = e.post_ID AND e.meta_key='phone'
  LEFT JOIN ".$tablePrefix."postmeta f ON ".$tablePrefix."posts.ID = f.post_ID AND f.meta_key='website'
  LEFT JOIN ".$tablePrefix."postmeta g ON ".$tablePrefix."posts.ID = g.post_ID AND g.meta_key='latitude'
  LEFT JOIN ".$tablePrefix."postmeta h ON ".$tablePrefix."posts.ID = h.post_ID AND h.meta_key='longitude'
  WHERE ".$tablePrefix."posts.post_type = 'acf-store' AND ".$tablePrefix."posts.post_status = 'publish'
  HAVING distance < '%s'
  ORDER BY distance LIMIT 0 , 100",
              $center_lat,
              $center_lng,
              $center_lat,
              $radius);

     $store_data = $wpdb->get_results($query);

- In reply to WP Query closest locations by ACF Google Map values
- November 12, 2020 at 7:53 am
@alan-brown @mastababa this should help out as a reference and working solution / starting point (and finish there as well most likely). Either with the WP_Query or the rest api Reference link
- In reply to Search contents by latitutine, longitude and radius
- November 12, 2020 at 7:21 am
@frabiacca @mastababa You can use this a starting point (and finish there as well most likely). Either with the WP_Query or the rest api Reference link
- In reply to Map User location and radius search
- November 12, 2020 at 7:17 am
@alitscha You can use this a starting point. Either with the WP_Query or the rest api Reference link
- In reply to How to query books (CPT) by author (relationship)
- November 12, 2020 at 12:49 am
Hi John,
I cant thank you enough for your time it reply my question and for writing this plugin. (I can see that you are the plugin author).

It works just as it should. Thank you again
- In reply to Display custom taxonomy name
- November 12, 2020 at 12:44 am
A taxonomy field returns a single term of an array of terms dependent on the settings for the field. See code examples here for how to use a taxonomy field https://www.advancedcustomfields.com/resources/taxonomy/

Your issue with Uncategorized is that in your code get_term() requires you to pass the taxonomy name or “category” is assumed, meaning the default category taxonomy for posts.
- In reply to Layout for ACF checkbox in WordPress
- November 11, 2020 at 1:43 pm
Eu estou o Elementor para inserir o conteúdo no layout.
O código-fonte está assim:

<div class=”elementor-element elementor-element-1631ada elementor-widget elementor-widget-text-editor” data-id=”1631ada” data-element_type=”widget” data-widget_type=”text-editor.default”>
<div class=”elementor-widget-container”>
<div class=”elementor-text-editor elementor-clearfix”>Churrasqueira, Cozinha, Espaço Gourmet, Sala de Jantar</div>
</div>
</div>

O texto “Churrasqueira, Cozinha, Espaço Gourmet, Sala de Jantar” gostaria que ficasse assim:
• Churrasqueira
• Cozinha
• Espaço Gourmet
• Sala de Jantar
- In reply to How to query books (CPT) by author (relationship)
- November 11, 2020 at 9:37 am
There is a tutorial on doing this type of query here https://www.advancedcustomfields.com/resources/querying-relationship-fields/

This can be made easier by creating a bidirectional relationship field, if it’s not too late to do so. Add this would mean updating every post with a relationship after the code is added.

https://www.advancedcustomfields.com/resources/bidirectional-relationships/

https://support.advancedcustomfields.com/forums/topic/bidirectional-relationships-and-multiple-post-types/
- In reply to ACF blocks cramped in right sidebar of editor
- November 11, 2020 at 9:23 am
If you are looking from input from Eliot the you should submit a request here https://www.advancedcustomfields.com/contact/

I do know that there are a whole host of issues related to … the new editor … and this is one of them.

In reply to How to make Email and Mobile Number Clickable
November 11, 2020 at 9:17 am


if ( $email ) {
  echo 'Email: <a href="mailto:'.$email.'">'.$email.'</a><br/>';
}

if ( $phone ) {
  echo 'Phone: <a href="tel:'.$phone .'">'.$phone .'</a><br/>';
}

- In reply to how Validate an id before saving, for avoid duplicatication
- November 11, 2020 at 9:13 am
https://support.advancedcustomfields.com/forums/topic/accept-only-unique-values/#post-45359
- In reply to Content Filtering Using Fields – Issues
- November 11, 2020 at 8:22 am
Thanks John,
I see where you’re going. And good caution on having too many filters/Queries.
Using “foreach”, maybe something like this?
```
// append meta query
        $meta_query = array(
          'relation' => 'AND',
	foreach( $value as $val )
    {
    	array(
         'relation' => 'OR',
	  array(
	    'key'	=> $name,
            'value'	=> '"' . $val . '"',
            'compare'	=> 'LIKE',
        ),
	),
     });
```
I went a different route and decided to utilize custom taxonomies, in combination with the Taxonomy field. But still utilizing the Javascript Elliot outlined in the tutorial. Seems to be less intensive query and built into WordPress already.

Thanks again for your response.
- In reply to Content Filtering Using Fields – Issues
- November 11, 2020 at 6:19 am
When multiple values are passed for multiple fields then you’ll need to use multiple nested meta queries.

Looking at this query string ?size=small,large&color=black,white

I’m going to assume that you want
```
(size == small OR size == large) AND (color == black OR color == white)
```
You’ll need to figure out out to put this into your loop, but the meta query you would need is something like this
```
$meta_query = array(
  'relation' => 'AND',
   array(
     'relation' => 'OR',
      array(
        'key' => 'size',
        'value' => '"small"',
        'compare' => 'LIKE'
      ),
      array(
        'key' => 'size',
        'value' => '"large"',
        'compare' => 'LIKE'
      ),
   array(
     'relation' => 'OR',
      array(
        'key' => 'color',
        'value' => '"black"',
        'compare' => 'LIKE'
      ),
      array(
        'key' => 'color',
        'value' => '"white"',
        'compare' => 'LIKE'
      ),
   ),
);
```
A word of caution/warning, as the number filters grow and the number of selections made in each filter grows these like queries will take longer and longer to process until they finally time out and likely time out until it prevents the page from loading.
- In reply to Update field with wrong post id value
- November 11, 2020 at 5:25 am
Not sure exactly what you are looking for.

But, yes, if you use “some_text” then ACF will create an option value using the field name and prepended with “some_text_”.

When you create an options page, the default $post_id is “options” and all fields saved on that options page will be “options_{$field_name}”

You can specify a different “post_id” value when creating an options page, for example I can create an options page and specify that the post_id is “theme_options”. ACF will save all the values in the options table prepended with “theme_options_” and when I want to get the field I can use get_field('my-field-name', 'theme_options")
- In reply to Comment field backend only
- November 11, 2020 at 12:36 am
Add a prepare field filter https://www.advancedcustomfields.com/resources/acf-prepare_field/ and return false if it is not the admin
```
add_filter('acf/prepare_field/name=YOUR_FIELD_NAME", 'admin_only_field');
admin_only_field($field) {
  if (!is_admin()) {
    return false;
  }
  return $field;
}
```

In reply to Content Filtering Using Fields – Issues
November 9, 2020 at 5:00 am

add_action('pre_get_posts', 'my_pre_get_posts', 10, 1);

function my_pre_get_posts( $query ) {
	
	// bail early if is in admin
	if( is_admin() ) return;
	
	
	// bail early if not main query
	// - allows custom code / plugins to continue working
	if( !$query->is_main_query() ) return;
	
	
	// get meta query
	$meta_query = $query->get('meta_query');
	
	// loop over filters
	foreach( $GLOBALS['my_query_filters'] as $key => $name ) {
		
		// continue if not found in url
		if( empty($_GET[ $name ]) ) {
			
			continue;
			
		}
		
		
		// get the value for this filter
		// eg: http://www.website.com/events?city=melbourne,sydney
		$value = explode(',', $_GET[ $name ]);

		
		// append meta query
	foreach( $value as $val )
    {
    	$meta_query = [
	 [
	     'key'		=> $name,
            'value'		=> '"' . $val . '"',
            'compare'	=> 'LIKE',
        ],
	];
}
        
	} 
	
	
	// update meta query
	$query->set('meta_query', $meta_query);

}

- In reply to Hide values that have been selected in other field
- November 7, 2020 at 5:07 am
1st of all, sorry for the late reply.

Yes sure I’ve done some code that allows to manage group of fields in order to add the possibility to make some value inclusion, exclusion.

By adding a specific class to some fields, you can :
– group fields
– insert value from a group
– exclude value from a group
– Mix all this.

It is a JS lib (but with some jQuery code, not 100% migrated to vanilla js ).

It is running everyday without any problem (in my site context) without enhancements since more than one year.

You can find it here : https://github.com/chdenat/acf-xtend

Feel free to contact me for further explanation.
- In reply to Issue displaying taxonomies names and links: not a string?
- November 6, 2020 at 10:55 am
For anyone who needs it, my error was that I had to use
get_term_link(term-slug, taxonomy-slug) with the term slug and the taxonomy slug, while I was using the ID and did not use the taxonomy slug.

So the final code I used is:
```
$terms = get_field('acf_tax_fieldname');
if( $terms ) {
     foreach( $terms as $term ) {
		 $term_name = get_term( $term )->name;
		 $term_slug = get_term( $term )->slug;
		 $term_link = get_term_link( $term_slug , 'wp_tax_slug' );
		 echo "<a href='" . $term_link . "'>" . $term_name . "</a>";
	}    
}
```
- In reply to Pre get Posts Show posts first if has acf value
- November 6, 2020 at 8:10 am
Thanks for the advice, I’ve tried the following based on the example to no avail.

Featured is set at True / False field as mentioned in example 2.

function custom_post_type_archive_jobs($query) {

if ($query->is_post_type_archive(‘jobs’)) {
$query->set(‘orderby’, ‘meta_value’);
$query->set(‘meta_key’, ‘featured’);
$query->set(‘posts_per_page’, ‘-1’);
$query->set(‘order’, ‘ASC’);
}

}

add_action(‘pre_get_posts’, ‘custom_post_type_archive_jobs’, 9999);

Viewing 25 results - 6,276 through 6,300 (of 21,335 total)

← 1 2 3 … 251 252 253 … 852 853 854 →

Advanced Custom Fields

Support

Account

Search Results for 'q'

reply

In reply to Add filter on the relationship field inside a group

In reply to Add filter on the relationship field inside a group

In reply to Display posts by category

In reply to WP Query closest locations by ACF Google Map values

In reply to Checkbox Field, Commas, Shortcode for get_field?

In reply to Checkbox Field, Commas, Shortcode for get_field?

In reply to Search contents by latitutine, longitude and radius

In reply to WP Query closest locations by ACF Google Map values

In reply to Search contents by latitutine, longitude and radius

In reply to Map User location and radius search

In reply to How to query books (CPT) by author (relationship)

In reply to Display custom taxonomy name

In reply to Layout for ACF checkbox in WordPress

In reply to How to query books (CPT) by author (relationship)

In reply to ACF blocks cramped in right sidebar of editor

In reply to How to make Email and Mobile Number Clickable

In reply to how Validate an id before saving, for avoid duplicatication

In reply to Content Filtering Using Fields – Issues

In reply to Content Filtering Using Fields – Issues

In reply to Update field with wrong post id value

In reply to Comment field backend only

In reply to Content Filtering Using Fields – Issues

In reply to Hide values that have been selected in other field

In reply to Issue displaying taxonomies names and links: not a string?

In reply to Pre get Posts Show posts first if has acf value

Welcome

Forums

Helping Others

About

Help

Community

Products