RB_QUERY_VW (SQL View)	Index Back
RB_QUERY_VW View used for the Configurable Query Search Page. Joe Edgar - 03/23/04: Changed the SQL from "COUNT(B.KEYWORDS)" to "COUNT(DISTINCT B.KEYWORDS)". This was coming up in our audits.

RB_QUERY_VW

(SQL View)

RB_QUERY_VW

View used for the Configurable Query Search Page. Joe Edgar - 03/23/04: Changed the SQL from "COUNT(B.KEYWORDS)" to "COUNT(DISTINCT B.KEYWORDS)". This was coming up in our audits.

SELECT A.QUERY_ID , A.QUERY_NAME , COUNT(DISTINCT B.KEYWORDS) , A.ACTIVE_FLAG FROM PS_RB_QUERY A , PS_RB_KEYWORD B WHERE A.QUERY_ID=B.QUERY_ID GROUP BY A.QUERY_ID, A.QUERY_NAME,A.ACTIVE_FLAG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 QUERY_ID Character(10) VARCHAR2(10) NOT NULL Query ID

2 QUERY_NAME Character(30) VARCHAR2(30) NOT NULL Query Name

3 KEYWORD_COUNT Number(3,0) SMALLINT NOT NULL Number of Keywords defined for a Query. Used in Configurable Query Search from RB_QUERY_VW

4 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	QUERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Query ID
2	QUERY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name
3	KEYWORD_COUNT	Number(3,0)	SMALLINT NOT NULL	Number of Keywords defined for a Query. Used in Configurable Query Search from RB_QUERY_VW
4	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive