Topic Tag: Views plugin

Problem:

The issue here is that the user added the filters but the query filters were missing, so the filters were not working on the frontend.

Solution:

TO resolve this all that is needed is to remove and re-add the filters and it should resolve the issue.

Problem: I would like to sort a View using a calculated value.

Solution: Unfortunately this isn't a built-in feature because WordPress does not provide methods for querying posts using calculated values.

Instead, you may be able to programmatically set a custom field value, then order by that custom field. For example, let's say your calculated value is 1 or 2, based on whether or not the post status is "published" and the author's ID = 1. You will add a custom field to this post type called "is-admin-published". Then use the save_post hook to set the custom field to be the calculated value whenever you save a post:

function set_is_admin_published_field ( $post_id ) {
  $post_type = get_post_type( $post_id );
  if ( $post_type == 'post' ) {
    $boolean = get_post_status( $post_id ) == 'publish' && get_post_field( 'post_author', $post_id )== 1;
    if( $boolean) {
      update_post_meta( $post_id, 'wpcf-is-admin-published', 1 );
    }else{
      update_post_meta( $post_id, 'wpcf-is-admin-published' , 2 );
    }
  }
}
add_action( 'save_post', 'set_is_admin_published_field', 100 );

Then use the View's ordering options to select the is-admin-published field.

Relevant Documentation:
https://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters

Problem:
How to filter view by Event Start Date (_EventStartDate) of events Calendar plugi.

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

You can find the proposed solution, in this case, with the following reply:
https://toolset.com/forums/topic/view-ignoring-the-event-start-date-field/#post-1112239

Relevant Documentation: