Using “Where” in pods shortcode

  • Resolved kaostc

    (@kaostc)


    1 year, 10 months 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 Author Jory Hogeveen

    (@keraweb)

    1 year, 10 months 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)

    1 year, 10 months 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 1 year, 10 months ago by kaostc.
    • This reply was modified 1 year, 10 months ago by kaostc.
    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    1 year, 10 months ago

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

    Thread Starter kaostc

    (@kaostc)

    1 year, 10 months ago

    Great! It works now.

    Thanks a lot.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Using “Where” in pods shortcode’ is closed to new replies.