Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add to label report documentation: get verbatim agents for labels #288

Open
Jegelewicz opened this issue Jan 18, 2023 · 0 comments
Open
Labels
How To Update An existing How To needs to be updated

Comments

@Jegelewicz
Copy link
Member

left outer join (select collection_object_id,string_agg(attribute_value,'; ') as vacls from attributes 
			where attribute_type ='verbatim agent' and attribute_remark= 'collector' 
			group by collection_object_id) vac
			on coll_object.collection_object_id=vac.collection_object_id

That particular iteration works only if the documentation hasn't been followed, and joins to a bit of a weird table that most probably won't include.

ArctosDB/arctos#5449 (comment) is more portable

left outer join (
    select 
      collection_object_id,
      string_agg(attribute_value,'; ') as vacls 
    from 
      attributes 
    where 
      attribute_type ='verbatim agent' and 
      determination_method= 'collector' 
    group by 
      collection_object_id
  ) vac on flat.collection_object_id=vac.collection_object_id

Originally posted by @Jegelewicz in ArctosDB/arctos#5449 (comment)

@Jegelewicz Jegelewicz added the How To Update An existing How To needs to be updated label Jan 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
How To Update An existing How To needs to be updated
Projects
None yet
Development

No branches or pull requests

1 participant