• Resolved martvanderkruis

    (@martvanderkruis)


    I have created a page with Elementor where I have added a PODS shortcode in which I use a where=”” statement to show 1 pod based on a date AND a location. I tried this:
    [pods name=…. where=”CAST(post_date as DATE) BETWEEN ‘2019/12/31’ and CURDATE()”] which works fine.

    I also tried this:
    [pods name=…. where=”groep.post_title='{@post.page_id}’”] which also works fine. (I use that special magic tag to get the location)

    But when I put them together like this:
    [pods name=…. where=”groep.post_title='{@post.page_id} AND CAST(post_date as DATE) BETWEEN ‘2019/12/31’ and CURDATE()’”] it doesn’t work!?

    Both are true on the same pod but whatever I try, I can’t seem to get it to work. Any ideas?

    Thanks

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

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

    (@keraweb)

    Hello @martvanderkruis

    Sorry for my late reply.
    You could use Query Monitor to find the query. This will show you where the query parser might got it wrong.
    My first thoughts might be the usage of AND. Maybe you could wrap both statements within brackets ().

    Cheers, Jory

    Plugin Author Jory Hogeveen

    (@keraweb)

    Closing topic due to no reply, feel free to reopen if you still need help!

    Cheers, Jory

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘PODS where=”” (2 conditions) not working’ is closed to new replies.