search

specify / specify7

Specify 7
https://www.specifysoftware.org/products/specify-7/
GNU General Public License v2.0
66 stars 36 forks source link

Record Sets created from queries on Record Sets are not filtered correctly #5280

Open grantfitzsimmons opened 1 month ago

grantfitzsimmons commented 1 month ago

Describe the bug Creating a record set from another record set without selecting any items creates a record set from all results from the unfiltered query.

To Reproduce Steps to reproduce the behavior:

  1. Query on a record set
  2. Try to create a record set from the results of a record set
  3. See issue

Expected behavior The new record set should be restricted to the results of the query shown to the user.

Screenshots

This method does not appear to work in our collection’s database running Sp7.9.4 Following these instructions produces a recordset larger than the original one, whose contents are the records returned for the second query if run on the whole database, not solely the records within the existing recordset. Notably, the .csv exported from the subquery is correct. So there is just something wrong with the way the recordset is being produced.

Apologies if this is a known bug. But if not, it should be fixed! image image image

Reported By Nate Shoobs at OSU

specifysoftware commented 1 month ago

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

https://discourse.specifysoftware.org/t/create-a-record-set-from-a-record-set/533/3