{"id":7595199,"date":"2016-07-22T16:03:28","date_gmt":"2016-07-22T16:03:28","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/custom-today-filter\/"},"modified":"2016-09-01T16:52:31","modified_gmt":"2016-09-01T16:52:31","slug":"custom-today-filter","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/custom-today-filter\/","title":{"rendered":"Custom Today Filter"},"content":{"rendered":"<p>Hi guys,<br \/>\nI have this query that extracts events in my custom period:<\/p>\n<pre><code>select * from SqE_em_events  where\n\t\t\t\t(date( SqE_em_events.event_end_date) = curdate()\n\t\t\t\tand time(SqE_em_events.event_end_time) &gt; &#039;06:00:00&#039;\n\t\t\t\tand time(SqE_em_events.event_end_time) &gt; curtime())\n\t\t\tor  (date(SqE_em_events.event_end_date) = curdate() + interval 1 day\n\t\t\t\tand (time(SqE_em_events.event_end_time) &lt;= &#039;06:00:00&#039;))\n\t\t\tor  (date(SqE_em_events.event_start_date) = curdate()\n\t\t\t\tand time(SqE_em_events.event_start_time) &gt; &#039;06:00:00&#039;\n\t\t\t\tand time(SqE_em_events.event_end_time) &gt; curtime())\n\t\t\tor  (date(SqE_em_events.event_end_date) = curdate()\n\t\t\t\tand time(SqE_em_events.event_end_time) &lt;= &#039;06:00:00&#039;\n\t\t\t\tand time(SqE_em_events.event_end_time) &gt; curtime())<\/code><\/pre>\n<p>I tried to add custom filter into my_functions.php file in my child theme, but with no success (<a href=\"http:\/\/wp-events-plugin.com\/tutorials\/create-your-own-event-scope\/\"> http:\/\/wp-events-plugin.com\/tutorials\/create-your-own-event-scope\/<\/a>)<\/p>\n<p>My aim is create a custom shortcode to filter events in events list with this &#8220;custom TODAY&#8221;:<br \/>\nCan some one help me to do this filter?<\/p>\n<p>Thank you guys.<\/p>\n<p>https:\/\/wordpress.org\/plugins\/events-manager\/<\/p>\n","protected":false},"template":"","class_list":["post-7595199","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7595199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/7595199\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=7595199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}