CATSWeb Session Parameters are variables that are related to the current user, their current activity, or the current state of the CATSWeb system. They may be returned for use as default values via Session Parameter data links, or passed to stored procedures and inserted into URLs in Stored Procedure and URL data links. Many of the available session parameters are listed below, along with examples of how to declare them in stored procedures designed to receive them. The URL Token for the parameter may be specified in URL parameter replacements in a similar manner as the {Field Value} or {Field Name} tokens.
CATSWeb passes parameters to stored procedures by order, not by name. That means you can declare the parameter with any name you wish. The data type should be set properly, however.
| Parameter |
Stored Procedure Declaration |
URL Token |
| Category Type (1=Noncon, 2=CA, 5=Subtask, 41=Subform) |
@catType smallint |
{CT} |
| Company Name |
@compName
nchar(30) |
{CN} |
| Database Login Name |
@dbLoginName
nchar(100) |
{CL} |
| Default Issue Category |
@issueCat
nchar(50) |
{CD} |
| Default Action Category |
@caCat
nchar(50) |
{CC} |
| Default Subtask Category |
@subCat
nchar(50) |
{CS} |
| Department |
@dept
nchar(30) |
{DP} |
| Department Name |
@deptName
nchar(30) |
{DN} |
| E-mail Address (primary) |
@email
nchar(100) |
{E1} |
| Employee ID |
@empID
nchar(30) |
{EI} |
| Employee Name |
@empName
nchar(50) |
{EN} |
| Employee Name and E-mail |
@empNameEmail
nchar(150) |
{EC} |
| Group |
@group
nchar(20) |
{GP} |
| GUID |
@guid
nchar(50) |
{GU} |
| Home Department |
@homeDept
nchar(30) |
{HD} |
| Personality |
@pers
nchar(50) |
{PY} |
| Session ID |
@sID
nchar(50) |
{SI} |
| Record Type (1=Noncon, 2=CA, 5=Subtask, 41=Subform) |
@recType smallint |
|
This stored procedure example demonstrates how to use session parameters:
----------------------------------------------------------
CREATE PROCEDURE sp_GetEmployeeIssues
@empName nchar(50),
@dept nchar(30)
AS
Select Category , IncidentID As 'Issue ID', EnteredBy
From Incident
Where EnteredBy=@empName AND Department=@dept
----------------------------------------------------------
|
