Display pod items using URL query string values in the where clause

  • Resolved Dave Tavres

    (@davetavres)


    5 years, 4 months ago

    First – thanks for building such an amazing tool!!

    I keep searching, but not finding what I’m looking for… which probably means it’s not possible. 🙁

    I’d like to display multiple pod items using the ‘where’ field – using a query string value. So that I could build a URL that displays pod items based on a specific value.

    Here’s the shortcode I’m using on a page:

    [pods name=”movies” where=”movietitle.meta_value = ‘[???????]'” template=”Movies template”]

    I’m guessing I need to write custom code to do this? If so, could you give me the right documentation link to read?

    Thank you SO MUCH 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jim True

    (@jimtrue)

    5 years, 4 months ago

    You would use the Special Magic Tags since you can use them in a WHERE clause as long as you’ve added this to your wp-config.php file (noted in the document):
    define('PODS_SHORTCODE_ALLOW_EVALUATE_TAGS',true);

    This gives you access to the {@get.any} magic tag which allows you to use a Query Variable in your where clause, ie ?search_title="Star Wars" you could use where="movietitle.meta_value = '{@get.search_title}'"

    Thread Starter Dave Tavres

    (@davetavres)

    5 years, 4 months ago

    Thank you so much @jimtrue! I’ll try this. 🙂

    Thread Starter Dave Tavres

    (@davetavres)

    5 years, 4 months ago

    Hey @jimtrue – thanks again. That was what I needed. Thanks for pointing me in the right direction. Sorry to bug you.

    Thanks to your direction, I was able to get this working…

    Dave

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Display pod items using URL query string values in the where clause’ is closed to new replies.