ventatto

I can’t see what you mean by doing something like ORDER BY MONTH( post_date )… However, I found a way to address my problem here and adapted it. It still does not work but I’d like to know if it’s in the right direction.

add_filter( 'posts_orderby', 'birthday_sort', 10, 2 );
function birthday_sort( $orderby, $query ) {
    if ( ! is_admin() && 'post_date' === $query->get( 'orderby' ) ) {
        global $wpdb;

        $order = ( 'ASC' === strtoupper( $query->get( 'order' ) ) ) ? 'ASC': 'DESC';

        // This means, we still sort by the date, but we "recreate" the date using
        // the year 2020 (or any leap year), and month and day from the meta value.
        $orderby = "STR_TO_DATE( CONCAT( '2020-',
            MONTH( {$wpdb->postmeta}.meta_value ), '-',
            DAY( {$wpdb->postmeta}.meta_value
        ) ), '%Y-%m-%d' ) $order";
    }
	
    return $orderby;
}

add_action( 'pre_get_posts', 'birthday_orderby_meta' );
function birthday_orderby_meta( $query ) {
 
    $orderby = $query->get( 'orderby');
 
    if( 'post_date' == $orderby ) {
        $query->set('meta_key','post_date');
        $query->set('orderby','meta_value');
    }
}

Hi,

Alright, hope a developer can give me further help. By the way, I saw a link to a Slack community for developers but it does not work… is it normal ?

Thanks,
Tom

Great I found something similar to this but yours is better organized. Thanks for your help !

Thanks @savvasha !

Hi @corrinarusso, it indeed does not appear in the output of an event. But I think it’s a great feature to filter events so I want to profit from it by setting events’ background color consequently.

Since I can now test my ical feed, I have a better solution @bartvanbelle ! Here you can see only modifications to feeds/ical.php which means that no modifications to modules/sportspress-bulk-actions.php is needed anymore and therefore the event title won’t be modified.

Hey @bartvanbelle,

I just found a temporary solution for changing event title depending on event status from bulk actions. It is not an optimal solution but it works in this case (status is either cancelled or postponed). If you want to switch back to “On time” status, you must do it on the event edit page and probably change manually the title.

Here it is (should be more modular to be clean) !

• This reply was modified 5 years, 8 months ago by ventatto.
• This reply was modified 5 years, 8 months ago by ventatto.

I just gave it a try but without success.

Thanks for your help,
Tom

For sure ! However, I have a problem with testing my solution because it’s been a few days that I no longer have access to my ical links ? I am told that

There was an error subscribing to the calendar.

for instance :

A calendar wasn’t found on webcal://www.saintlouisbasket.be/calendar/r1-20-21?feed=sp-ical. Check the URL.

Do you have an idea by the way ?