US 11,709,842 B2
System and method for implementing a reporting engine framework
Sreedhar Raichur, Uravakonda (IN); Zubair Ali Baig, Chennai (IN); Rudresh Kumar, Bengaluru (IN); Ullas Poojary, Mysore (IN); Deepanker Sachdeva, Abohar (IN); Saheera Eranhikkal, Malapurram Dt (IN); Yuvaraj Loganathan, Bengaluru (IN); and Kartheek Gopal, Bengaluru (IN)
Assigned to JPMORGAN CHASE BANK, N.A., New York, NY (US)
Filed by JPMorgan Chase Bank, N.A., New York, NY (US)
Filed on Jul. 13, 2022, as Appl. No. 17/812,245.
Application 17/812,245 is a continuation of application No. 16/927,498, filed on Jul. 13, 2020, granted, now 11,416,493.
Claims priority of provisional application 62/873,540, filed on Jul. 12, 2019.
Prior Publication US 2022/0350806 A1, Nov. 3, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/2455 (2019.01); G06F 16/22 (2019.01); G06F 9/54 (2006.01); G06F 16/242 (2019.01); G06F 16/248 (2019.01)
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
OG exemplary drawing
 
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.