In the ARS we need to be able to search through assets, and receive a list based on the search query.
It should be possible to filter and search on all fields of the metadata. We also need to be able to use operators like: AND / OR / Equal / Range.
Something like: (Code example, not actual implementation)
"Select * where collection.type = 'pinned_insects' and (Institution.name = 'NHMD' or Institution.name = 'AU') and specimen.barcode in range(10002344, 10002389)"
(^this in not actual sql.)
The range operator can be used for dates and numbers.
Grand666
commented
3 months ago
In the ARS we need to be able to search through assets, and receive a list based on the search query.
It should be possible to filter and search on all fields of the metadata. We also need to be able to use operators like: AND / OR / Equal / Range.
Something like: (Code example, not actual implementation)
"Select * where collection.type = 'pinned_insects' and (Institution.name = 'NHMD' or Institution.name = 'AU') and specimen.barcode in range(10002344, 10002389)"
(^this in not actual sql.)
The range operator can be used for dates and numbers.