[Resolved] View Ignoring The Event Start Date Field

[Author]

Posts

[tylerG]

I created a View that displays upcoming events from The Events Calendar plugin. I used the exact same set up as several other sites and pulled in the _EventStartDate field from TEC plugin. The problem is the View doesn't seem to be recognizing the field for ordering or filtering. I even imported a similar View from another site that works great and it doesn't work on this site. I set up a staging site and deactivated all unnecessary plugins and set the theme to 2017 with no luck.

I will pass along a user account to the staging site. To be able to view the site, you'll need to enter username "flywheel" and password "cybersprout". These only allow you to view the site. The account credentials I'll pass through the form.

Thank you!

[Minesh Supporter Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30)]

Hello. Thank you for contacting the Toolset support.

Could you please share the details which view you are using and to which page you added. Please share problem URL.

Additionally, please share details which view works for you and URL.

I have set the next reply to private which means only you and I have access to it.

[tylerG]

Here is the test page where the View is not working: hidden link

I'm using the same view loop on other websites where it is working: hidden link

[Minesh Supporter Languages: English (English ) Timezone: Asia/Kolkata (GMT+05:30)]

The thing is that _EventStartDate field stores date as string and Types stores custom date field value as timestamp.

I've added the following code at "Custom code snippe" section:
=> hidden link

add_filter( 'posts_where' , 'func_posts_where' );
function func_posts_where( $where ) {
 global $wpdb;
global $WP_Views;
 
     if($WP_Views->current_view == 8020){
         
          $where = str_replace("CAST(mt1.meta_value AS SIGNED)","UNIX_TIMESTAMP(mt1.meta_value)",$where);
       
     }
    return $where;
}

I see now - its displaying the correct events now. Could you please confirm.
=> hidden link

[tylerG]

My issue is resolved now. Thank you!