akvo / akvo-lumen

Make sense of your data
https://akvo.org/akvo-lumen
GNU Affero General Public License v3.0
63 stars 18 forks source link

Add data-groups aggregation maps support #3091

Closed tangrammer closed 3 years ago

tangrammer commented 3 years ago

Context

external map service recibes a plain SQL with table and columns related in the visualisation, then this map service uses same lumen db to read the data to be visualised

Problem or idea

with data-groups we don't have one table but several ones for each dataset-version(-2)

Solution or next step

We aggreed on using postgres views to be used from the external map service. these views need to not be temporary (as current ones used in lumen aggregations)

tangrammer commented 3 years ago

@kardan @iperdomo should we persist the view name together in dataset_version_2 table? (so we need to create a new column there)

janagombitova commented 3 years ago

@tangrammer and @kardan I am closing this issue as I believe it is handled already. It there is still work to do, please reopen and comment