Abstract:
A schema editor allows for definition, distribution, and use of schema templates. The schema editor allows schema to be edited and then saved in such a way that the saved file can be reimported into the schema editor.
Abstract:
A method and system for the graphical formulation of filter queries is disclosed which enables data queries to be easily chosen via selection from a menu. A signal is received to filter, or query, a data table. Next, the context of a selection of data is analyzed, and a menu of filters based on that context is formulated and displayed. A filter selection is received, and the corresponding filter is executed. The results of the filter are displayed on the screen.
Abstract:
Database interaction is facilitated by graphically presenting database objects in groups that are not necessarily dictated by object types of the database objects. In an example implementation, database navigation is facilitated by determining object dependency groups for a database in which each object dependency group corresponds to a database source object and includes at least those database objects that depend directly or indirectly from the corresponding database source object. When these data source object-based dependency groups are graphically displayed, selecting a database object thereof provides access thereto. In another example implementation, a user can designate an attribute associated with database objects by which the database objects are to be grouped. Thus, the database objects are grouped by various values that the user-designated associated attribute takes. These designated attribute-based value-driven groups may also be graphically displayed to enable navigation of and access to the different database objects assigned to them.
Abstract:
Methods, systems, and computer program products modify a table definition of a database table within a database application. A method involves providing a user interface for creating a new field in the database table, receiving data that creates the new field while displaying the database table, and modifying schema of the database table to include the new field and the data. The method also involves interpreting a data type of the data as the data is received. A data type interpreted for a column in the database table that contains the new field is the data type of the data received in the new field. Still further, the method involves handling objects dependent on the database table in a manner unbeknownst to a user of the database table. Thus, the schema is modified while the objects dependent on the database table remain visible or open to the user.
Abstract:
Methods, systems, and computer program products modify a table definition of a database table within a database application. A method involves providing a user interface for creating a new field in the database table, receiving data that creates the new field while displaying the database table, and modifying schema of the database table to include the new field and the data. The method also involves interpreting a data type of the data as the data is received. A data type interpreted for a column in the database table that contains the new field is the data type of the data received in the new field. Still further, the method involves handling objects dependent on the database table in a manner unbeknownst to a user of the database table. Thus, the schema is modified while the objects dependent on the database table remain visible or open to the user.
Abstract:
A browse mode designer allows an average user of a database application program to easily design reports. The user can use the browse mode designer to build meaningful reports that aggregate data and that combine related data into shaped patterns for easier consumption of information. The browse mode designer can interpret a user's actions and extrapolate what actions are to be performed. A user interface can be used to let the user change the resulting views while being designed.
Abstract:
A plurality of database application components available in a first components store is received. A plurality of pointers is created with each of the plurality of pointers referencing a selected object, such as the plurality of database application components or an existing pointer to one of the plurality of database application components. The plurality of pointers is collected into a reference group defining a plurality of selected objects included in a database application. In some examples, the database application components include a header, a footer, a control, a fragment, a table, a query, a report, a relation, a form, a conditional formatting statement, a programming component, a validation statement and a module.
Abstract:
A tool pane is included in a markup language document, such as a web page, that allows web page and web parts included in the web page to be modified. The tool pane allows a user to select among various modes for the tool pane including a gallery mode, a properties mode, and a customization mode. During the gallery mode the user may select from additional web parts to add to the page or remove web parts. The properties mode allows the user to adjust the properties of the web parts included in the page. The customization mode allows for customizing the tool pane itself to allow additional functions or restrict selected functions. A tool pane may be partially customized or fully customizes as selected by a user.
Abstract:
A plurality of database application components available in a first components store is received. A plurality of pointers is created with each of the plurality of pointers referencing a selected object, such as the plurality of database application components or an existing pointer to one of the plurality of database application components. The plurality of pointers is collected into a reference group defining a plurality of selected objects included in a database application. In some examples, the database application components include a header, a footer, a control, a fragment, a table, a query, a report, a relation, a form, a conditional formatting statement, a programming component, a validation statement and a module.
Abstract:
A method and system for the graphical specification and modification of reports is disclosed which enables data reports to be easily created via a report design dialogue. The report design dialogue includes a group-level outline panel containing controls for grouping, as well as other report controls such as those for sorting and aggregating. A method and system for creating a group-level outline panel using an existing database report is also disclosed. Finally, a computer-readable medium storing a computer-interpretable data structure that stores one or more report specifications is disclosed.