Generic Inquiries Options (NX)

Description

The Generic Inquiries portion of the Options window allows us to modify those options that are specific to the Generic Inquiries we have referenced from within our workbook.

When we click the pencil icon next to our Generic Inquiry, Velixo NX will display the options associated with that specific Generic Inquiry:

Refresh mode

Allows us to control how much data is retrieved from the database. There are two options for Refresh: Smart Refresh and Full Refresh.

Key columns

Key Fields are those fields which uniquely identify each record in the Generic Inquiry.

We can click the pencil icon in the Key columns text box to display all available fields in the specific inquiry:

We can then use the arrow controls...

... to move fields between the Available columns list and the Key columns list.

An example of a unique field for a list of GL accounts would be the AccountCode. Another example for invoice document lines would be the combination of Document Type, Invoice Number, and Line Number.

Typically, a Description field or an Account Class would not suffice as a key field (since there are many duplicate values in tables that contain such fields). Doing so would result in an error message when using GI functions with that Generic Inquiry.

Also note that there is no universally applicable unique field, and a set of keys would typically differ across Generic Inquiries. For example, AccountCode can guarantee uniqueness in the chart of accounts, but would not suffice as a key in a list of GL transactions, where multiple lines can contain the same account.

When used with Full Refresh, Velixo Reports does not require the configuration of key fields for use with the GI function. Keys are necessary only if we want to use Smart Refresh and/or if we want to use the GILOOKUP function.