Server side filtering and sorting with field level security
First Claim
1. A computer-implemented method for securely filtering data in a project management system, comprising:
- preparing a filter based on a pre-defined selection criterion for project associated data;
retrieving the selected data from a project database;
determining a restriction status of the selected data based on an assigned access attribute;
sorting the retrieved data based on the selection criterion and the restriction status; and
providing the sorted data to a client application.
2 Assignments
0 Petitions
Accused Products
Abstract
A project management system is enabled to implement filtering, sorting, and field level security for data associated with managed projects. A filter for field selection is prepared by a project client application and forwarded to a project server. The server generates an access attribute table based the user permissions that may be set for each field within the managed projects. Upon retrieving the selected fields from project database, the project server builds a secured list of fields. A data set to be provided to the project client is prepared by removing the fields for which the user lacks the requisite access permission prior to sorting the data. The removed data may be used for user-transparent computations within the project server, but guarded from client applications.
-
Citations
20 Claims
-
1. A computer-implemented method for securely filtering data in a project management system, comprising:
-
preparing a filter based on a pre-defined selection criterion for project associated data;
retrieving the selected data from a project database;
determining a restriction status of the selected data based on an assigned access attribute;
sorting the retrieved data based on the selection criterion and the restriction status; and
providing the sorted data to a client application. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-readable medium having computer instructions for implementing server-side filtering, sorting, and field level security in a project management application, the instructions comprising:
-
determining a selection criterion based on a first rule for a field associated with a project;
determining an access attribute based on a second rule for a permission status of a user;
preparing a filter based on the selection criterion;
retrieving selected fields from a project database;
determining a restriction status of the selected fields based on the access attribute associated with each field;
sorting the retrieved fields based on the selection criterion, wherein a predetermined value is used for restricted fields;
post-processing the restricted, sorted data with at least one additional filter criterion; and
providing the post-processed data to a client application. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A system for server-side filtering and sorting project data in a secure manner, the system comprising:
-
a project database configured to store project data;
a project client configured to;
prepare a filter based on a sorting rule; and
a project server configured to;
receive the filter from the project client;
determine selection criteria based on the sorting rule;
determine access attributes based on a permission rule associated with a user;
retrieve a selected portion of the project data from the project database based on the selection criteria;
determine a restriction status of the retrieved portion of the project data;
sort the retrieved portion based on the selection criteria, wherein a null value is used for restricted data;
post-process the restricted, sorted data with further selection criteria; and
provide the post-processed data to the project client. - View Dependent Claims (18, 19, 20)
-
Specification