[SHORTCODE] “NOT” in custom WHERE

  • Resolved ledevweb

    (@ledevweb)


    4 years, 1 month ago

    Hi all,

    Can someone tell me how I can set my Pods shortcode to not select all CPT that are NOT in a specific taxonomy ?

    To select CPT that are in a specific taxonomy I use taxonomy_name.slug = "a" in my WHERE condition and it works fine, but how can I do if I want to select all items that are NOT in the “a” taxonomy ? I tried taxonomy_name.slug != "a" but it doesn’t work at all.

    Help would be much appreciated ??

    Thx

    [EDIT] I’ve tried the “NOT” syntaxe (cf https://www.w3schools.com/sql/sql_and_or.asp) : NOT taxonomy_name.slug = "a" by it doesn’t work either.

    • This topic was modified 4 years, 1 month ago by ledevweb.
    • This topic was modified 4 years, 1 month ago by ledevweb.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @ledevweb

    Please try the NOT IN syntax:
    taxonomy_name.slug NOT IN ('a').

    Cheers, Jory

    Plugin Contributor Bernhard Gronau

    (@quasel)

    Hey there! This thread has been pretty quiet for the last two weeks, so we’re going to go ahead and mark it as resolved. If you’re still looking for help with this, please do comment!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[SHORTCODE] “NOT” in custom WHERE’ is closed to new replies.