How to swap lines for Titles on an On Call Schedule Webxchange

This tutorial will show you how to swap out the lines in a On-Call Schedule from a SQL query.

1.  First,  Open up Webxchange and log in.

Search for the On Call Schedule that you would like to make a change

2.    In this example, I am going to swap out Echo 

3.    Open up Sql management studio by typing SSMS in the run command on a server that has SQL installed.

Run the following Select Statement: select * from Titles where profileID = ' ocgastro'

Insert the ProfileID for the schedule (this is just an example)

In this example, I need to swap out ECHO Fellow (Sat/Sun/Hldys. 24 hrs) with ECHO Fellow - M-F 5p 7a except Holidays

Next, we need to run the following update statement

Update titles set XnPosition = '21' where RecNo = '3551' and profileID = '    OCCARD'
Update titles set XnPosition = '20' where RecNo = '3552' and profileID = '    OCCARD'

Your On Call Schedule should now look like this.  

Lightning uses the XNposition to link the file into Webxchange