Bas van der Togt
Forum Replies Created
-
Forum: Developing with WordPress
In reply to: WP_Query sort by multiple custom fields@abretado1985 I need a single query because of pagination.
Its a single post_type named ‘news’. The post type has two acf fields ‘type’ (news/event) and ‘date’. I want to show the upcoming events ASC first and then all news DESC.
Forum: Developing with WordPress
In reply to: WP_Query sort by multiple custom fieldsThank you @abretado1985
I have an order by clause now but the ordering is not right yet.
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) WHERE 1=1 AND ( ( ( ( wp_postmeta.meta_key = ‘type’ AND wp_postmeta.meta_value = ‘event’ ) AND ( mt1.meta_key = ‘from’ AND CAST(mt1.meta_value AS DATE) > ‘20240117’ ) ) OR ( ( mt2.meta_key = ‘type’ AND mt2.meta_value = ‘news’ ) ) ) ) AND ((wp_posts.post_type = ‘news’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘archived’ OR wp_posts.post_status = ‘private’))) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS CHAR) ASC, CAST(mt1.meta_value AS DATE) ASC, CAST(mt2.meta_value AS CHAR) DESC LIMIT 0, 100
returns first the news ASC and then events ASC
i want to have first events ASC en then news DESC
- This reply was modified 2 years, 4 months ago by Bas van der Togt.
- This reply was modified 2 years, 4 months ago by Bas van der Togt.
- This reply was modified 2 years, 4 months ago by Bas van der Togt.
Forum: Developing with WordPress
In reply to: WP_Query sort by multiple custom fieldsThanks for the replies but none of them is a working solution.
orderby meta_query should be possible since 4.2 see https://make.ww.wp.xz.cn/core/2015/03/30/query-improvements-in-wp-4-2-orderby-and-meta_query/
Forum: Plugins
In reply to: [SAML 2.0 Single Sign-On] How can I handle additional attributei’m looking for the same answer. Anybody?
Forum: Plugins
In reply to: [WooCommerce] Facebook product feedNo it gives the same errors