Removing service requests is not recommended unless it causing a system error.
Before manually removing requests, which requires assistance from your IT department, please use the Fix Requests page to remove requests that are causing issues. Fix Requests can be accessed through the Tools menu.
If using Fix Requests does not resolve the issue, requests must be manually removed from the database using the process below.
- Using SQL Management Studio, connect to the LobbyCentral database
- Execute the following query to obtain a list of Location IDs:
SELECT locationID, locationName FROM tblLocation
- Using the correct locationID, execute the following query:
DELETE FROM tblRequest_Queue WHERE locationID = [your_location_id] AND convert(char, dateIn, 101) = 'mm/dd/yyyy' AND status = [target_status]
WHERE: your_location_id = locationID from step 2 dateIn = the date to remove. Must be in mm/dd/yyyy format status = 0 for Waiting/Pending or 1 for In-Service
EXAMPLE - Removes In-Service requests for location 1 that were created on 8/30/16: DELETE FROM tblRequest_Queue WHERE convert(char, dateIn, 101) = '08/30/2016' AND status = 1 AND locationID=1