Differences

This shows you the differences between two versions of the page.

--- sa32-00 [2014/07/31 15:57] – davidbell
+++ sa32-00 [2017/12/01 16:35] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 The follow is a guide to installing and configuring the IQXCallerNotification application to connect to the Synety VOIP system.
-) Add the following script to your IQX database:
+) Add the following scripts to your IQX database:
 <code SQL>
@@ Line 41: / Line 41: @@
 </code>
+<code SQL>
+CREATE FUNCTION "pears"."GetNotificationToken" (
+    in @StaffName char(25))
+returns char(120)
+begin
+    DECLARE @AccountID char(20);
+    DECLARE @NotificationToken char(20);
+    SELECT AccountID, NotificationToken INTO @AccountID, @NotificationToken
+    FROM StaffSynety
+    WHERE StaffID = (SELECT StaffID FROM staff WHERE userid = @StaffName);
+    IF @AccountID = Null THEN
+        RETURN null;
+    ELSE
+        RETURN string(@AccountID, '|', @NotificationToken);
+    ENDIF;
+end;
+</code>
 ) Add the following files to either your IQX main program folder or create your own folder and add the files to that.
@@ Line 67: / Line 87: @@
 === Error Reporting ===
-An errors that occur are written to the IQXCallerNotification.err file and it can be found in the same folder as the files above.
+Any error that occurs is written to the IQXCallerNotification.err file. This file can be found in the same folder as the files above.