Default Queries

You can set up queries to display data when you access a specific screen and view. For more information about queries, see Information Query.

If you set up default queries for multiple views that are based on the same business object (for example, the Contact business object), then the default query for the first view that you access runs to display data in the view. However, when you access another one of the views, the data that appears is determined by the default query for the first view, and not the default query for the new view. The default query for the new view does not run to display data because the query context for the first view is retained when you navigate from the first view to any of the other views.

Note: Only views that you can access from the drop-down list for the visibility filter or from the Site Map can have an associated default query.

To set up a default query

  1. From the application-level menu, choose Tools, then User Preferences.

    The User Preferences screen appears.

  2. Navigate to the Default Queries view.

    This view contains two applets:

    • Screen. This applet lists the screens and contains one field: Screen Name.

    • Screen View. This applet lists the screen views and contains two fields: View Name and Default Query.

    The Screen View list changes according to the screen you select in the Screen applet.

  3. In the Screen applet, select a screen name.

    For example, if you select the Contacts screen, then all contact screen views appear in the Screen View applet.

  4. In the Screen View applet, select a view.

  5. Click the Default Query field for the view you selected, and then click the select button.

    The Pick Query dialog box appears.

  6. From the Pick Query dialog box, select the query you want the view to show, and then click OK.

    The selected query appears next to the appropriate view in the Default Query column.