Manage Automatic Lookups

Use the Manage Automatic Lookups task (ab-auto-lookups-manage.axvw) to control the Numeric ID feature.

With this task, you can:

  • activate and deactivate the Numeric ID feature
  • automatically configure the Translatable Primary Keys feature
  • filter the afm_flds by table name, field name, attributes, primary keys, translatable primary keys, default standard tables.
  • edit or clear afm_flds.attributes for any field.
  • clea r afm_flds.attributes for all non-translatable primary key fields.
  • add or clear afm_flds.attributes for all filtered fields.

In SaaS deployments, access this task at: System / SaaS Partner Administrator / Manage Automatic Lookups. Sign in as a user such as AFM-BP who has the 4 - PARTNER ADMINISTRATOR (ACP) role.

In the non-SaaS, this task is available from System / Add-In Manager / Manage Automatic Lookups

Note: The Manage Automatic Lookups view does not reload cached schema. You must restart the application server after adding lookup properties to additional fields.

manage_task.png

The Field List has a permanent restriction to show only lookup fields:

afm_tbls: Is SQL View? = No, Domain Name <> Schema, Table Type IN (Project Data, Project Application Data).
afm_tbls: Only tables that are referenced (afm_flds.ref_table) by at least one other table.
afm_flds: Data Type IN (Char, Varchar), Archibus Type IN (None, Desc)

Enable/Disable Numeric IDs

Toggle the Numeric ID feature on and off with this button. This action sets the application parameter to 0 or 1 and executes the WFR to reload all application parameters. If the parameter does not exist, the action creates it.

Enable Translated Primary Keys

Use this button to configure the Translatable Primary Key solution with a single action. Selecting this button performs three functions:

  • Add lookup attribute with displayType="translate" to all translatable primary keys where afm_flds.attributes is empty.
  • Clear afm_flds.attributes (if contains "lookup") for all fields that are not translatable primary keys in the default standard tables.
  • Enable Numeric IDs if not already enabled.

For the first two functions above, the program lists the affected fields and asks for confirmation prior to making any changes.

Edit Field Attributes

Select a field from the field list on the left, and the right pane displays its attributes for review or editing the Field Attributes field.

The form contains an instruction bar showing a sample of Numeric ID syntax. This is useful for instant reference, as well as for copying and pasting; right click on the text to access the Copy command.

Two action buttons are available from the field list:

  • Add Lookup Field Attributes: Inserts the default lookup XML in afm_flds.attributes for all fields in the grid where afm_flds.attributes is empty.
  • Clear Lookup Field Attributes: Clears afm_flds.attributes for all fields in the grid where afm_flds.attributes contains "lookup".