Project

General

Profile

Actions

Feature #19628

open

metadata concept: schema to display properties as tabular data

Added by Peter Amstutz almost 2 years ago. Updated 8 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Workbench2
Target version:
Story points:
-
Release:
Release relationship:
Auto

Description

I've been mulling over how best to have tabular metadata attached to collections using properties.

Assumptions / requirements / constraints

  • A single collection contains multiple items (e.g. samples) to be described, each of those items has several fields/columns of data.
  • data items are smallish, like filenames, identifiers from other systems, controlled vocabulary, dates, etc.
  • data items are in the hundreds-to-thousands range
  • our current generic indexing strategy on properties allows us to do exact search in multi-valued properties using "contains", however we can't do more complex filtering on multi-valued properties

Design

  • In collection properties:
    • Meaningful "columns" field which has the list of other properties to display, in what order
    • each property listed in "columns" appears in properties with an array value. the array values should be the same length. same index in the array matches the same row across all the lists (this is a columnar data model)
  • if workbench sees the "columns" field, it renders a table with properties listed in columns as a table column
    • client side sorting/filtering of table contents
    • can edit table contents but implemented as updating the entire set of properties at once
  • server side ability to search for particular key-values across collections by e.g. ["properties.sample_id", "contains", "sample-123"]
Actions #1

Updated by Peter Amstutz almost 2 years ago

  • Description updated (diff)
  • Subject changed from metadata concept: schema to display properties as columnar data to metadata concept: schema to display properties as tabular data
Actions #2

Updated by Sarah Zaranek almost 2 years ago

Brad wants to simply just be able to display a single key with an array of values.

Actions #3

Updated by Peter Amstutz over 1 year ago

  • Release set to 60
Actions #4

Updated by Peter Amstutz 8 months ago

  • Target version set to Future
Actions

Also available in: Atom PDF