UNION views

UNION views

agileBase support the SQL ‘UNION ALL’ construct allowing you to combine the results of two views into one list.

http://www.postgresql.org/docs/current/static/queries-union.html

One example of this would be if you have a calendar view e.g. appointments for a user and you want to include events from a separate table such as holidays.

To set this up, go to the manage tab of a view and click ‘advanced options’. Then under ‘amalgamate with’, select a second view to join in data from. The other view must of course have the same number of fields, of the same data types, in the same order.