Profile: bobA-2

Problem:

Allow user to search with date only when there is a date time picker.

Solution:

Actually no it is not possible. The reason is because a datetime custom field and just a date gives 2 different values being stored in the database.

As you may not be away the dates are stored in the database as an epoch or unix timestamp. This means they are stored as numbers and not actual human readable dates.

Take a look at the link below.
https://www.epochconverter.com/

This is a simple converter to clear things up. So a datetime will store the time as well.

Lets say my current datetime is February 14, 2019 9:52 AM, this will convert to 1550155920

While the date only will convert to 1550120400

As you can see both are representative of the same date however the Date only will always default to 12:00 AM as this signals the start of a new date.

So technically speaking it is a Datetime with just a fixed time.

If you look at the comparisons an how they are done, If a user uses date filter for today they will only get posts that have a numeric value equal to "1550120400" even though posts who have values of "1550155920" are still on the same day but because these numeric values are different it will not show up.

Problem: I am using a View of child posts nested inside a View of parent posts to display parent and child post information. I would like to filter out parents that do not have any children.

Solution: There is no built-in way to filter out childless parent posts, so the solution requires custom code. Another ticket in the forum discusses this approach:
https://toolset.com/forums/topic/table-with-child-posts

add_filter('wpv_filter_query', 'jobs_with_bewerbungs_func', 101, 3);
function jobs_with_bewerbungs_func($query, $view_settings, $view_id) {
  $views = array( 84 );
  $relationship_slug = 'job-bewerbung-multis';
  $parent_type_slug = 'job';
  // you should not edit anything below this line
  if ( in_array( $view_id, $views ) ) {
    $ids = array();
    $parents_args = array(
      'post_type' => $parent_type_slug,
      'numberposts' => -1,
    );
    $parents = get_posts( $parents_args );
    foreach($parents as $parent) {
      $children = toolset_get_related_posts(
        $parent->ID,
        $relationship_slug,
        'parent',
        1000000,
        0,
        array(),
        'post_id',
        'child'
      );
      if( !is_array($children) || count($children) < 1 ) {
        array_push( $ids, $parent->ID );
      }
    }
    $query['post__not_in'] = isset($query['post__not_in']) ? $query['post__not_in'] : array();
    $query['post__not_in'] = array_merge($query['post__not_in'], $ids );
  }
  return $query;
}

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

Problem: I would like to create a conditional that tests the value of a custom date field. If the date is today - the current date - then I would like to display some content. However, testing the value against TODAY() does not seem to work.

Solution: You must create a conditional that tests if the date value is between the end of yesterday - TODAY() - and the beginning of tomorrow - FUTURE_DAY(1).

[wpv-conditional if="( $(wpcf-birthdate) gte 'TODAY()' ) AND ( $(wpcf-birthdate) lt 'FUTURE_DAY(1)' )"]
Happy Birthday! It's today!
[/wpv-conditional]

Relevant Documentation:
https://toolset.com/documentation/user-guides/conditional-html-output-in-views/