...
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
What permissions do I need?
To be able to view and use lookup operations when working in the search window, you need to have at least the View version of the Lookups permissions for upload lookups or the Query lookups permission for query lookups. Having the User resources permission is equivalent to having the Manage version of these two permissions.
...
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. Check Share lookups to know more.
...
Using lookup operations in the search window
You can run a search and correlate its content with values from a lookup table. If any value in the key field of the lookup table is also present in your query, the corresponding values of the selected lookup field will be added to a new field.
...
Rw ui steps macro | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Go to Data search and open a data table (in this case
Click Create field in the query toolbar and give it a meaningful name. You will create two new fields: IP_Street_Address and IP_Brand.
Select the operation of the field you want to add based on the IP_List lookup (in these cases StreetAddress and Brand).
Click Create field and the new two fields will be added at the end of the table. |
Using lookup operations in LINQ
You can also add lookup values by using the corresponding LINQ syntax to correlate query content with values from a lookup table. If any value in the key field of the lookup table is also present in your query, the corresponding values of the specified lookup field will be added to a new field.
...
Note |
---|
Lookups in Activeboards and APIs The syntax to use lookup operations in Activeboards and APIs is different. Visit the following articles to know more: LINQ syntax differences: Activeboards vs search window, LINQ syntax differences: Devo APIs vs search window. |
Lookup operations result
When using a lookup operation, both the key field specified in the lookup when created and the field specified as an argument in the operation are searched for matching values. When they are found, the corresponding value of the lookup field selected as the operation will be added to the new field.
In the example above, both fields are created with the lookup values, showing the street and printer brand corresponding to the IPs of the clientIpAddress field that are also in the key field of the lookup table. These fields will show null for those IPs that are not included in the lookup table.
Add all the values in a row
When a match is found between the content of your query and a value in your lookup key field, you can select the Whole entry of... operation to add all the values in that lookup row as a JSON object in a new field.
...