Examples

AttributeStatus Examples

• Exclude attributes
• Record Count : Should be added all attributes in view to the condition row. Include count on the one of attribute and other all should be excluded. Using two server calls you can get record count without manually adding attributes and its not recommended.
• Maximum of the target column : Should be added all attributes in view to the condition row.
• In the same way above you can get average, minimum and sum.

ConditionOperator Examples

• Between
• GreaterThanOrEqual
• Like
• ValueIn : Returns founded rows matching with given values in the array.
• Soundex : Soundex converts an alpha string to a four-character code to find given similar-sounding words or names.
• In the same way above you can use Equal, NotEqual, LessThan, LessThanOrEqual, GreaterThan, NotLike, ValueNotIn, EqualIgnoreCase, NotEqualIgnoreCase, LikeIgnoreCase and NotLikeIgnoreCase.

ConditionCategory Examples

• And
• Or

PLSQL Examples

• Record Count : Using directly view without using attribute status count.
• Queries : Using SQL like and variables.
• Commands

Other Examples

• Limit maximum number of rows
• Activity Queries
• Activity Commands
• Handling values, Simpsons