Skip to main content Link Search Menu Expand Document (external link)

Lookup Functions - entitylookup

Table of contents
  1. entitylookup


  • {col1, col2} = entitylookup(field, entityName)

The entity information lists can be found in

If the field value matches the entityinfo lookup, return the specified columns. Empty table assignment is not supported for this function.


let EventID = f("@fields.EventID") 
aggregate count() by EventID
let {Description}= entitylookup(EventID, "AD_EventID")

In this example, “AD_EventID” is the entity name and “EventID” is the field.