humlab-sead / sead_change_control

Sane SEAD change control using Sqitch.
1 stars 0 forks source link

20200120_DML_ADD_DOMAIN_FACETS: Add facet parent/child relationship #48

Closed roger-mahler closed 4 years ago

roger-mahler commented 4 years ago

This is part of https://github.com/humlab-sead/sead_query_api/issues/58.

Add new domain facets

In total seven new facets are added to the system having filters on methods as specified in the above issue.

facet_code child facets criteria
archaeobotany Abundances, Author, Bibligraphy modern, Country, Eco code, Eco code system, Family, Feature type, Genus, Geochronology, Sample group, Seasons, Site, Taxa, Time periods method_id in (4, 8)
ceramic Bibligraphy modern, Country, Feature type, Geochronology, Sample group, Site, Time periods master_set_id in (select master_set_id from public.tbl_dataset_masters where master_name = 'The Laboratory for Ceramic Research (Lund/KFL)')
dendrochronology Author, Bibligraphy modern, Country, Family, Feature type, Genus, Geochronology, Sample group, Site, Taxa, Time periods method_id in (10)
geoarchaeology Bibligraphy modern, Country, Feature type, Geochronology, MS Heating 550, Sample group, Site, Time periods method_id in (32, 33, 35, 36, 37, 94, 106)
palaeoentomology Abundances, Author, Bibligraphy modern, Country, Eco code, Eco code system, Family, Feature type, Genus, Geochronology, Sample group, Seasons, Site, Taxa, Time periods method_id in (3, 6)
pollen Abundances, Author, Bibligraphy modern, Country, Eco code, Eco code system, Family, Feature type, Genus, Geochronology, Sample group, Seasons, Site, Taxa, Time periods method_id in (14, 15, 21)

Adds a new table facet.facet_children and populates it with new domain facets for:

roger-mahler commented 4 years ago

Note that new facets as specified in https://github.com/humlab-sead/sead_query_api/issues/58 is is not handled in this issue.

roger-mahler commented 4 years ago

Moved to @2020-02 since its part of new domain facet feature.