Using Compound Expressions and Substitutions in a Search Specification

You can use compound expressions and substitutions in a search expression. For example, consider the following generic format:

"([Field1] > '" + [&Process Property Name] + "') OR ([Field2] IS NULL) OR ([Field3] 
IS NULL)" 

Siebel CRM translates this format to the following value:

([Field1] > 'value') OR ([Field2] IS NULL) OR ([Field3] IS NULL) 

An expression can include a literal representation of a business component field. For example:


"([Open] > '" + [&dFromDate] + "') OR ([Open] IS NULL)"
"([Open] > '" + [&dFromDate] + "') AND ([Status] IS NULL)" 

where dFromDate is a custom process property

For more information about using a process property as a substitution variable, see Referencing a Process Property.