waltz icon indicating copy to clipboard operation
waltz copied to clipboard

Report Grid: replace entity_field_reference column with the qualifier columns

Open davidwatkins73 opened this issue 2 years ago • 1 comments

Description

On the report_grid_column_definition table the existing entity_field_reference_id and the new qualifier columns (column_qualifier_kind and column_qualifier_id) can be consolidated.

The entity_field_reference_ids can be expressed as qualifier columns (with a kind of ENTITY_FIELD_REFERENCE).

Steps:

  • [ ] update col def table to copy the field ref id value into the qualifier (and add the kind)
  • [ ] Update the DAO code to retrieve cell data from their
  • [ ] Rework the col editor to understand the new representation of extension fields
  • [ ] Drop the column

Resourcing

We intend to implement this task

davidwatkins73 avatar Aug 15 '22 09:08 davidwatkins73

This should only be attempted after #6188 has been merged

davidwatkins73 avatar Aug 15 '22 09:08 davidwatkins73

Not 100% sure we should do this. Thinking of the scenario where we want to do something like:

  • Show grid cols for measurable category attestations.
    • One col is the time it was attested,
    • the other column would be who attested it.
  • We would need the field_ref to give that extra level of detail.

davidwatkins73 avatar Aug 17 '22 20:08 davidwatkins73

Thoughts @JWoodland-Scott ?

davidwatkins73 avatar Aug 22 '22 10:08 davidwatkins73