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