Tag: { “field”: “id”

How to exclude woocommerece product category in search results?

Post author By Marcia D.
Post date June 4, 2020
No Comments on How to exclude woocommerece product category in search results?

I’m looking for a way to exclude a product category from search results with Woocommerce using the pre_get_posts action and $query->set(). I am searching using the WordPress ?s=keyword search. I know that the function will begin like this: add_action(‘pre_get_posts’, ‘exclude_product_category’); function exclude_product_category( $query ) { global $wp_the_query; if ( ( ! is_admin() ) && ( […]

Tags 'exclude_product_category'); function exclude_product_category( $query ) { global $wp_the_query; if ( ( ! is_admin() ) && ( $query, 'operator' => 'NOT IN', 'tax_query' => array( array( 'taxonomy' => 'product_cat', 'terms' => array(18), ), ) )); How would I accomplish this?, { "field": "id", I'm looking for a way to exclude a product category from search results with Woocommerce using the pre_get_posts action and $query->set(). I

CMS Magento Mastering Development

Magento 2 Grid Add column with href and hash tag

Post author By Ask Me
Post date May 22, 2020
No Comments on Magento 2 Grid Add column with href and hash tag

i want to show url in grid with hash tag below it currently used , is there way to hash tag in end $this->addColumn( ‘edit’, [ ‘header’ => __(‘Download’), ‘type’ => ‘action’, ‘getter’ => ‘getId’, ‘actions’ => [ [ ‘caption’ => __(‘Download’), ‘url’ => [ ‘base’ => ‘*/*/edit’,’downwww’ => ‘ds’ ], ‘field’ => ‘id’ ] […]

Tags 'actions' => [ [ 'caption' => __('Download'), 'column_css_class' => 'col-action' ] );, 'downwww' => 'ds' ], 'getter' => 'getId', 'header_css_class' => 'col-action', 'index' => 'stores', 'type' => 'action', 'url' => [ 'base' => '*/*/edit', [ 'header' => __('Download'), { "field": "id", filter: false, i want to show url in grid with hash tag below it currently used, is there way to hash tag in end $this->addColumn( 'edit', sortable: false

CMS Drupal Mastering Development

Issue in custom view

I ‘m facing issue in custom modul in drupal8. “SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘FROM first_view_table first_view_table LIMIT 11 OFFSET 0’ at line 1: SELECT FROM {first_view_table} first_view_table […]

Tags 'area' => [ 'id' => 'text', 'argument' => [ 'id' => 'numeric', 'argument' => [ 'id' => 'string', 'base field' => 'id', 'extra' => [ ['left_field' => 'project_code', 'extra' => [ 0 => [ 'field' => 'published', 'field' => 'project_code'], 'field' => [ 'id' => 'boolean', 'field' => [ 'id' => 'date', 'field' => [ 'id' => 'numeric', 'field' => [ 'id' => 'standard', 'filter' => [ 'id' => 'boolean', 'filter' => [ 'id' => 'date', 'filter' => [ 'id' => 'numeric', 'filter' => [ 'id' => 'string', 'help' => t('Ex81 View table contains example content and can be related to nodes.'), 'help' => t('Just a City field.'), 'help' => t('Just a Item Description field.'), 'help' => t('Just a No Of Units field.'), 'help' => t('Just a numeric field.'), 'help' => t('Just a Order Number field.'), 'help' => t('Just a Recipient field.'), 'help' => t('Just a Ship Date field.'), 'help' => t('Just a Shiping Type field.'), 'help' => t('Just a state field.'), 'help' => t('Just a timestamp field.'), 'help' => t('Just a Total Invoice field.'), 'help' => t('Just a Tracking Number field.'), 'help' => t('Just a winery name field.'), 'help' => t('Just a zip field.'), 'help' => t('Just an on/off field.'), 'help' => t('Provide markup text for the area.'), 'help' => t('Relate example content to the node content'), 'id' => 'standard', 'label' => t('Example node'), 'label' => t('Published'), 'left_field' => 'id', 'left_field' => 'is_active', 'relationship' => [ 'base' => 'node_field_data', 'sort' => [ 'id' => 'date', 'sort' => [ 'id' => 'standard', 'title' => t('Ex811 View table'), 'type' => 'yes-no', 'use_equal' => TRUE, ], ]; $data['first_view']['table']['join'] = [ 'node_field_data' => [ 'left_field' => 'id', ]; $data['mapping_data']['age'] = [ 'title' => t('Age'), ]; $data['mapping_data']['city'] = [ 'title' => t('City'), ]; $data['mapping_data']['id'] = [ 'title' => t('Example content'), ]; $data['mapping_data']['is_active'] = [ 'title' => t('Is Active'), ]; $data['mapping_data']['item_description'] = [ 'title' => t('Item Description'), ]; $data['mapping_data']['no_of_units'] = [ 'title' => t('No Of Units'), ]; $data['mapping_data']['order_no'] = [ 'title' => t('Order Number'), ]; $data['mapping_data']['recipient'] = [ 'title' => t('Receipient'), ]; $data['mapping_data']['ship_date'] = [ 'title' => t('Ship Date'), ]; $data['mapping_data']['shipping_type'] = [ 'title' => t('Shiping Type'), ]; $data['mapping_data']['state'] = [ 'title' => t('State'), ]; $data['mapping_data']['table']['join']['node_field_data'] = [ 'left_table' => 'foo', ]; $data['mapping_data']['timestamp'] = [ 'title' => t('Timestamp'), ]; $data['mapping_data']['total_invoice'] = [ 'title' => t('Total Invoice'), ]; $data['mapping_data']['tracking_no'] = [ 'title' => t('Tracking Number'), ]; $data['mapping_data']['username'] = [ 'title' => t('Winery Name'), ]; $data['mapping_data']['zip'] = [ 'title' => t('Zip'), ]; $data['views']['area'] = [ 'title' => t('Text area'), ]; return $data; } I want to shoe this table in view.Please response if any have knowledge for this Asap., { "field": "id", { numeric: true, //value 0, 1 => [ 'left_field' => 'age', 2 => [ 'field' => 'published', field: 'age', I 'm facing issue in custom modul in drupal8. "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;, operator, value: 1 } ], value: true } }, weight: 10

CMS Drupal Mastering Development

Issue in custom view

Tags 'area' => [ 'id' => 'text', 'argument' => [ 'id' => 'numeric', 'argument' => [ 'id' => 'string', 'base field' => 'id', 'extra' => [ ['left_field' => 'project_code', 'extra' => [ 0 => [ 'field' => 'published', 'field' => 'project_code'], 'field' => [ 'id' => 'boolean', 'field' => [ 'id' => 'date', 'field' => [ 'id' => 'numeric', 'field' => [ 'id' => 'standard', 'filter' => [ 'id' => 'boolean', 'filter' => [ 'id' => 'date', 'filter' => [ 'id' => 'numeric', 'filter' => [ 'id' => 'string', 'help' => t('Ex81 View table contains example content and can be related to nodes.'), 'help' => t('Just a City field.'), 'help' => t('Just a Item Description field.'), 'help' => t('Just a No Of Units field.'), 'help' => t('Just a numeric field.'), 'help' => t('Just a Order Number field.'), 'help' => t('Just a Recipient field.'), 'help' => t('Just a Ship Date field.'), 'help' => t('Just a Shiping Type field.'), 'help' => t('Just a state field.'), 'help' => t('Just a timestamp field.'), 'help' => t('Just a Total Invoice field.'), 'help' => t('Just a Tracking Number field.'), 'help' => t('Just a winery name field.'), 'help' => t('Just a zip field.'), 'help' => t('Just an on/off field.'), 'help' => t('Provide markup text for the area.'), 'help' => t('Relate example content to the node content'), 'id' => 'standard', 'label' => t('Example node'), 'label' => t('Published'), 'left_field' => 'id', 'left_field' => 'is_active', 'relationship' => [ 'base' => 'node_field_data', 'sort' => [ 'id' => 'date', 'sort' => [ 'id' => 'standard', 'title' => t('Ex811 View table'), 'type' => 'yes-no', 'use_equal' => TRUE, ], ]; $data['first_view']['table']['join'] = [ 'node_field_data' => [ 'left_field' => 'id', ]; $data['mapping_data']['age'] = [ 'title' => t('Age'), ]; $data['mapping_data']['city'] = [ 'title' => t('City'), ]; $data['mapping_data']['id'] = [ 'title' => t('Example content'), ]; $data['mapping_data']['is_active'] = [ 'title' => t('Is Active'), ]; $data['mapping_data']['item_description'] = [ 'title' => t('Item Description'), ]; $data['mapping_data']['no_of_units'] = [ 'title' => t('No Of Units'), ]; $data['mapping_data']['order_no'] = [ 'title' => t('Order Number'), ]; $data['mapping_data']['recipient'] = [ 'title' => t('Receipient'), ]; $data['mapping_data']['ship_date'] = [ 'title' => t('Ship Date'), ]; $data['mapping_data']['shipping_type'] = [ 'title' => t('Shiping Type'), ]; $data['mapping_data']['state'] = [ 'title' => t('State'), ]; $data['mapping_data']['table']['join']['node_field_data'] = [ 'left_table' => 'foo', ]; $data['mapping_data']['timestamp'] = [ 'title' => t('Timestamp'), ]; $data['mapping_data']['total_invoice'] = [ 'title' => t('Total Invoice'), ]; $data['mapping_data']['tracking_no'] = [ 'title' => t('Tracking Number'), ]; $data['mapping_data']['username'] = [ 'title' => t('Winery Name'), ]; $data['mapping_data']['zip'] = [ 'title' => t('Zip'), ]; $data['views']['area'] = [ 'title' => t('Text area'), ]; return $data; } I want to shoe this table in view.Please response if any have knowledge for this Asap., { "field": "id", { numeric: true, //value 0, 1 => [ 'left_field' => 'age', 2 => [ 'field' => 'published', field: 'age', I 'm facing issue in custom modul in drupal8. "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;, operator, value: 1 } ], value: true } }, weight: 10

CMS Drupal Mastering Development

Issue in custom view

Tags 'area' => [ 'id' => 'text', 'argument' => [ 'id' => 'numeric', 'argument' => [ 'id' => 'string', 'base field' => 'id', 'extra' => [ ['left_field' => 'project_code', 'extra' => [ 0 => [ 'field' => 'published', 'field' => 'project_code'], 'field' => [ 'id' => 'boolean', 'field' => [ 'id' => 'date', 'field' => [ 'id' => 'numeric', 'field' => [ 'id' => 'standard', 'filter' => [ 'id' => 'boolean', 'filter' => [ 'id' => 'date', 'filter' => [ 'id' => 'numeric', 'filter' => [ 'id' => 'string', 'help' => t('Ex81 View table contains example content and can be related to nodes.'), 'help' => t('Just a City field.'), 'help' => t('Just a Item Description field.'), 'help' => t('Just a No Of Units field.'), 'help' => t('Just a numeric field.'), 'help' => t('Just a Order Number field.'), 'help' => t('Just a Recipient field.'), 'help' => t('Just a Ship Date field.'), 'help' => t('Just a Shiping Type field.'), 'help' => t('Just a state field.'), 'help' => t('Just a timestamp field.'), 'help' => t('Just a Total Invoice field.'), 'help' => t('Just a Tracking Number field.'), 'help' => t('Just a winery name field.'), 'help' => t('Just a zip field.'), 'help' => t('Just an on/off field.'), 'help' => t('Provide markup text for the area.'), 'help' => t('Relate example content to the node content'), 'id' => 'standard', 'label' => t('Example node'), 'label' => t('Published'), 'left_field' => 'id', 'left_field' => 'is_active', 'relationship' => [ 'base' => 'node_field_data', 'sort' => [ 'id' => 'date', 'sort' => [ 'id' => 'standard', 'title' => t('Ex811 View table'), 'type' => 'yes-no', 'use_equal' => TRUE, ], ]; $data['first_view']['table']['join'] = [ 'node_field_data' => [ 'left_field' => 'id', ]; $data['mapping_data']['age'] = [ 'title' => t('Age'), ]; $data['mapping_data']['city'] = [ 'title' => t('City'), ]; $data['mapping_data']['id'] = [ 'title' => t('Example content'), ]; $data['mapping_data']['is_active'] = [ 'title' => t('Is Active'), ]; $data['mapping_data']['item_description'] = [ 'title' => t('Item Description'), ]; $data['mapping_data']['no_of_units'] = [ 'title' => t('No Of Units'), ]; $data['mapping_data']['order_no'] = [ 'title' => t('Order Number'), ]; $data['mapping_data']['recipient'] = [ 'title' => t('Receipient'), ]; $data['mapping_data']['ship_date'] = [ 'title' => t('Ship Date'), ]; $data['mapping_data']['shipping_type'] = [ 'title' => t('Shiping Type'), ]; $data['mapping_data']['state'] = [ 'title' => t('State'), ]; $data['mapping_data']['table']['join']['node_field_data'] = [ 'left_table' => 'foo', ]; $data['mapping_data']['timestamp'] = [ 'title' => t('Timestamp'), ]; $data['mapping_data']['total_invoice'] = [ 'title' => t('Total Invoice'), ]; $data['mapping_data']['tracking_no'] = [ 'title' => t('Tracking Number'), ]; $data['mapping_data']['username'] = [ 'title' => t('Winery Name'), ]; $data['mapping_data']['zip'] = [ 'title' => t('Zip'), ]; $data['views']['area'] = [ 'title' => t('Text area'), ]; return $data; } I want to shoe this table in view.Please response if any have knowledge for this Asap., { "field": "id", { numeric: true, //value 0, 1 => [ 'left_field' => 'age', 2 => [ 'field' => 'published', field: 'age', I 'm facing issue in custom modul in drupal8. "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;, operator, value: 1 } ], value: true } }, weight: 10

CMS Mastering Development Wordpress

Issue with WordPress AJAX Filtering breaking links on frontend

Post author By Marcia D.
Post date May 17, 2020
No Comments on Issue with WordPress AJAX Filtering breaking links on frontend

I’ve been using AJAX taxonomy/post filtering for the past week and just noticed something really strange upon further testing. When you select the filter criteria and click FILTER, it populates the proper posts; however, a random mix of the content that is populated has broken links in there custom metadata. Example: When you visit the […]

Tags '; } echo $state.' '.get_fie, 'dpc_restaurant_amenity_filter'); // wp_ajax_{ACTION HERE} add_action('wp_ajax_nopriv_myfilter', 'dpc_restaurant_amenity_filter'); function dpc_restaurant_amenity_filter(){ $args = array( 'post_type' =, 'nopaging' => true, 'orderby' => 'date', 'orderby' => 'name' ) ); foreach ($terms as $term) { echo '<input, 'orderby' => 'title', 'post_status' => 'publish', 'posts_per_page' => -1, 'taxonomy' => 'location-type', 'taxonomy' => 'restaurant-amenities', 'term' => 'restaurants', 'term' => $term->slug, 'terms' => $_POST['categoryfilter2'], ), ); query_posts( $args ); if( have_posts() ) : ?> <?php $args = array(, { "field": "id", // form data type:filter.attr('method'), // POST beforeSend:function(xhr){ filter.find('button').text('Processing...'); // changing the button label, // we will sort posts by date 'order' => $_POST['date'] // ASC или DESC ); $relation = 'OR'; if(!, $order = " ASC ", 200, a random amount of the restaurants have broken website and/or social links. It's super strange. Upon inspection of the code in Chrome, a random mix of the content that is populated has broken links in there custom metadata. Example: When you visit the Restaurants page, and social media links) until you click one of the filter criteria (like Delivery, array( 'taxonomy' => 'restaurant-amenities', data:filter.serialize(), dpc, etc.). Once you click the filter criteria and submit it, featured image, I've been using AJAX taxonomy/post filtering for the past week and just noticed something really strange upon further testing. When you selec, it looks like the link doesn't break but instead closes before the icon element...something that doesn't happen UNTIL the AJAX script runs. S, it populates the proper posts; however, it shows ALL restaurants with all of the respective metadata for the custom post type (such as description, locations = '{}', no posts matched your criteria.', Pet Friendly, success:function(data){ filter.find('button').text('FILTER'); // changing the button label back $('#response', the filtered content loads; however, Website link

Mastering Development

react-admin useGetOne not working as expected

Post author By Full Stack
Post date May 5, 2020
No Comments on react-admin useGetOne not working as expected

In react-admin there is a option to use useGetOne hook, to fetch one record, example as below import { useGetOne } from ‘react-admin’; const UserProfile = () => { const userId = 10; const { data, loaded, error } = useGetOne(‘users’, userId); if (!loaded) return “NOT LOADED…”; if (error) return “ERROR”; if (!data) return “NO […]

Tags 'order' => 'DESC', "perpage": 10, { "field": "id", { name: 'hello' } ) Any idea why this happens?, error } = useGetList( 'users', error } = useGetOne('users', example as below import { useGetOne } from 'react-admin'; const UserProfile = () => { const userId = 10; const { data, In react-admin there is a option to use useGetOne hook, loaded, page: 1, to fetch one record, userId); if (!loaded) return "NOT LOADED..."; if (error) return "ERROR"; if (!data) return "NO DATA"; return (

CMS Mastering Development Wordpress

How do I match a current post category slug with a custom taxonomy term to display the custom post which is in that custom taxonomy term?

I currently have a custom loop which is placed in single.php, this gets a post from a custom post type called ‘game’ by tag and matches it to the tag of the current post, so if the current post has a tag of “God of War” it gets the game from the custom post type […]

Tags 'category_name' => $gameCat ) ), 'orderby' => 'asc', 'platform'); if ( ! is_wp_error( $terms ) && ! empty( $terms ) ) { foreach ($terms as $term) { echo '<a class="term-link" h, 'platform').'">'.$term->name.''; } echo ''; } } This also works well in outputting the custom taxonomy term of the g, 'post__not_in' => array ($post->ID), 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array( array( 'taxonomy' => 'post_tag', 'terms' => $getGameInfoByTag, ); //the query $relatedGame = new WP_Query( $args ); //loop through query if($relatedGame->have_posts()){ while($relatedGame->have_post, { "field": "id", $post_tag, array('fields' => 'ids') ); $gamePostCategory = get_the_category( $post->ID ); foreach ($gamePostCategory as $gpc){ $gameCat = $gpc->c, I currently have a custom loop which is placed in single.php, if the game is on both PS4 and PS5 I will create two game posts and put one in PS4 terma nd one in PS5 term. When I am creating a regular po, it can also apear in both the PS4 and PS5 categories. I would like to be able to match the current post category and get the 'game' post whic, so if a user is viewing mysite.com/ps4/some-post-about-a-game, so if the current post has a tag of "God of War" it gets the game from the custom post type called God of War and displays a game info box. T, the game in the 'game' post type will be posted under two different taxonomy terms, the game info box will show teh game information from the game which is in the ps4 custom taxonomy term. I have tried a few things but can't, this gets a post from a custom post type called 'game' by tag and matches it to the tag of the current post

CMS Mastering Development Wordpress

wp_query is showing posts from other categories

Post author By Marcia D.
Post date May 4, 2020
No Comments on wp_query is showing posts from other categories

I am trying to make a custom loop that will display the latest 5 posts from select categories, all using a single query. I want the loop to display the category name followed by the 5 posts, and then the next category, etc. I followed this answer and it seems to do what I want, […]

Tags 'tax_query' => array( array( // arguments for your query 'taxonomy' => 'category', 'terms' => $selected_categories, { "field": "id", // $selected_categories contains an array of post IDs. ) ) ); $query = new WP_Query($args); $q = array(); while ( $query->ha, 101, 102 and 103, all using a single query. I want the loop to display the category name followed by the 5 posts, and also in category 250, and then the next category, based on this, Currently, etc. I followed this answer and it seems to do what I want, except it doesn't output the categories properly. For example, I am trying to make a custom loop that will display the latest 5 posts from select categories, if there is a post in category 100, it should display like this: 100 Post 1 Post 2 Post 3 Post 4 Post 5 101 Post 1 Post 2 Post 3 Post 4 Post 5 etc. However, it will also display the title of category 250 too, let's say I want to display categories 100, like so 250 Post 1 How do I get it that it ONLY displays the categories specified? Here's the code I have so far

CMS Mastering Development Wordpress

How to query to return custom post types with categories and custom taxonomy?

Post author By Marcia D.
Post date April 17, 2020
No Comments on How to query to return custom post types with categories and custom taxonomy?

The following query is in a function used to filter posts based on user selection on the front-end. This site has blog feeds(CPT) by different authors that users can select to show by choosing any combination of blog feed, region and/or category. Each feed also has an associated category and region. For example, ‘Blog Feed […]

Tags 'Blog Feed A' has region 'AUS' and category 'travel', 'Blog Feed B' has region 'USA' and category 'Eng Blogs'. As you see, 'compare' => 'IN', 'exclude' => $exclude_array, 'orderby' => 'date', 'posts_per_page' => $numPosts, 'terms' => $settings->categories, 'terms' => $settings->regions, 'value' => $settings->blogs, [ 'taxonomy' => 'region', ], ]; } if (!empty($settings->categories) || !empty($settings->regions)) { $mbaQueryArgs['tax_query'] = ['relation' => 'OR']; if (!em, ]; if (!empty($settings->blogs)) { $mbaQueryArgs['meta_query'] = [ [ 'key' => 'feed_id', ]); } } $query = new WP_Query($mbaQueryArgs); For example, ]); } if (!empty($settings->categories)) { array_push($mbaQueryArgs['tax_query'], { "field": "id", // 'taxonomy' => 'category', 11 [posts] => Array ( ) [post_count] => 0, a selection of only Blog Feed A shows posts. A selection of Blog Feed A AND a region that is not associated with it (USA) should show posts f, but it returns no posts at all. I've tried changing the tax_query relationship from 'OR' to 'AND' without a change in this behavior. Can anyo, from the var dumps I've been doing, here's the SQL query(I don't have much experience here) if that is helpful from when it fails: [request] => SELECT SQL_CALC_FOUND_ROWS ba_, offset: offset, region and/or category. Each feed also has an associated category and region. For example, The following query is in a function used to filter posts based on user selection on the front-end. This site has blog feeds(CPT) by differen, the post ID of each is passed via $settings. The problem is that it's not returning any posts with certain selections. $mbaQueryArgs = [