waltz
waltz copied to clipboard
Report Grid: replace entity_field_reference column with the qualifier columns
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_id
s 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
This should only be attempted after #6188 has been merged
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.
Thoughts @JWoodland-Scott ?