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
