Select Queue Subscribers and Their Rules

Figure 10-13 Use Case Diagram: Select Queue Subscribers and their Rules

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Administrative Interface -- Views"

Name of View:

AQ$<queue_table_name>_R

Purpose:

This view displays only the rule based subscribers for all queues in a given queue table including the text of the rule defined by each subscriber. This is a view of subscribers with rules defined on any queues of a given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_r. It is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables.

Table 10-13 AQ$<queue_table_name>_R

Column Name & Description	Null?	Type
QUEUE - name of Queue for which subscriber is defined	NOT NULL	VARCHAR2(30)
NAME - name of Agent		VARCHAR2(30)
ADDRESS - address of Agent		VARCHAR2(1024)
PROTOCOL - protocol of Agent		NUMBER
RULE - text of defined rule		VARCHAR2(30)