…WHERE customer_id = %d”, $order_stats->customer_id ) ); $content .= ‘ ‘ . $customer->first_name . ‘ ‘ . $customer->last_name; // Order meta, for example billing and shipping addresses. $meta = get_post_meta( $post->ID ); $meta = array_combine( array_keys( $meta ), array_column( $meta, ‘0’ ) ); $content .= ‘ ‘ . $meta[‘_billing_address_index’]; $content…….= ‘ ‘ . implode( ‘ ‘, $item_names ); // Total sum of the order. $order_stats = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM {$wpdb->prefix}wc_order_stats WHERE order_id = %d”, $post->ID ) ); $content .= ‘ ‘ . $order_stats->total_sales; // Customer first and last name. $customer = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM {$wpdb->prefix}wc_customer_lookup……) { $post_types[] = ‘shop_order’; return $post_types; } ); This is not enough, though. The order use custom statuses. You also need to allow these statuses with this code snippet: add_filter( ‘relevanssi_valid_status’, ‘rlv_add_status’ ); add_filter( ‘relevanssi_valid_admin_status’, ‘rlv_add_status’ ); function rlv_add_status( $status_array ) { $status_array[] = ‘wc-completed’; $status_array[] = ‘wc-pending’; return…
Relevanssi doesn’t by default index the headings in Visual Composer. The vcex_heading shortcode Visual Composer for the headings stores the heading text inside a shortcode attribute. By default, Relevanssi does not index shortcode attributes. In this case, indexing the shortcode attribute is necessary. Fortunately, it’s easy to fix with a simple function added to your…
…specific collations for individual columns, and we’re mostly interested in the specific collations for the term and term_reverse columns. If you change the collation to something that does not ignore accents, you also need to make Relevanssi keep the accents. Add this to your site: remove_filter( ‘relevanssi_remove_punctuation’, ‘remove_accents’, 9 );……these mixups (and also for the useful behaviour of ignoring accents). The reason is the MySQL database collation, which controls how the data is sorted and compared. The default collation for Relevanssi tables is utf8mb4_unicode_ci, which is a good, general-purpose collation. However, in some specific cases, it may be too……generic. Finnish (and Swedish) users may want to use utf8mb4_swedish_ci, which for example makes a and ä separate letters. You can adjust the collation in the database table settings, which you can modify with tools like phpMyAdmin or Adminer. There’s a general collation for the table and specific collations for…
Visual Composer and WP Bakery have a Raw HTML element that can be used to add HTML code to your pages. By default, this content is stored in an encoded format Relevanssi can’t read. Fortunately, the encoding is simple Base64 encoding that is easy to read. So, in order to read the contents of the…
This is a very common request: “How do I show the most popular searches in a widget or on a page?” Relevanssi does not have such a feature built in, and the reason for that is twofold: First, on many sites, the most common searches are either spam or boring. On this site, I use…
In regular expressions, ^ can be used to match the beginning of the line and $ to match the end of the line. For example, ^ban will match banana, but not urban, while ban$ matches urban, but not banana. These are called anchoring operators. By default, Relevanssi matches either beginning or the end of the…
…are not available. Here’s a code snippet that can be used within FacetWP templates to generate and display Relevanssi excerpts for the posts: $query = isset( FWP()->facet->facets[‘search’] ) ? FWP()->facet->facets[‘search’][‘selected_values’] : ”; echo relevanssi_do_excerpt( $post, $query ); Using relevanssi_do_query filter functions with FacetWP There may be occasions where you need…
Envira Gallery is a gallery plugin for WordPress. Since it uses a custom post type for the galleries, it works fine with Relevanssi. However, the gallery post type doesn’t have any information about the actual images: no titles, tags or other details like that. Since the images are uploaded in the Media Library and are…
Metabox is a suite of plugins to handle custom fields. It seems like a solid competitor for Advanced Custom Fields. There’s nothing particularly Relevanssi-unfriendly about it, since it uses custom fields to store the data and Relevanssi can read custom fields. MB Relationships MB Relationships is an extension to Metabox that can be used to…
I set up a short coded search box to search my Learndash e-course for one specific category only: [ searchform ld_topic_category=”156″ ] It works perfectly except one thing: if no results show, it takes you to the default WordPress page and presents you with the standard search box that no longer searches category 156. This…