Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-11154

Retain unique-key metadata for tabular queries, and permit full-detail queries on selected row(s)

    XMLWordPrintable

Details

    • Improvement
    • Status: To Do
    • Resolution: Unresolved
    • None
    • Firefly, SUIT
    • None

    Description

      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!

      Attachments

        Issue Links

          Activity

            No builds found.
            gpdf Gregory Dubois-Felsmann created issue -
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Field Original Value New Value
            Epic Link DM-10570 [ 32500 ]

            This comment is just to get the words:
            property sheet
            and
            inspector
            into this ticket.

            gpdf Gregory Dubois-Felsmann added a comment - This comment is just to get the words: property sheet and inspector into this ticket.

            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.

            gpdf Gregory Dubois-Felsmann added a comment - 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.
            xiuqin Xiuqin Wu [X] (Inactive) made changes -
            Link This issue relates to DM-14573 [ DM-14573 ]
            tjenness Tim Jenness made changes -
            Remote Link This issue links to "Page (Confluence)" [ 32715 ]

            Shadowed by:

            • 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)
            gpdf Gregory Dubois-Felsmann added a comment - Shadowed by: 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)

            People

              Unassigned Unassigned
              gpdf Gregory Dubois-Felsmann
              Fritz Mueller, Gregory Dubois-Felsmann, Trey Roby, Xiuqin Wu [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Jenkins

                  No builds found.