Syntax for IN Cat1 And NOT IN Tag1

Thanks for your question and for the additional explaination of how you want to use the “Deleted” tag. The logic is clear, but it cannot be applied using the “Simple Taxonomy Parameters” that [mla_gallery] supports.

You can accomplish your goal with the more powerful tax_query syntax I mentioned in your earlier support topic:

Syntax problem for Jetpack gallery with ‘AND’ tags

Your first example can be coded as something like:

<code>[mla_gallery tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'cat1' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), ), )" ... ]</code>

If you want to filter on both Att. Category and Att. Tag and then add the “Deleted” tag, you can try something like:

<code>[mla_gallery tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'cat1' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'red', 'blue' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), )" ... ]</code>

Be sure to follow the rules in the earlier topic for entering these complicated shortcodes.

The only potential disadvantage I can see to using these tax_query parameters is that WordPress translates them to SQL using table JOIN operators. This can have performance implications if you have large numbers of items, categories or tags. If the performance of the above suggestions is not acceptable, let me know and I can work with you on a higher performance (but even more complicated) alternative.

I hope that gets you started with your application. I am marking this topic resolved, but please update it if you have problems or further questions regarding the above suggestions.

Hi
Thanks again for your help. I have made an attempt but get an error which seems to be similar to “Magic Quotes”

This is the code I entered:
[mla_gallery type="default" size="medium" tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'sml-full-length' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), ), )" ... ]

Differences between this an your example:
type=”default” size=”medium” (but also tried without it)
cat1 changed to the actual category slug sml-full-length

The deleted tag does exist in my tags

Error:
ERROR: Invalid mla_gallery tax_query = ‘array( \’relation\’ => \’AND\’, array( \’taxonomy\’ => \’attachment_category\’, \’field\’ => \’slug\’, \’terms\’ => array( \’sml-full-length\’ ), ), array( \’taxonomy\’ => \’attachment_tag\’, \’field\’ => \’slug\’, \’terms\’ => array( \’deleted\’ ), \’operator\’ => \’NOT IN\’, ), ), )’
I am assuming the \ is the issue, I see lots of references online, most seem to relate to older WP and suggest adding code to functions.php or footer.php

I am reluctant to change core code if not necessary.

I have tried:
Copying to Notepad then to WP
Copying directly to WP
Manually deleting and replacing ‘ with the keyboard

My site spec:
PHP Version: 5.3.29
WordPress Version: 4.3.1
Genesis Version: 2.1.2
Dynamik Version: 1.9.1
Font Awesome Version: 4.4.0

Your further help would be appreciated.

Thanks for your update, for posting the complete text of your shortcode and for all the fixes you’ve tried.

The “\” characters are an artifact of the code used to print the error message; they do not appear in the actual shortcode.

As the earlier topic outlined, WordPress has been changing the way it parses shortcodes and this has had side effects on complicates parameters like the tax_query.

The first thing to try is this point from the earlier topic:

• Be sure the put and tags around the entire shortcode. Recent versions of WordPress mangle the special characters like “=>” in the query if you don’t add the tags.

Have you done that? Also, take out the elipses at the end of the shortcode. They were intended to suggest additional parameters and this may have been confusing. Your shortcode should look like:

<code>[mla_gallery type="default" size="medium" tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'sml-full-length' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), ), )"]</code>

If those suggestions don’t solve the problem, I can investigate further.

Sorry for delay in getting back to you.

The only difference between my code and your example above was the ellipses.

I removed those and get the same error output. To double check I deleted my code and copied and pasted your code into the Text tab. I also copied to Notepad first and confirmed it was all on one line.

The previous simpler code you recommended is still working fine on the same site.

You kindly offered to investigate further. I would appreciate that.

Ckxion

Thanks for your update, and please accept my apologies. The final shortcode I gave in my last post does indeed have a syntax error. There is one too many closing parenthesis at the end of the query specification. The shortcode should be:

<code>[mla_gallery type="default" size="medium" tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'sml-full-length' ), ), array( 'taxonomy' => 'attachment_tag', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), )"]</code>

That code is working on my system and should work for you as well. Again, my apology for the incorrect suggestion in my earlier post and thanks for your patience.

You are a superstar!!

You are still a superstar, but I spoke to quickly about my resolution.

The error message has gone away and gallery is displaying, but the image with category Deleted is still being returned.

Let me clarify my logic, incase I was not clear.

I have an image with category sml-full-length – it displays OK

I add the Category Deleted (without removing sml-full-length – as I might want to use it again if the item comes back into stock).

Now with both tags it is still returned.

To make it not appear in gallery I have to remove the sml-full-length tag

Assuming I am doing things correctly I am assuming you can recommend different Syntax, however a workaround might be to change the code to recognise a Deleted Tag

Thanks CKxion

Thanks for your updates and for the clarification of your logic.

I believe you can use the attachment_category taxonomy for both of your clauses and get the results you want. Try changing your tax_query to:

<code>[mla_gallery type="default" size="medium" tax_query="array( 'relation' => 'AND', array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'sml-full-length' ), ), array( 'taxonomy' => 'attachment_category', 'field' => 'slug', 'terms' => array( 'deleted' ), 'operator' => 'NOT IN', ), )"]</code>

I haven’t specifically tested that, but it should work.