Enable Automatic Lookups
In Archibus you can have a lookup field show instead of the primary key for the table when you are referencing standard table. For example if you always want to show the building name or department name instead of the code fields by default. You can only have one lookup field per table.
Standard configuring without lookup enabled:
There are three options for lookup fields:
- Standard lookup (replaces field with lookup field
<root><lookup/></root>
- Both (shows both the primary key field and the lookup fields separately)
<root><lookup displayType=”both”/></root>
- Concatenate (show both the primary key field and the lookup fields in the same table – you can select the order by changing the display format)
<root><lookup displayType=”concatenate” displayFormat=”{0} – {1}”/></root>
How to Enable
- In the field dictionary, set the field attributes for the field you want to be the lookup value (usually description) with the following:
<root><lookup/></root>
- Go to “Manage Automatic Lookups” and select the “Enable Automatic Lookups” button. Restart Tomcat.
Override Automatic Lookups
If you need to override the automatic lookups in a particular report you need to add lookupDisplayType to the axvw.
You can also override the field heading by setting a title in the axvw:
Possible Errors in Custom SQL Reports
Most errors when enabling this come from custom axvw reports that use SQL. You may need to update some queries so that the joins use the lookup fields:
Was this helpful?
0 / 0