i need to return/echo the name of the department/location for each group of employees That is actually a generic PHP/programming question, nonetheless, if you mean an output which looks like so: Location/Department Name – Employee/user – Employee/user – Employee/user Location/Department Name – Employee/user – Employee/user Then here’s one way of accomplishing that: Add this above/before … Read more
Approaching this from the SQL is a mistake, and instead a quick search of the official dev docs for filename reveals a filter named wp_allow_query_attachment_by_filename that is set to true by default: https://developer.wordpress.org/reference/hooks/wp_allow_query_attachment_by_filename/ apply_filters( ‘wp_allow_query_attachment_by_filename’, bool $allow_query_attachment_by_filename ) Filters whether an attachment query should include filenames or not. This means you can disable querying filenames … Read more
TL;DR: WordPress uses URL query string variables to select a template based on the Template Hierarchy. General template selection steps Permalink structures are used to create rewrite rules. Rewrite rules take a pretty permalink URL and convert it into a plain URL with a query string. Parameters from the query string are used to choose … Read more
Your approach is on the right track, but there are a couple of adjustments needed to make it work as intended. The primary issue is with the scope and updating of the $last_value variable. It needs to be declared outside of the loop to maintain its state across iterations. Here’s a revised version of your … Read more
In WordPress meta queries, when using the ‘compare’ => ‘IN’ comparison, the value should be an array, not a string. When you manually input array( ‘1302’, ‘1329’ ), it works because it’s correctly formatted as an array. However, when using $artists_string_value, it’s treated as a single string, not an array of values. You should modify … Read more
Deleting posts directly in the DB is not going to clear up all their comments, post metadata, etc. I’d recommend using wp_delete_post() to do this instead. // Gets the post IDs. $author_id = get_user_by( ‘login’, ‘newsagencies’ ); // Use the user’s login here. $posts = new WP_Query( array( ‘author’ => $author_id, ‘date_query’ => array( ‘after’ … Read more
Fixing a small typo should be it (untested): add_action( ‘elementor/query/latest-posts-home’, function ( $query ) { $query->set( ‘post_type’, array( ‘alicorn_case_studies’, ‘post’ ) ); } ); The parameter post-type should be post_type.
This is because have_posts() is for the main loop, and not your custom query. Prefixing each use of have_posts() and the_post() with $WatchListQuery-> will fix it: if ( $WatchListQuery->have_posts() ) { while ( $WatchListQuery->have_posts() : $WatchListQuery->the_post();
In WordPress 6.2+, within WP_Query you can set search_columns parameter (not documented at time of writing) to specify the fields to search: $query = new WP_Query( array( ‘s’ => ‘search term’, ‘search_columns’ => array( ‘post_content’, ‘post_name’, ‘post_title’ ), ) ); You can also use the post_search_columns filter to adjust the search columns. You may need … Read more
I don’t think it will be possible using the User Query Class and probably not through MySQL either, because WordPress saves Arrays as Serialized data, so MySQL can’t interpret it like it could if it was a JSON format. The only solution I can foresee is ordering it yourself using a loop in PHP – … Read more