Skip to content

Add description to geo project in pephub database #125

@khoroshevskyi

Description

@khoroshevskyi

At this time we don't have description in any of the geo project in pephub. We should add it.
Geofetch will be adding it automatically. It should be fixed after this commit: pepkit/geofetch@54ad5d1

To add description to existing project use this sql command:

UPDATE projects SET project_value = jsonb_set(project_value, '{description}', (select (to_jsonb(((project_value->>'_config')::jsonb->>'experiment_metadata')::jsonb->>'series_title')))); 

To select just description use this command:

select ((project_value->>'_config')::jsonb->>'experiment_metadata')::jsonb->>'series_title' from projects limit 2;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions