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.
3. In the resulting List Properties panel, edit the Name, Icon or SQL.
4. 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.