Bookshelf Home | Contents | Index | PDF |
Siebel Consumer Goods Handheld Guide > Data Filtering > Constructing Business Component and Business Object FiltersBusiness 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 on QBE syntax, see Siebel Developer's Reference. Business object filters are used to supply filters that a user can select at sync 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 normal search spec and sort spec syntax applies except that quotes in the search spec have to be escaped using double quotes since the search spec itself is enclosed in double quotes. The syntax is as follows. Descriptions of the terms are shown in Table 15. 'Account'.Search = "[State] = LookupValue ( ""STATE_ABBREV"", ""CA"" )" 'Account'.Sort = "Name, Location"
For more information on PDQ syntax, see Siebel Developer's Reference. |
Siebel Consumer Goods Handheld Guide |