Apple Inc.

Sun Microsystems, Inc.

Claris Corporation

Christopher L Crim

Stephen Iremonger

Clay Maeckel

Toufic Milan

David McKee

Oleg Zaydman

John Lorin Welshofer

Duc Vuong

Andrew Paulsen

Galt Johnson

Richard L Kalman

L Lee McIntyre

Ryan Christopher Griggs

Ashok Srinivasan

Andrew Phan

Joanna Holsztynska

Vladimir Brad

Jeff Leveille

Kenneth D Walter, Jr

Tom Lloyd

Shaun Patrick Flisakowski

Jhansi Reddy

Tak Tsubota

David Raffarin

Glenn A Brewer, Iii

Paul S Chen

Frank K Lu

Rick Kalman

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.

Contextual display of saved search queries

Methods, program products, and systems for displaying context-aware charts are described. In context-aware charts, content of a chart can reflect a context of the chart. A charting object can be defined using a data series. The system can dynamically determine what subset of a data source should be used for the data series, depending on where the chart object is placed in a layout, form or other display area. Therefore, a single chart definition can be used to display various charts based on the context of the chart. When a chart object is moved from one data area to a new data area, the system can change the source of the data series such that the data series of the chart corresponds to a different subset of the data source.

Context-aware charting

Methods, program products, and systems of maintaining data states upon forced exit are disclosed. In one aspect, an application program executing on the mobile device can maintain a connection to a remote data store and retrieve and cache data from the data store. When the mobile device receives an event that forces the application program to terminate, the mobile device can provide a time window in which the mobile device can perform various state preservation actions. During the time window, the mobile device can store data states, including states of the connection and states of the cached data. When the application program is re-launched, the mobile device can use the stored data states to restore a connection and a displayed view.

Maintaining data states upon forced exit

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.

Quick find for data fields

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.

Reference file for formatted views

A system displays content from a database in a formatted view. The formatted view includes one or more data fields arranged in one or more data sections. Each of the data sections includes a sub-summary display field. The system receives a request to modify data in one of the data fields. In response, the system reformats the formatted view. The reformatting includes moving the data field from a first data section to a second data section and updating the sub-summary display field in the first data section and the sub-summary display field in the second data section. The system displays the reformatted view.

Interactive sub-summaries in database applications

A graphical user interface in a database application includes a control for manipulating a result set of a query. The control is operable to display multiple graphical representations of a result ratio between a total number of rows in a database table returned in response to the query and a total number of rows of the database table. By interacting with the control, the user can switch (e.g., toggle) between graphical representations of the result ratio. The toggling can be achieved by automatically creating supplemental queries to the database. The graphical representations can be a pie chart, bar chart, eye chart or any other graphical representation that is suitable for displaying the result ratio.

Graphical result set representation and manipulation

Methods, program products, and systems of chunking data records are described. In general, in one aspect, a mobile device can provide for display on a display screen a scrollable window. The scrollable window can display first display content (e.g., a first segment of formatted data) stored in a first display buffer. The mobile device can determine that the scrollable window will cross a boundary of the first display buffer. Upon the determining, the mobile device can create second display content (e.g., a second segment of formatted data) in a second display buffer. The second display content can include display content that borders the first display content at the boundary. The mobile device can provide for display the second display content when the scrollable window crosses the boundary.

Chunking data records

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.

Using a calculation expression to define and control access rights for records in a database

The present invention provides methods and apparatus for presenting fields associated with a report format suitable for displaying data associated with a plurality of fields, the plurality of fields being associated with one or more records. A layout is obtained, the layout being a report format including the plurality of fields. A user selection is received. A first list of fields that are pertinent to the layout (e.g., including the plurality of fields) is presented when the user selection is in a first state. For instance, the first list of fields may include only the fields that are in the layout (e.g., visible to the user). When the user selection is in a second state, a user is presented or provided access to a second list of fields, where the second list of fields includes fields that are not in the layout. The second list of fields may also include the fields that are pertinent to the layout (e.g., those fields in the layout).

Process and system for providing a reduced set of fields associated with a report layout

A setup dialog for a web viewer dynamically changes to reflect parameters needed to generate a web address. The setup dialog can include a list box containing websites for which website templates are available for assisting the user in generating web addresses. The list box can also include an option to generate a custom web address without using a website template. An extensible grammar is provided for generating custom website templates.

Web viewer setup dialog and grammar for generating web addresses

Techniques for providing a 'cascade create' mechanism which allows data to be entered in related non-existing records in the database are disclosed. The techniques can be used to provide a database program that supports graphical, bi-directional data relationships, as well as multiple predicates. The 'cascade create' mechanism supports arbitrary data relationships, as well as complex data models that are not supported by conventional techniques. Furthermore, the &#x201c;cascade create&#x201d; mechanism frees the users and database programmers from having to write code or provide rules that are specific to a particular data model and/or specific data relationship.

Growing community of inventors

San Jose, CA, United States of America

Christopher L Crim