Page Comparison

The Status field indicates the current status of your lookup tables and displays status text inside a colored background.

• Available means that the lookup is ready to use.

• Updating or Creating means that the lookup is being constructed or it is undergoing some changes and cannot be used just yet. Once a lookup is in this status, the Refresh option will appear in the ellipsis menu (see Lookup management options below).

• Deleting means that the lookup is being deleted and cannot be used anymore. Once a lookup is in this status, the Retry option will appear in the ellipsis menu (see Lookup management options below).

To check if there have been changes in the status of the whole lookup list, click the refresh icon at the top right.

Lookup errors

If there is any problem with a lookup, a notification icon appears next to the status. Click it to check the problem and a suggested solution, if available. There are some specific cases worth mentioning:

• Retrievable lookup: the error can be solved and the lookup retrieved for later use.

  • Automatically: the system will automatically perform the necessary actions to retrieve the lookup and change its status to Available.

  • Manually: you need to manually activate the lookup Refresh option to trigger the necessary actions to retrieve the lookup and chante its status to Available. You can either use the button in the error dialogue or use the option in the ellipsis menu (see Lookup management options below).

• Irretrievable lookup: the error cannot be solved by any means and the lookup will not be usable.

  • Error while Creating: the Refresh option will not be available and the lookup will remain on the list until manually removed with the Delete option, allowing you to keep it for reference.

The Name field displays the name assigned to the lookups when created.

The Owner field displays the email of the user who created the lookup.

The Last Updated field contains the date and time of the last of the changes applied to the lookups, changes such as modifications in content, sharing status, etc.

The Type field shows the following depending on the lookup type: Upload, Static Query, Historic Static Query, Dynamic Query, or Historic Dynamic Query.

The Size (bytes) field states the disk space the lookups occupy.

The Rows in Lookup field reports the number of rows the lookups consist of.

The Sharing field indicates the status of the lookups concerning privacy and displays a status icon and text inside a colored background.

• Private means that the lookup has not been shared yet and it is thus not visible to anyone but the creator of the lookup and a domain administrator.

• Shared means that the lookup has been already shared and it is thus visible to those users with the role it was shared with and usable according to the scope of interaction specified when shared.

To know more about sharing status and how to share lookups, check the Share lookups article.

The Lookup Summary can be reached by clicking the expandable icon on the left of the lookup row to see its details: key field, field names, and data types, as well as source query for query lookups, which can be copied to the clipboard for later use.