Siebel Service Handheld Guide for Windows-Powered Devices > Data Filtering > Query by Example Filters >

Filtering Out List of Values

You can use QBE filters to filter out values that are not used in picklists in your handheld application. For example, there may be account types, such as Distributor and Competitor, that are only used by users in the Web Client application and are not used by sales representatives out in the field. By including only those values that are used by the sales representative, you simplify the application for the user and improve the application performance.

The following is an example of a QBE filter that filters List of Values (LOV):

DefaultBusObjs7=List of Values|5|List of Values|
([Type]="PROD_REL_TYPE") OR ([Type]="FS_ORDER_TYPE_CODE")

The QBE allows only LOV values for two types: PROD_REL_TYPE and FS_ORDER_TYPE_CODE to be downloaded.

QBEs can be used to reduce the amount of background data that is downloaded to the device. For example, there is a large number of products. However, for the field technician using the Service Handheld application, only a very limited number of products are relevant. Therefore, we specify a QBE that downloads only those products typically used by a field technician—that is, products that are orderable and replaceable in the field or products that have the Position Bill Product Flag set to billable. An example would be a billable service that the field technician renders for the customer.

DefaultSyncFilter4=Internal Product|([Field Replaceable Unit]="Y" OR [Position Bill Product Flag]="Y") AND ([Orderable]="Y")


 Siebel Service Handheld Guide for Windows-Powered Devices 
 Published: 18 July 2003