Exclusion logic for formats

[andybak]

What should this do?: assets?format=GLTF2&format=-TILT

1. (current behaviour I think) All assets that EITHER have gltf2 OR have no tilt file
2. All assets that have gltf2 BUT have no tilt file

Option 2 seems more useful to me and solves a use case I actually have ("I want all these formats but not if they have tilt files"). I can't think of a use case for the current behaviour..?

Extending it to multiple formats and it seems consistent to do:

1. Get all the non-negative results
2. Exclude the negative results

How to handle multiple negative formats types?

1. OR them all together: "Exclude all assets that have tilt or blocks"
2. AND: "Exclude all assets that have tilt AND blocks"

Option 1 is consistent with how the non-exclude queries work. And it seems at first glance to be more likely to be useful.

[andybak]

@jamesrampton - I'm bumping up against this one at the moment. Can you take a look?

[andybak]

My specific use case right now is:

format=fbx&format=obj&format=gltf2&format=-blocks

I want all assets that have any supported format but i want to exclude those that also have a blocks file.

The reason is that I have two modes for browsing 1: "assets that have native blocks" and 2:"everything else we can import"

[jamesrampton]

I agree wholly with this, there's no useful reason not to AND together the exclusions.

assets?format=GLTF2&format=-TILT should now be returning what you need.

[jamesrampton]

Amend to (for example) Q: (AND: (OR: ('has_fbx', True), ('has_obj', True), ('has_gltf2', True)), (OR: ('has_blocks', False), ('has_tilt', False)))