Matching Values dialog

Discoverer displays this dialog when you are defining an indexed item for an item in a folder, and Discoverer has determined that the list of values (LOV) associated with the indexed item in the current folder is created on another item (that is, either in the current folder, or in another folder).

Use this dialog to confirm that the list of values (LOV) associated with the indexed item in the current folder exactly matches another LOV in another folder.

For more information, see "How to assign an indexed item to an item".

OK

Use this button if you are sure that the values of the items referred to in this dialog, exactly match each other.

Note: If you use the OK button but the values of the items displayed in the Matching Values dialog do not exactly match each other, results returned when parameters are used in conditions might be incorrect.

Notes

  • A LOV (item class) contains values that are generated from a single item but which can be applied to multiple items in multiple folders (for more information, see "What are item classes?"). When Discoverer determines that the LOV (item class) to be used by the indexed item can be based on another item, Discoverer asks you to confirm that the values in the item class exactly match the unique values in the indexed item.

  • The items whose values you are matching must be of the same datatype. For example, you cannot match a date LOV (that is, a Date datatype) with a city name LOV (that is, a Varchar datatype), or a Days of the Week LOV (that is, a varchar datatype) with a date LOV (that is, a Date datatype).