Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Consumer Goods Handheld Guide > Data Filtering for Siebel Handheld Applications > Constructing Business Component and Business Object Filters for Siebel Handheld ApplicationsBusiness 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 normal search specification and sort specification syntax applies except that quotes in the search specification have to be escaped using double quotes because the search specification itself is enclosed in double quotes. 'Account'.Search = "[State] = LookupValue ( ""STATE_ABBREV"", ""CA"" )" 'Account'.Sort = "Name, Location" Descriptions of the terms are shown in Table 15. For more information about PDQ syntax, see Siebel Developer's Reference. |
![]() ![]() |
Siebel Consumer Goods Handheld Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |