Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql_54d_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/html/wp-includes/wp-db.php on line 2056

Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql_54d_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/html/wp-includes/wp-db.php on line 2056
Enable Automatic Lookups | RSC Knowledge Base
Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql_54d_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /var/www/html/wp-includes/wp-db.php on line 2056

Enable Automatic Lookups

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.

More information

Standard configuring without lookup enabled:

Graphical user interface, text, application, table

Description automatically generated

There are three options for lookup fields:

  1. Standard lookup (replaces field with lookup field

<root><lookup/></root>

Graphical user interface, text, application

Description automatically generated

  1. Both (shows both the primary key field and the lookup fields separately)

<root><lookup displayType=”both”/></root>

Graphical user interface, text, application

Description automatically generated

  1. 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>

Graphical user interface, text, application, email

Description automatically generated

How to Enable

  1. 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>

Graphical user interface, application

Description automatically generated

  1. Go to “Manage Automatic Lookups” and select the “Enable Automatic Lookups” button. Restart Tomcat.

Graphical user interface, application

Description automatically generated

Override Automatic Lookups

If you need to override the automatic lookups in a particular report you need to add lookupDisplayType to the axvw.

Graphical user interface

Description automatically generated with medium confidence

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:

Table

Description automatically generated

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *