Search dialog does not return results for picklist values containing spaces

[lexiclevenger]

Describe the bug

Hi Specify,
I'm configuring the search dialog for the Permit query combobox. We have a few fields in Permits that are defined picklists. I added them to the search, but selecting values from the picklists that contain spaces results in zero results. I'm guessing because it does not recognise the value as a whole string search.
In the search dialog xml, if I change those fields to straight text boxes and search via the same value using quotes, then I get results.
It would be nicer for users to be able to search by selecting a value from a picklist. (I know they can do this by going through to QB option, but that is another step)

To Reproduce
Steps to reproduce the behavior:

1. Go to Interactions and create a Permit record.
2. Add a picklist value containing spaces in the Type field and save the record.
3. Go to Interactions > Accession > Accession Authorization subview.
4. Click on the Search button next to the Permit query combo box.
5. Search using the same picklist value used in Step 2.
6. See that the record you created in step 1 is not returned.

Expected behavior
Results should be returned regardless of whether a picklist value contains spaces.

Screenshots
Using Search dialog:

Using Query Builder:

https://kufish20240711-v7.test.specifysystems.org/specify/view/accession/new/

Specify 7 System Information - 2024-10-21T20_36_05.589Z.txt

Please, also fill out the following information manually:

• OS: Mac
• Browser: Chrome
• Specify 7 Version: production and earlier
• Database Name: KUFish_2024_07_11
• Collection name: KU Fish Voucher
• User Name: spfishadmin

Reported By
Zoe Warner from CSIRO via Asana