Filter by meta – BETWEEN

  • Resolved ulisesub

    (@ulisesub)


    4 years, 4 months ago

    Hi,

    I’m actually show post between meta specific dates like:

    ?call_custom_simple_rss=1&csrp_post_type=tribe_events&csrp_posts_per_page=10&csrp_tag=saber&csrp_meta_key=_EventStartDate&csrp_meta_value=2020-06-13,2020-06-20&csrp_meta_type=DATE&csrp_meta_compare=BETWEEN&csrp_orderby=meta_value&csrp_order=desc

    I need change in my query to “&csrp_meta_value=TODAY, TODAY + 20”
    Is it possible?

    Thanks, Ulises

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author danikoo

    (@danikoo)

    Hi and sorry for the late reply (crazy days).

    you can use the ‘ago’ – for example ’20 day ago’ .

    in order to make a date query from 20 days ago :
    call_custom_simple_rss=1&csrp_date=1&csrp_date_after=20 day ago

    · csrp_date – must be set to 1 to intiate the date query
    · csrp_date_after (string | optional) – posts after this date. optional values:
    ‘yyyy-mm-dd’
    ‘1 year ago’
    ‘1 week ago’
    ‘1 day ago’
    · csrp_date_after_type (string | optional) – get posts by publish date OR modified date – default is publish date. optional values:
    ‘date’
    ‘modified’

    Hope that helps ??
    best regards Danny

    Thread Starter ulisesub

    (@ulisesub)

    Hi,

    thanks for your answer, but i need use meta key in my URL parameters “&csrp_meta_key=_EventStartDate” and I need get future events from today to next month. I use “Events calendar Pro – Tribe Events”.

    Actually, i use date string in my URL and i need change this per “TODAY” or someting like this.

    my URL=”?call_custom_simple_rss=1&csrp_post_type=tribe_events&csrp_posts_per_page=10&csrp_tag=saber&csrp_meta_key=_EventStartDate&csrp_meta_value=2020-06-13,2020-06-20&csrp_meta_type=DATE&csrp_meta_compare=BETWEEN&csrp_orderby=meta_value&csrp_order=desc”

    thanks, Ulises

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Filter by meta – BETWEEN’ is closed to new replies.