The "merge view" are based on Union on table or on view and return result into one recordset
In order to use Merge view, the setType property must be set to TYPE_MERGE.

setMaxRow(<value>)
Maximum number of rows the view must show. Default (0) – All rows

setFrom(<value>)
Set of table to merge. Same syntax of Join View

setRelations(<value>)
Set the relation between tables or Views. Syntax:

<type1>; ... ;<typeN>

<type> is union type. Possible values:

UNION = take the row one times, so do not duplicate row if equals.
UNIONALL = take in consideration also duplicate row

setColumns(<value>)
Define the column. In this kind of view, a column must be present in all the table/View defined into setFrom . Syntax is as Join View

setCondition(<value>)
It define a filter condition for view.
<value> parameter is an expression return a boolean value. Syntax as Join View

setOrder(<value>)

Define view order. Syntax as Join View

Last updatedMonday, 29 November 2010 00:15