SYSTEM AND METHOD FOR FILTERING DATABASE RESULTS USING DYNAMIC COMPOSITE QUERIES
First Claim
1. A method for retrieving data records to a client computer, the method comprising:
- receiving an identifier of a base query from the client computer, the base query configured to select a set of data records from a database that the client computer has permission to access;
receiving a modifying clause from the client computer, the modifying clause comprising a directive restricting the set of data records to a subset of data records;
generating a combined query from the base query and the modifying clause, the query configured to return the subset of data records; and
executing the combined query at the database.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, system and computer program product for retrieving data records to a client computer. An identifier of a base query is received from the client computer. The base query is configured to select a set of data records from a database that the client computer has permission to access. A modifying clause is also received from the client computer. The modifying clause comprises a directive restricting the set of data records to a subset of data records. The modifying clause may optionally comprise an expression for sorting. A combined query is generated from the base query and the modifying clause. The query is configured to return the subset of data records. The combined query is further configured to sort the subset of data records based on the value of the expression if the expression is present. The combined query is executed at the database.
51 Citations
20 Claims
-
1. A method for retrieving data records to a client computer, the method comprising:
-
receiving an identifier of a base query from the client computer, the base query configured to select a set of data records from a database that the client computer has permission to access; receiving a modifying clause from the client computer, the modifying clause comprising a directive restricting the set of data records to a subset of data records; generating a combined query from the base query and the modifying clause, the query configured to return the subset of data records; and executing the combined query at the database. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A system for retrieving data records to a client computer, the system comprising:
-
a server, the server comprising; a receiving unit configured to receive an identifier of a base query from the client computer, the base query configured to select a set of data records from a database that the client computer has permission to access, and to receive a modifying clause from the client computer, the modifying clause comprising a directive restricting the set of data records to a subset of data records; and a generating unit configured to generate a combined query from the base query and the modifying clause, the query configured to return the subset of data records; and a database, the database configured to execute the combined query. - View Dependent Claims (9, 10, 11, 12)
-
-
13. A computer program product embodied in computer readable memory comprising:
-
computer readable program codes coupled to the computer readable memory for retrieving data records to a client computer, the computer readable program codes configured to cause the program to; receive an identifier of a base query from the client computer, the base query configured to select a set of data records from a database that the client computer has permission to access; receive a modifying clause from the client computer, the modifying clause comprising a directive restricting the set of data records to a subset of data records; generate a combined query from the base query and the modifying clause, the query configured to return the subset of data records; and execute the combined query at the database. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20)
-
Specification