search

dlaumer / bioindication

Apache License 2.0
0 stars 0 forks source link

DATA: Clean up the date field #19

Closed dlaumer closed 6 months ago

dlaumer commented 8 months ago

The first_date field in the data layer is not always filled. We need to find a solution to complete this, maybe using the system attribute CreationDate. Question is to make it manual or automatic?

dlaumer commented 6 months ago

Solution: Calculate a new field finalDate like this: COALESCE("first_date", "last_date", "CreationDate")

Use the webapp to always check if there is a new entry and fill this field

dlaumer commented 6 months ago

Done, but realized it only works when logged in. And there is a lag. Maybe we need to find another solution