Using “Where” in pods shortcode

  • Resolved kaostc

    (@kaostc)


    2 months, 2 weeks ago

    I am trying to display all my elements for a custom post type called team_member, in this way:

    [pods name="team_member"]
...
[/pods]

    And it works ok :).

    But if I try:

    [pods name="team_member" where="member_type.name = 'Affiliate'"]
...
[/pods]

    Where member_type is a taxonomy connected to team_member. The term with name Affiliate exist. And I get this error: “Pods Embed Error: WHERE contains SQL that is not allowed.”

    I have strictly followed this page example: https://docs.pods.io/displaying-pods/pods-shortcode/

    [pods name="podsname" where="taxonomy_name.slug = 'term slug'"]{@post_title}[/pods]

    Any help will be appreciated. Thanks a lot.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Jory Hogeveen

    (@keraweb)

    2 months, 2 weeks ago

    Hi @kaostc

    Since the latest security updates we added an extra tab for each Pod you create in which you can define what options should be allowed or not. Please check these configs for the team_member post type Pod.

    Cheers, Jory

    Thread Starter kaostc

    (@kaostc)

    2 months, 2 weeks ago

    Please, can you clarify which tab are you referring? And which options I have to check.

    Maybe this screenshot clarify something to you. Everything appears to be allowed.

    • This reply was modified 2 months, 2 weeks ago by kaostc.
    • This reply was modified 2 months, 2 weeks ago by kaostc.
    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    2 months, 2 weeks ago

    Check the security setting for this in Pods Admin > Settings > Allow SQL clauses to be used in Dynamic Features.

    Thread Starter kaostc

    (@kaostc)

    2 months, 2 weeks ago

    Great! It works now.

    Thanks a lot.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.