join view permit to show cartesian product of one or more table.
In order to use this view type, the setType property must be set to TYPE_JOIN (default).
setMaxRow(<value>)
Maximum number of rows the view must show. Default (0) – All rows
setFrom(<value>)
Table list will be used for view. The syntax:
<Alias1>:<Type1>@<Name1>; ... ;<AliasN>:<TypeN>@<NameN>
Where <Alias> is the logical name to use for: <Type>@<Name>,
Where <Type> is the type (table or view) of <Name>. <Type> values can be:
"table" or "view"
Where <Name> is the table name or view name. <Name> syntax must be <PackageName>.<ObjectName>.
setRelations(<value>)
Define table relation or view relation. Syntax is:
<TypeRel1>:<AliasRel1_1>.<ColRel1_1>=<AliasRel1_2>.<ColRel1_2>
&& ... &&
<AliasRel1_N>.<ColRel1_N>=<AliasRel1_M>.<ColRel1_M>
; ... ;
<TypeRelK>:<AliasRelK_1>.<ColRelK_1>=<AliasRelK_2>.<ColRelK_2>
&& ... &&
<AliasRelK_N>.<ColRelK_N>=<AliasRelK_M>.<ColRelK_M>
Where <TypeRel> is the relation type between table or view. <TypeRel> values are:
> = left join
< = right join
- = inner join
<AliasRel> is the alias set for the table or view.
<ColRel> is a name of a column <AliasRel>.
setColumns(<value>)
Define view columns. Syntax:
<AliasCol1>:<Expression1> ; ... ; <AliasColN>:<ExpressionN>
Where <AliasCol> is the column logical name we want to set.
<Expression> is column value.
In order to set into <Expression> the name of a table or view field, it is required to use <AliasToV>.<Column>.
The <AliasToV> name is the one defined into setFrom property.
In case we want all column of a specific table/View, the syntax to use can be: <AliasToV>.@All
or just "@All" if we want all columns of table/view defined into setFrom. When you use @All the <AliasCol> must be not set, and column alis will be their name
setCondition(<value>)
It define a filter condition for view.
<value> parameter is an expression return a boolean value.
setOrder(<value>)
Define view order. Syntax
<AliasCol1>:<TypeOrder1>; ... ;<AliasColN>:<TypeOrderN>
Where <AliasCol> is a column name defined into setColumns,
<TypeOrder> indicate if order of <AliasCol1> must be "asc" or "desc"
setGroup(<value>)
Define the columns to group.Syntax:
<AliasCol1>; ... ;<AliasColN>
Where <AliasCol> is a column name define into setColumns property
When we set this property, into setColumns definition, we must use grouping feature for all column not into group. Syntax for a column will be:
... ;<AliasColY>:<Function>(<ExpressionY>); ...
Feature are:
count = perform a row count
sum = sum
min = take minimum value
max = take maximum value
setGroupCondition(<value>)
Define a filter after grouping data. It is valid just if setGroup is used.
Last updatedTuesday, 23 November 2010 17:14
