I'd like to set up an SMW query where I exclude several values of a property. Ideally it'd be something like
{{#ask: [[My property::!orange]] [[My property::!yellow]] [[My property::!red]] }}

But I don't think this works. I think it is interpreted to return pages (or objects) with values other than the one specified. So I think using a single exclusion works, but not a set of them. For example, if a page has value "yellow" for My property, it will be included in the above query since this passes the test for !orange. Tell me if I'm wrong, but I think this is the case.

So instead I have been trying to use #arraymap and features from the variables and arrays extensions to parse a list of pages and set up a query like

{{#ask: [[Page title text::!Page 1]] [[Page title text:!Page 2]] ... etc }}

But this approach ends up with a lengthy query and I think I'm exceeding the limit of a query length. Thoughts on how else to handle this?

So something like:

{{#cargo_query:|tables=Fruit|fields=FruitName,Color|where=Color<>"Orange" OR Color<>"Yellow" OR Color<>"Red"}}

darenwelsh: Your original query should work fine. By default query conditions are joined by AND. If you want OR you need to put OR in the syntax.

Example: https://www.semantic-mediawiki.org/w/index.php?title=Special:Ask&q=[[News%20date::!29%20July%202019]]%20OR%20[[News%20date::!11%20April%202019]]&format=broadtable&limit=50&link=all&headers=show&searchlabel=...%20further%20results&class=sortable%20wikitable%20smwtable&sort=News%20date%2C&order=desc%2Casc&offset=0&eq=yes

If you remove the OR the first two results vanish.