CPC G06F 16/24553 (2019.01) [G06F 9/54 (2013.01); G06F 16/2282 (2019.01); G06F 16/248 (2019.01); G06F 16/2423 (2019.01)] | 20 Claims |
1. A computer-implemented method for generating a database query, the method comprising the steps of:
receiving, via a user-interface, a user selection of one of a plurality of choices for a specific database view from an overall database view created by joining a plurality of tables in a database in a drop-down menu;
populating, in the user-interface, a plurality of fields representing columns associated with the user selected specific database view;
receiving, via the user-interface displayed to an end user, a selection of: (i) a report type comprising one of a database view or table, (ii) one of the columns from the plurality of fields that serves as a filter, (iii) at least one operator from a plurality of operators associated with the selected filter, and (iv) one or more unique values associated with the selected filter;
dynamically generating, via a computer processor, the database query based on the received selection, wherein: the plurality of filters are retrieved by a first application program interface (API) based on the selection of the database view or table, the plurality of operators are generated by a second API based on the selection of the filter, and the unique values are retrieved by a third API based on the selection of the filter;
applying the database query to one or more databases; and
generating, via the user-interface, an output responsive to the database query.
|