Hello,
One of the scientists that is using Specify has noticed that the same query has completely differing results when run in Specify 6 vs 7.
In Specify 6 the query returns ~447k results, whilst in Specify 7 it returns on ~29k results.
Is there an obvious change in functionality between Specify 6 & 7 that would be causing such a difference? The query is the exact same (ran from the saved queries on the same db under the same account.)
We’re running Specify 6.8.03 and Specify v7.9.6.2.
If there’s any other information that might be helpful let me know and I’ll happily supply it - i’m hoping that I’ve missed something simple in the way that the results grouping differs between 6 and 7.
Thank you for your message and for the detailed description!
One of the scientists that is using Specify has noticed that the same query has completely differing results when run in Specify 6 vs 7.
In Specify 6 the query returns ~447k results, whilst in Specify 7 it returns on ~29k results.
There are a couple of likely reasons you are seeing a discrepancy in the query results:
Your Specify 6 instance is configured to search across collections, which does not change query behavior in Specify 7.
This query has filters in Specify 7 that are not visible or usable in Specify 6.
I believe the most likely reason is point 1, but to verify, could you check if the following lines are included in your Global Preferencesapp resource?
Adding them also does not seem to change the numbers in the query either - the count in Specify 7 with the two global preferences added remains at 29K records:
(I made sure to clear the cache after changing the global preferences)
The query was originally written in Specify 6 and wasn’t modified at all in Specify 7 before use (just ran directly from the saved query) - are there any filters that might be added in Specify 7 that would cause the discrepancy?
