Not found results from queries

[grantfitzsimmons]

I feel like this is a luxury request and is a long-shot in terms of how much would have to be built to support this - but when using the ‘in’ option on a query followed by a comma-separated list, it would be handy for the query to identify or report which requested items weren’t returned in the query.

Not exactly… I’d like it to identify items that are missing completely from the database. For example, if I intended to catalog items with catalog numbers 143959 through 146323, I would like to query that range using “in,” supply it with the list of expected numbers, and see if I missed any in the results. something like “Not found: 144835, 14523” would be helpful. As is, I can just export and open the results in Excel to inspect for missing items, hence this would be a ‘luxury’ feature.

Requested By: Paul at FWRI (Speciforum)

[specifysoftware]

This issue has been mentioned on Specify Community Forum. There might be relevant details there:

https://discourse.specifysoftware.org/t/not-found-results-from-queries/1028/4