Develop > Tailoring > Data management > Stored queries > Using stored queries in display objects

Using stored queries in display objects

An administrator can use stored queries to retrieve and display dynamic data using menu buttons, charts, and marquees. Stored queries applied in this manner are not accessible to the user and operate in the background to retrieve records from the database.

For example, you could place a dynamic chart on a supervisor’s startup menu showing all open records by category. By placing buttons that run individual stored queries on the bottom of the chart, the supervisor could display lists of records by category.

Using menu buttons to run stored queries

Buttons that run stored queries from a menu must have a button ID defined in a menu record. Use the following values to run a stored query from a menu:

  • Application: query.stored
  • Parameter Name: text
  • Parameter Value: <stored query name>
  • Condition: true (or a condition statement that checks for a particular query group)

Using stored queries to produce charts and marquees

Stored queries produce dynamic information that the system gathers and displays in a bar chart. Agent records that reference each display object in Forms Designer define these queries.

A marquee runs one stored query at a time and cannot provide access to actual records. Queries run from marquees that display messages about records.