archesproject / arches

Arches is a web platform for creating, managing, & visualizing geospatial data. Arches was inspired by the needs of the Cultural Heritage community, particularly the widespread need of organizations to build & manage cultural heritage inventories
GNU Affero General Public License v3.0
212 stars 142 forks source link

Primary descriptors should be persisted to the resource instances table #8301

Closed robgaston closed 2 years ago

robgaston commented 2 years ago

When working in PostgreSQL, there are many occasions when being able to access the primary descriptor values for a resource instance would be useful. Currently, these values are only stored in elasticsearch and are therefore difficult to access from other parts of the application. We should add columns to the resource instances table for these values and populate them when we generate and index them.

aarongundel commented 2 years ago

This implies a modification to the relational data model to expose this in the instances views.

robgaston commented 2 years ago

resolved in #8436