Invention Grant
- Patent Title: Utilizing database tables for dashboard management
-
Application No.: US15671795Application Date: 2017-08-08
-
Publication No.: US10762098B2Publication Date: 2020-09-01
- Inventor: Michael Bender , Rhonda L. Childress , Donald L. Muchmore
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent James Nock
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F16/248 ; G06F3/0482 ; G06F7/08 ; G06F16/22 ; G06F16/2455 ; G06F16/245

Abstract:
A method and system is provided to populate a customized pull down menu with table driven sort options in a graphical user interface for displaying a data report. A computer builds a table of sortable fields for a dashboard report, and displays in the dashboard report filters in the table that apply to the sortable fields. The computer receives from the user a selection of at least one sortable field from the sortable fields from a pull down menu, and at least one flag is set for inclusion in the dashboard report, wherein the at least one set flag define a sort order for an element of the data report. A generated SQL statement is modified to sort the element according to the at least one set flag. The element is sorted according to the modified SQL statement.
Public/Granted literature
- US20190050462A1 UTILIZING DATABASE TABLES FOR DASHBOARD MANAGEMENT Public/Granted day:2019-02-14
Information query