humlab-sead / sead_change_control

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

"Geochronology" och "Time periods" fungerar inte tillsammans #130

Closed Maanin00 closed 5 months ago

Maanin00 commented 1 year ago

Om man vill begränsa på tid genom att kombinera geochronology och time periods så går det inte. På bilden visas ett exempel med geochronology använts för att välja ut ett tidsintervall på ca 2600 år och då borde innehållet i efterföljande time periods filtrerats men istället visas "no data".

image

Det fungerar inte heller att göra det omvända, dvs ha time periods först och sen geochronology.

johanvonboer commented 1 year ago
"SqlQuery": "\n            SELECT category, count(value) AS count\n            FROM (\n                SELECT tbl_relative_ages.relative_age_id AS category, tbl_analysis_entities.analysis_entity_id AS value\n                FROM tbl_analysis_entities\n                      INNER JOIN tbl_geochronology ON tbl_geochronology.\"analysis_entity_id\" = tbl_analysis_entities.\"analysis_entity_id\" \t\t\t\t\t\n INNER JOIN tbl_datasets ON tbl_datasets.\"dataset_id\" = tbl_analysis_entities.\"dataset_id\" \t\t\t\t\t\n INNER JOIN tbl_physical_samples ON tbl_physical_samples.\"physical_sample_id\" = tbl_analysis_entities.\"physical_sample_id\" \t\t\t\t\t\n INNER JOIN tbl_relative_dates ON tbl_relative_dates.\"analysis_entity_id\" = tbl_analysis_entities.\"analysis_entity_id\" \t\t\t\t\t\n INNER JOIN tbl_relative_ages ON tbl_relative_ages.\"relative_age_id\" = tbl_relative_dates.\"relative_age_id\" \n                WHERE 1 = 1\n                AND  (tbl_geochronology.age >= 290 and tbl_geochronology.age <= 104916)\n                GROUP BY tbl_relative_ages.relative_age_id, tbl_analysis_entities.analysis_entity_id\n            ) AS x\n            GROUP BY category;\n        ",
johanvonboer commented 1 year ago

@roger-mahler suggests that we might have to limit the time periods filter to the paleaoentomoloy domain, because data only exists for bugs.

roger-mahler commented 5 months ago

Closing since the bug seems to be fixed after latest release.