Provides a String comprised of all the field's search expressions. Each field's search expression is obtained based on its AllowSearch, UseInSearch and SearchMode properties. See GetWhereExpression method of the BaseField class for more information on how each field's search expression is created. Each field's search expression is separated by either AND or an OR clause depending the MoreResults property on this business object. If MoreResults is set to true then OR is used otherwise AND is used, this however can be overridden at each field level as well by setting the Field's SearchCondition property. The Recursive property on this objects and on the joined objects determine if the joined objects will also try to create their own search expressions from their joined objects to be include in this expression. This process will follow until the depth reaches maxLevel parameter value.

Parameters:

Description
includeTableName	If true then each field name will be have its table name prefixed. This is important and useful when creating where expression from multiple tables and more than one table may contain the same column name.
level	Current level in recursion.
maxLevels	Maximum levels of business objects to cover during recursion.
objectsCovered	A collection that can be used to track what business objects are already covered.
sqlParams	All the parameters created by this method will be added into this ArrayList.

Returns:

Type
System.String

 

Provides a String comprised of all the field's search expressions. Each field's search expression is obtained based on its AllowSearch, UseInSearch and SearchMode properties. See GetWhereExpression method of the BaseField class for more information on how each field's search expression is created. Each field's search expression is separated by either AND or an OR clause depending the MoreResults property on this business object. If MoreResults is set to true then OR is used otherwise AND is used, this however can be overridden at each field level as well by setting the Field's SearchCondition property. The Recursive property on this objects and on the joined objects determine if the joined objects will also try to create their own search expressions from their joined objects to be include in this expression. This process will follow until the depth reaches maxLevel parameter value.

Parameters:

Description
includeTableName	If true then each field name will be have its table name prefixed. This is important and useful when creating where expression from multiple tables and more than one table may contain the same column name.
recur	Recursion type that will determine what kind of joined objects will be covered. If Recursion is set to RecursionTypes.Parent then only the Join objects with relationship type of Parent will be covered and hence same process for Child relationship.
level	Current level in recursion.
maxLevels	Maximum levels of business objects to cover during recursion.
objectsCovered	A collection that can be used to track what business objects are already covered.
sqlParams	All the parameters created by this method will be added into this ArrayList.

Returns:

Type
System.String

 

Provides a String comprised of all the field's search expressions. Each field's search expression is obtained based on its AllowSearch, UseInSearch and SearchMode properties. See GetWhereExpression method of the BaseField class for more information on how each field's search expression is created. Each field's search expression is separated by either AND or an OR clause depending the MoreResults property on this business object. If MoreResults is set to true then OR is used otherwise AND is used, this however can be overridden at each field level as well by setting the Field's SearchCondition property. The Recursive property on this objects and on the joined objects determine if the joined objects will also try to create their own search expressions from their joined objects to be include in this expression. This process will follow until the depth reaches maxLevel parameter value.

Parameters:

Description
includeTableName	If true then each field name will be have its table name prefixed. This is important and useful when creating where expression from multiple tables and more than one table may contain the same column name.
recur	Recursion type that will determine what kind of joined objects will be covered. If Recursion is set to RecursionTypes.Parent then only the Join objects with relationship type of Parent will be covered and hence same process for Child relationship.
level	Current level in recursion.
maxLevels	Maximum levels of business objects to cover during recursion.
objectsCovered	A collection that can be used to track what business objects are already covered.
sqlParams	All the parameters created by this method will be added into this ArrayList.
isHavingClause	Value is used to determin if the clause being constructed is HAVING clause or WHERE clause. If the passed in value is true, then only the fields that have an aggregate function set will be included.

Returns:

Type
System.String