Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To be able to view and use lookup operations when working in the search window, you need to have at least view permissions on Lookups the View version of the Lookups permissions for upload lookups or the Query lookups permission for query lookups. Take into account that these

These two permissions are hierarchy-based, meaning you need to have Lookups assigned in order to be able to have Query lookups.

...

Notice at least the View version of the Finders permission is required to enable the Lookup permission (know more about permissions here).

Additionally, if you’re not the owner of the lookup, you need to receive at least View access to the lookup in question via sharing, otherwise, you will not be able to see it or use it. Check Share lookups to know more.

...

Using lookup operations in the search window 

...

Rw ui tabs macro
Rw tab
titleIn the search window

The process is essentially the same as the standard one explained above except for the operation selected, which must be Whole entry of…

Image RemovedImage Added
Rw tab
titleUsing LINQ

You can also add lookup rows as JSON objects by using the corresponding LINQ syntax in the query.

To do it, you can either use the Free Text Query to open the search from the beginning or open the Query code editor if you have it already open. This is the syntax you need to use:

select `lu/lookupName`(tableField) as newfieldName

Info

Syntax special considerations

  • tableField → this must be the field in your data table that corresponds to the lookup key field, otherwise there will be no match to correlate your data and you will get null for all events.

You can then split the resulting JSON objects into their different key/value pairs and transform them into different data types using the operations in the JSON group.