Request - search for ethanol-preserved parts in OGL:Genomic

[happiah-madson]

Help us understand your request (check below):

• search or data request (help with SQL or provide the specific fields you are trying to retrieve for your collection)
• add a new Github user to the Arctos Users team
• a new barcode series
• a new term for data entry or management
• a change or new report or label
• update to an Agent (split, merge, or other type of change)
• bulkload changes (to Agents, Identifiers, etc that are not already available as a bulkloading tool)
• new feature or otherwise a good idea to make Arctos even better
• quarantine taxon name and suggested replacement (please supply links)
• other

Describe what you're trying to do
I am looking to search for all records that have a part for which the preservation is ethanol (any percentage), isopropanol (any percentage), or dry. I'm looking for things that are stored at room temperature, but I'm not sure it's possible to discern this at the moment. The only way that I can figure out is that they should only have a PLPath that is just the container barcode, but I'm not sure it's possible to search on that.

For example, I would like this record (https://arctos.database.museum/guid/OGL:Genomic:29888) to show up in the search result b/c of it's one ethanol-preserved part that doesn't have a full PLPath.

@dustymc