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.
Maximum number of rows the view must show. Default (0) – All rows
Set of table to merge. Same syntax of Join View
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
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
It define a filter condition for view.
<value> parameter is an expression return a boolean value. Syntax as Join View
Define view order. Syntax as Join View
Last updatedMonday, 29 November 2010 00:15