Filtering by descriptors
This ticket aims to extend the filtering capability of AccessionFilter
and InventoryFilter
.
- I would like to be able to filter
Accessions
by theirSourceDescObservations
- Similarly, I would like to filter
Inventories
byCropTraitObservations
- Finally, I would like to be able to find
Accessions
that have inventories (incl ** system inventory) that match a set ofCropTraitObservations
I figure we will have a JSON filter similar to:
{ "sourceObservations": [
{ "sourceDescriptorId": 123, "numericValue": NumberFilter },
{ "sourceDescriptorId": 331, "stringValue": StringFilter }
] }
type SourceDescValueFilter = {
sourceDescriptorId: number,
numericValue: NumberFilter,
stringValue: StringFilter,
}
The implementation should use a subquery as in where accession.accession_id in (select accession_id from ....)
instead of joins.