Persistent Variables
Persistent Variables
Introduction
- 0 - Introduction
Preparations
- 1 - Preparations
Setup
Usage
Properties & Methods
Scopes
Miscellaneous
Appendix A
- A.1 - Night Switch - Night Switch Manager
- A.2 - Night Switch enabled call routing script
Appendix B
- B.1 - Usage outside call routing - Simple ASP webpage
- B.2 - Usage outside call routing - Simple VBS/WSF script

Persistent Variables - 6.1 - Database field definitions

VBScript

This is how the PersistentVariables table with it's fields is defined:

PersistentVariables
---------------------------------------------------------------------------------
PersVarID        int                       unique id of variable
Name             nvarchar(50)              variable name
Value            nvarchar(1024) *          value of variable
Scope            int                       scope of variable ( SCOPE_SCRIPT 1, SCOPE_USER 2, SCOPE_GLOBAL 3, SCOPE_GROUP 4)
UserID           int *                     SwyxWare UserID of user who is allowed to access this variable (SCOPE_USER)
GroupID          int *                     SwyxWare GroupID of group which is allowed to access this variable (SCOPE_GROUP)
NameSpace        nvarchar(128) *           Namespace in which this variable is available (SCOPE_NAMESPACE)
Created          datetime *                Timestamp of when the variable was initially created in database
CreatedByName    nvarchar(80)*             Name of caller in call routing script in which the variable was initially created in database
CreatedByNumber  nvarchar(80)*             Number of caller in call routing script in which the variable was initially created in database
Modified         datetime *                Timestamp of when the variable was stored last time in database
ModifiedByName   nvarchar(80)*             Name of caller in call routing script in which the variable was stored last time in database
ModifiedByNumber nvarchar(80)*             Number of caller in call routing script in which the variable was stored last time in database

* = Allow Nulls