| Patent application number | Description | Published |
| 20100161644 | Contextual Display of Saved Search Queries - A computer-implemented method for contextually displaying saved search queries is disclosed. The method comprises: displaying a user interface comprising a layout, the layout being associated with one or more tables in a database; receiving from the user interface a request for stored search queries; upon receiving the request, identifying a plurality of stored search queries, each of the plurality of stored search query being associated with one or more tables in the database; and displaying a stored search query from the plurality of stored search queries if the one or more tables associated with the stored search query and the one or more tables associated with the layout include at least one table in common. | 06-24-2010 |
| 20100217779 | USING A CALCULATION EXPRESSION TO DEFINE AND CONTROL ACCESS RIGHTS FOR RECORDS IN A DATABASE - Techniques for providing limited access to data stored in records of databases are disclosed. The techniques can be implemented in a database program operating on a computer system. The database program can provide a Graphical User Interface that can be used to conveniently define calculation expressions that limit operations on the records of the database. The calculation expression can be defined for a user or group of users with respect to a particular operation that can be requested to be performed on the records of the database. The calculation expression can be defined based on fields of the records, as well as other information, for example, various state variables of the database (e.g., date, time, number of records, etc.) The calculation expression can, in turn, be evaluated with respect to each record to determine whether a request to perform an operation on that particular record should be granted or denied. | 08-26-2010 |
| 20110040745 | QUICK FIND FOR DATA FIELDS - Methods, program products, and systems for automatically searching data in multiple data fields are described. A user can view data retrieved from a database and formatted based on a layout. While viewing the data, the user can perform a search using one or more search terms. A system can automatically examine the database and identify on which tables and on which data fields of the tables to perform the search. The system can identify searchable tables and data fields by analyzing the database schema as well as characteristics of the tables and data fields. | 02-17-2011 |
| 20110040747 | REFERENCE FILE FOR FORMATTED VIEWS - Methods, program products, and systems for displaying data in formatted views using reference files are described. In some implementations, a database application program can generate a result set using one or more queries. The result set can contain actual data from a database and metadata. The metadata can contain references to data records in the database, the references can include identifiers that can identify the data records. When a user saves a database report file, the user can save at least a part of the result set using the identifiers instead of the queries and layouts. Thus, the result set can be saved as a reference file. When the database application program opens the saved reference file, the database application program can reproduce the result set using the stored references without running all of the queries. | 02-17-2011 |