Editing Lists

How to Edit a List in StaffMap:

1. Open the Sidebar Menu and select the list you would like to edit.
2. 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.

Report SQL

The SQL field will accept any standard SQL queries, including sorting and joins. Use the following notation to select database elements:

[_TableName].[FieldName]

For example, the following query will display employees who have been assigned to desks.

SELECT [_Employees].[LastName], [_Employees].[FirstName], [_Desks].[deskname], [_Floors].[FloorName] FROM [_Employees] INNER JOIN [_Desks] ON [_Employees].[Desk_id]=[_Desks].[desk_id]INNER JOIN [_Floors] ON [_Employees].[Floor_Id]=[_Floors].[floor_id]

You can learn more about SQL queries at w3schools.com.