Siebel Service Handheld Guide > Data Filtering for Siebel Handheld Applications >

Constructing Business Component and Business Object Filters for Siebel Handheld Applications

Business component filters are used to limit the extraction of a business component for every context in which it is extracted.

Example of Business Component Filter Syntax:

Business component filters use query by example (QBE) syntax.

[Status] = "Not Started" OR [Status] = "In Progress" OR ([Status] IS NULL) OR [Status] = "On Hold" OR ([Status] = "Done" AND [Done] >= Today() - 7)

For more information about QBE syntax, see Siebel Developer's Reference.

Business object filters are used to supply filters that a user can select at synchronization time. These are the filters that are displayed in the SetFilters dialog on the device.

Example of Business Object Filter Syntax:

Business object filters use predefined query (PDQ) syntax.

PDQ syntax rules are a follows:

  • The business component name must be a valid business component in the business object on which the PDQ is based
  • Search and Sort can be specified for all active buscomps in the business object on which the view is based, appended to each other in any order using space as delimiter.

The normal search specification and sort specification syntax applies except that quotes in the search specification have to be escaped using double quotes since the search specification itself is enclosed in double quotes.

The syntax is as follows:

'Account'.Search = "[State] = LookupValue ( ""STATE_ABBREV"", ""CA"" )" 'Account'.Sort = "Name, Location"

Descriptions of the terms are shown in Table 17.

Table 17. Business Object Filter Syntax
Syntax Term


Business component name.


Key word.

"[State] = LookupValue (""STATE_ABBREV"", ""CA"")"

Search specifications using PDQ syntax.


Field name.


Function for find and LOV value.


LOV type.


LOV value.

'Account'.Sort = "Name, Location"

Sort specification for sorting the returned list.

For more information about PDQ syntax, see Siebel Developer's Reference.

Siebel Service Handheld Guide Copyright © 2007, Oracle. All rights reserved.