Creating Virtual Field in ARCHIBUS

Create Virtual Field in ARCHIBUS

Virtual fields are fields that do not represent data but, rather, represent some manipulation of the data made by the SQL engine.

In DataSource:

<field table="wr" name="em_name" dataType="text">
<title>Tenant Name</title>
<sql dialect="generic">(select name_last${sql.concat}', '${sql.concat}name_first from em where   em.em_id = wr.em_id)</sql>
</field>

In Panel:

<field table="wr" name="em_name" dataType="text"/>

Export Option For Display Tag

If You want to open Excel file in another window, You just have to do following changes in display.properties file

export.excel.filename=fileNamet.xls

You can do this for all options

OR

insert this line inside tag