Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.

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