Status: To Do
Fix Version/s: None
I would like the Firefly tabular-query-result support to include the following capability, if it doesn't already:
If the query result contains a column or columns that constitute a unique key, based on metadata returned from the underlying database service, flag those columns as such.
Then, for a selected row (or rows), provide convenient UI support for, effectively, performing a "SELECT *" against the underlying table(s) from the original query to retrieve the full width of the available data for the selected row(s). The results would appear as a new query result tab.
This enables a workflow for any tabular query result (as long as unique-key information was retained in the original query) where a user can perform a limited-column query, browse the data, find something interesting, and then request all available details on that item.
There are complications when the tabular data results from a join, contains grouping, aggregation, etc., so in the real world this may not be trivial. It may require support from DAX that is not already planned.
This is an improvement ticket; as usual it requires T/CAM approval to schedule any work to meet it!
It would be desirable for the UI to permit such a "property sheet" to be obtained by UI action on any of the visible representations of the table row: on the row itself in the table viewer, on a marker for the row in an image overlay, or a symbol for the row in an x-y plot.
- FIREFLY-600 (provide metadata allowing identification of the primary key)
- FIREFLY-601 (provide UI support for "get the full row" actions against a table row)
This comment is just to get the words:
into this ticket.