Can't put events in date order in search results

Hi,

Thank you very much for the details, it helps a lot!

Try this custom field: mec_start_date
Apparently that is the one storing the start dates with that plugin.

The order actually seems to be correct, that is going to be the right field, the titles are the ones not being correct as it seems.
For example searching “sustainibility”, clicking on the second result the actual date is different.
The same seems to be with all of the others, althought I only checked a few.

The ordering field type was set to numeric, I changed it back to “date or string”: https://i.imgur.com/PPIIjTm.png
Now it looks all right on my end: https://i.imgur.com/XCUA3PO.png

Well this is a tough one, but I guess the best approach is via a custom code.

Try adding this code to the functions.php file in your theme/child theme directory – make sure to have a full server back-up first for safety. For more details you can check the safe coding guidelines.

add_filter("asp_query_args", "asp_query_args_apply_date", 10, 2);
function asp_query_args_apply_date($args, $search_id) {
	$args['post_meta_filter'][] = array(
		'key'     => 'mec_end_date',
		'value'   => date("Y-m-d"),
		'operator' => '>',
		'allow_missing' => false
	);
	return $args;
}

I don’t know if this is going to do anything, but it should remove any items from the results, which have the end date before the current date.

Hi,

The date picker format is usually only for visual purposes only, the actual values are probably stored in the “Y-m-d” format, that is very common. It is more likely a data type issue only.

I have made a correction via the theme file editor, as the code was already there and added extra quote signs to cast the date to a string. Can you check if this changed anything in the results?

For reference, the new code is:

add_filter("asp_query_args", "asp_query_args_apply_date", 10, 2);
function asp_query_args_apply_date($args, $search_id) {
	$args['post_meta_filter'][] = array(
		'key' => 'mec_end_date',
		'value' => "'" . date("Y-m-d") . "'",
		'operator' => '>',
		'allow_missing' => false
	);
	return $args;
}

Thank you! Great 🙂

If you don’t mind, I will close this topic soon and mark it as resolved, feel free to open another one if you have other questions or issues.

If you like the plugin and have not rated already, feel free to leave a rating on your codecanyon downloads page, it’s greatly appreciated.

Oh, I’m sorry, I just copy/pasted from a default response, I only wanted to ask if I can close the topic 🙂