Different results when running same query in Specify

[Grant]

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:

1. Your Specify 6 instance is configured to search across collections, which does not change query behavior in Specify 7.
2. 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 Preferences app resource?

GLOBAL_SEARCH=true
GLOBAL_SEARCH_AVAIL=true

Allow Queries to Search All Collections in a Database

By default, queries only search the collection the user is logged into at the time. Databases can be configured to query across all of the collections in the database by modifying preferences. Note that this only changes the behavior in Specify 6. Specify 7: Go to the App Resources viewer and add the following two lines: GLOBAL_SEARCH=true GLOBAL_SEARCH_AVAIL=true Save and log out and back in. [Global Prefs] Specify 6: In Specify, click Help->About. [image] In the About window, do…