1. In the Orthoptera project (https://sfg.taxonworks.org/) I have a list of 95721 records of collection objects that have taxon names that are descendants of the Orthoptera order.
2. I would expect that all the collection objects in this project belong to Orthoptera but if I run the filter without specifing anything, then I get 95759 results.
3. There are 38 records that are not placed under the Orthoptera order and I want to get a list of them to analyze what is going on. (This also happens with the cepave database but in that case the difference is larger (55.665)
4. I have tried to use the option "Inverse exclude (B not A)" of the Venn function but it is not making any difference. It gives me the complete list for the second query with no exclusion of the first query at all.
I also need to make this operation to get the number of records in the cepave database that do not include the word TEST in their catalog number.
What should I do? Or what am I doing wrong? Is it working properly? I there any other way I can get this answers for the questions I have?
...
Steps to reproduce the bug
Screenshot
No response
Expected behavior
No response
Additional Screenshots
No response
Environment
Production
Sandbox Used
No response
Version
v0.42.0
Browser Used
Chrome