LINQ syntax differences between Activeboards and the search window
- Anthony Shevlin (Deactivated)
- Sarah Bigault (Deactivated)
Note that the LINQ syntax for lookups is not the same in Activeboards and in the search window. Therefore, keep in mind that copying a LINQ query from the search window and pasting it into an Activeboard to use it as its data source will not work. Check the format differences below:
Lookups
This is the LINQ syntax you must use to apply a lookup operation in the search window:
select `lu/lookupName/lookupColumn`(field) as newColumnName |
|---|
And this is the syntax that you must use in Activeboards:
select lu("domainName", "lookupName", "lookupColumn", field) as newColumnName |
|---|
Tip
You don't need to transform your search window queries if you use the My Last Search Queries and My Favorite Search Queries boxes in the Data option of the Activeboards area. When they contain lookups or collections, these queries will be automatically transformed into the required format, and will be added as aggregation tasks with the required LINQ syntax.
