SiebelGuide.com/siebelblogs

Predefined Query, also called as PDQs in Siebel are very handy for end users. The end users often execute the same query multiple times or also the requirement could be such that as soon as the person navigates a particular view a default set of records should be displayed. Instead of redoing the query again and again we setup PDQs for this.

With PDQs in Siebel, the queries are stored and can be seen in the drop down list on the upper right hand side of the Siebel screen. When a particular query needs to executed, just select that particular query from the drop down.

There are two types of PDQs. Private and Non-Private. Private means that the query is only available for those people who created the query or for those who saved the query. This is normally done by end users and is available only to them. The second method below describes how to create this type of PDQ.

Non-Private PDQ means that the PDQ is available to all the users using the Siebel Application. This is normally created by either Developers or by Siebel Administrators using the first method described below.

There are two ways you can create a PDQ.

1. Method 1: Go to SiteMap-> Administration-Application->Predefined Queries. (This view is normally accessible only to those having Siebel Administrator responsibilities.) Here you will see several Predefined Queries that already exist. You should also observe that PDQs are Business Object Specific. Meaning if you specify the query with Business Object Account, then this PDQ will be displayed under all views where the Business Object is Account.To define a new PDQ click New and start entering the required information. First the Business Object, then whether this query is Private or non-Private, Name and then Actual Query to be executed. The Name you give takes an important role. It decides which query to execute by default when the user navigates to a particular view. The Name is sorted and the first one on the top is the query that will be executed by default. So give the name appropriately. Sometimes developers start the name with asterisk or with a number so that it arrives on the top when sorted and is executed by default.
2. Method 2: The second way of creating a PDQ is by saving the query that is executed using the Application Menu. To create this, first execute the query on the application you would like to save and then from the application menu on upper left hand side choose Query -> Save Query As. Give an appropriate name to the query. Once this is done you should be able to see the saved queries from the Saved Queries dropdown. Again the Name takes precedence on which query to execute by default. Also this query will be saved as private and available only to the person who saved it.

Hope this helps. Leave a comment.

Related posts(Auto Generated):

1. eScripting Best Practices - Part3
2. eScript Best Practices - Part7
3. Siebel FAQs.
4. Adding index to Siebel Table – Made Simple
5. How to Test Siebel Workflows?