How to Edit a List in StaffMap:
- Open the Sidebar Menu and select the list you would like to edit.
- Select the Edit button from the top toolbar.
- In the resulting List Properties panel, edit the Name, Icon or SQL.
- Select the Save button to confirm your changes.
The SQL field will accept any standard SQL queries, including sorting and joins. Use the following notation to select database elements:
For example, the following query will display employees who have been assigned to desks.
[_Employees].[LastName], [_Employees].[FirstName], [_Desks].[deskname], [_Floors].[FloorName] FROM
You can learn more about SQL queries at w3schools.com.
Note - Lists are currently limited to displaying employee data only.