Invention Grant
- Patent Title: Dynamically building a database query by combining a static query clause with a user-specified filter
-
Application No.: US14171474Application Date: 2014-02-03
-
Publication No.: US10803054B2Publication Date: 2020-10-13
- Inventor: Pradip Kumar Pandey
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Vista IP Law Group, LLP
- Main IPC: G06F16/242
- IPC: G06F16/242

Abstract:
A method, system, and computer program product for dynamically building a database query by combining a static query clause with a user-specified filter. A method commences upon receiving a user-specified query filter from a user interface, then reformatting the user-specified query filter from a first query filter representation (e.g., clicks or text from the user interface) into a second query filter representation (e.g., into XML or into a database connectivity format, or into an SQL format, or into any native format). Subsequent steps combine the second query filter representation with a predefined database query (e.g., from an enterprise application) to form a dynamically-generated database language query. The filter is specified at a user interface, and the predefined database query is specified by an application.
Public/Granted literature
- US20150220656A1 DYNAMICALLY BUILDING A DATABASE QUERY BY COMBINING A STATIC QUERY CLAUSE WITH A USER-SPECIFIED FILTER Public/Granted day:2015-08-06
Information query