Example Syntax of Business Object Filter

Business object filters use the following predefined query (PDQ) syntax:

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

where:

• Account is the business component name.

• Search is the key word.

• "[State] = LookupValue ( ""STATE_ABBREV"", ""CA"" )" is the search specification where:

  • State is the field name.

  • LookupValue is the function for find and the LOV value.

  • STATE_ABBREV is the LOV type.

  • CA is the LOV value.

• 'Account'.Sort = "Name, Location" is the sort specification for sorting the returned list.

  Note: The normal syntax applies for search and sort specifications. However, quotes must be escaped using double quotes in the search specification because the search specification itself is enclosed in double quotes.

PDQ syntax rules are as 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.

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