Record Formatter previews not scoped

[grantfitzsimmons]

Describe the bug
Records from other collections appear in the record formatter previews, but they should only show results scoped to the logged-in collection and permission level of the current user.

To Reproduce
Steps to reproduce the behavior:

1. Log into the nbm_mnb_2024_06_28 database as spadmin and log into the "Fish Voucher Collection"
2. Go to https://nbmmnb20240628-edge.test.specifysystems.org/specify/resources/app-resource/13/formatter/Preparation/49 (Preparation Table Format)
3. See the preview
4. Note that preparation types that do not exist within the current collection appear in the preview, indicating that the preview is not scoped to preparations only present in the current collection

Expected behavior
The preview should be scoped correctly (within the current collection)

Screenshots

Voucher Collection:

Amphibian and Reptile Collection:

Crash Report
Specify 7 System Information - 2024-07-01T17_12_55.805Z.txt

Seems to be happening since v7.9.4 (when preview was introduced)

Observed by: New Brunswick Museum

[melton-jason]

This behavior was intentional, and introduced by #4509.

There was an issue in that some tables can not be reliably scoped and thus would throw an error when trying to enforce scoping: #3564.

A more general approach to scoping can be used instead (see a usage of the implementation in #5044), but I agree with #5044 (review) in that the same logic should probably be utilized in the backend (instead of used in a myriad of places on the frontend).

[emenslin]

Can recreate in edge (7.9.6.2)