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"/>