Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Work Items : qaccess

qaccess
The qaccess table stores details of any non-default sort, filter and display criteria used by iProcess users to access their iProcess queues.
Structure
The qaccess table has the following structure:
TABLE qaccess (
user_name
VARCHAR(64) NOT NULL,
access_type VARCHAR(8) NOT NULL,
queue_name VARCHAR(51) NOT NULL,
access_str VARCHAR(1024) NULL)
SORT  defines how work items in the specified queue are sorted.
FILTER  defines how work items in the specified queue are filtered.
DISPLAY  defines how work items in the specified queue are displayed.
QVERS  defines when the queue was last accessed. For internal use only.
Note: Test queues have the suffix /t.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
None.
Table Activity
The qaccess table contains one row per set of non-default access criteria defined per user per queue.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved