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

[grantfitzsimmons]

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!

Reported By
Nate Shoobs at OSU

[specifysoftware]

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

[grantfitzsimmons]

To Reproduce
Navigate to a URL sent to you from another user (or log in as another user and copy the record set URL)
(e.g. https://herb-rbge.specifycloud.org/specify/view/collectionobject/157127/?recordsetid=991)

Edit the record set:

Click on Query:

Build a query with any fields included in the query.

Click Create Record Set in the results and give it a name:

See that you have every record from that table (within the current scope) in that record set:

Expected behavior
This query should be scoped to just items within the record set and those shown in the query.

v7.9.6.2, found on herb_rbge, Vivalid, macOS

[CarolineDenis]

Fixed in 7.10

[grantfitzsimmons]

@bhumikaguptaa encountered this today again on v7.10.2.3