With the System Administration / ARCHIBUS System Administration / Add-In Manager / Manage Automatic Lookups (ab-auto-lookups-manage.axvw) task you can:
afm_flds.attributes
for any field.r afm_flds.attributes
for all non-translatable primary key fields.afm_flds.attributes
for all filtered fields.
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)
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.
Use this button to configure the Translatable Primary Key solution with a single action. Selecting this button performs three functions:
displayType="translate"
to all translatable primary keys where afm_flds.attributes is empty.afm_flds.attributes
(if contains "lookup") for all fields that are not translatable primary keys in the default standard tables.For the first two functions above, the program lists the affected fields and asks for confirmation prior to making any changes.
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:
afm_flds.attributes
for all fields in the grid where afm_flds.attributes is empty.afm_flds.attributes
for all fields in the grid where afm_flds.attributes contains "lookup".
Copyright © 1984-2019, ARCHIBUS, Inc. All rights reserved. |