Skip to main content
Version: 5.1

Lookup Manager

info

Lookup (lookup) - lookup is a static data table used to enrich or transform data during a search.

The Lookup Manager module is responsible for creating, viewing, editing, and deleting lookups, as well as managing the values contained within them. It provides centralized management of reference data used in the system.

Configuration Structure

NameField in the indexSyntaxDescriptionData example
Lookup namename<string>Lookup namelookup_name
Index nameidx<string>Index name corresponding to the lookupindex_name
Fieldsfields<array>List of lookup fields used for enrichmentfield1, field2
Number of rows to displaysize<int>Number of rows to display lookup data1000
Case sensitivitycase_sensitive<array>List of fields that are case-sensitive when matchingfield1, field2
Wildcardwildcards<array>List of fields to match by rule Wildcardfield1, field2
Cidrmatchcidrmatch<array>List of fields to match by rulefield1, field2
Conditioncondition<string>Filter condition applied before matching lookup recordsstatus != "Dismissed"
Limitlimit<int>Limitation on the size of lookup data before matching1000
Maximum number of matchesmax_match<int>Maximum number of matches from the lookup for a single search result when executing a command lookup100

Interaction

The reference guide provides an advanced set of data manipulation features:

  • selecting individual cells or ranges by dragging the cursor while holding the left mouse button
  • copying selected elements to the clipboard and pasting content into the table
  • clearing values in selected cells
  • undoing operations using hotkeys

Pasting from Clipboard

To paste data from the clipboard, follow these steps:

  1. Copy the desired range in TSV format using Ctrl + C / Cmd + C
  2. Select one or more target cells in the table where you want to paste the data
  3. Press Ctrl + V / Cmd + V

The data will be automatically inserted into the selected area. If needed, the table will expand (adding new rows), while column names remain unique.

Справочник с выделенной областью

info

Selected cells are visually highlighted when working with the table.

How Pasting Works

Anchor-Based Pasting

Used when the selected area in the table is smaller than the clipboard data.

  • pasting starts from the "anchor" cell (the top-left cell of the selected area) and continues rightward and downward
  • if the clipboard runs out of data, values repeat cyclically

Range-Based Pasting

Used when the selection area matches the clipboard data size.

  • each value from the clipboard is placed into the corresponding cell in the same relative position

Keyboard shortcuts

OperationKeyboard shortcutsDescription
WindowsMac
Select AllCtrl + ACmd + ASelects all column headers and data cells
CopyingCtrl + CCmd + CCopies selected cells (including headers) in TSV format
InsertCtrl + VCmd + VPastes clipboard contents into the current selection range
ClearingDeleteClears the contents of selected cells
Undo actionCtrl + ZCmd + ZUndoes the last change
Redo actionCtrl + YCmd + Shift + ZRepeats the last undone action