Open the Interface Designer and select Report Builder from the list of templates.
In the Source Constant field, select the EMPLOYEE_ENTITYconstant.
Remove the column for id.
Add a column for the title field.
Set the display name for each of the columns as firstName, lastName, department and title, respectively.
Let's take a look at the expression to see how it relates to what we configured.
Notable implementation details
The grid generated by the report builder is already configured to page and sort. Batch size is also set to 20 when report data is not aggregated.
Nested fields cannot be added through the report builder, so they must be added after the expression is generated
For example, if department was nested in this CDT, my query column might look like this: a!queryColumn(field: "department.name")
When indexing nested CDT data, it's necessary to drill into the data sub element, or use an alias in the queryColumn. The index expression would like this to drill into the data sub element, index( local!datasubset.data.department, "name", null)