Manage Automatic Lookups

 With the System Administration / ARCHIBUS System Administration / Add-In Manager / Manage Automatic Lookups (ab-auto-lookups-manage.axvw) task you can:

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:

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:

Copyright © 1984-2019, ARCHIBUS, Inc. All rights reserved.