5 payload->>'description' as description,
6 jsonb_array_elements_text(payload->'files') as file
8 where object_type = 'Annotation'
13 payload->>'status' as status,
14 payload->>'file_type' as file_type,
15 payload->>'file_format' as file_format,
16 payload->>'output_type' as output_type,
17 payload->>'output_category' as category
19 where object_type = 'File'
21 select annotation, description, file.file, status, file_type, file_format, category
23 join file on annotation.file = file.file
24 where category != 'raw data'