Queries

Queries are used with the Search Framework to extract data from the database for component and global searches. Queries must be assigned to an access group and a related security tree.

Query Tree Definition

The security information for the Receivables tree definition is:

Query Tree Name	Access Group	Permission List
SEARCH_TREE_AR	AR_ACCESS_GROUP	EPAR9500

Types of Queries

These types of queries are used for the PeopleSoft Search Framework:

• Primary Query

• Connected Query

• Related Query

• Delete Query

For additional information about queries as they relate to the PeopleSoft Search Framework, see PeopleTools: PeopleSoft Search Technology.

Predefined queries for PeopleSoft Receivables are:

Query Name	Description	Additional Information
AR_SRCH_ITEM	Item Search Main Query	This is a primary query and uses SEARCH_TREE_AR as its security tree.
AR_SRCH_ITEM_ACTIVITY	Item Activity search	This is a related query.
AR_SRCH_ITEM_DST	Item Distribution Search	This is a related query.
AR_SRCH_ITEM_ATTACH	Item Attachments Search	This is a related query.
AR_SRCH_ITEM_DELETE	Remove archived Item Details from Index	This is a delete query.
AR_SRCH_PAYMENT	AR Payment Search Main Query	This is a primary query and uses SEARCH_TREE_AR as its security tree.
AR_SRCH_PMT_ENTRY	AR Payment Entry Search	This is a primary query and uses SEARCH_TREE_AR as its security tree.
AR_SRCH_PAYMENT_ID_CUST	Payment ID Cust Search	This is a related query.
AR_SRCH_PMT_ATTACH	Payment Attachments Search	This is a related query.
AR_SRCH_PAYMENT_DELETE	Remove deleted Payment Details from Index	This is a delete query.
AR_SRCH_ITEM_CQ	AR Item Connected Query	This is a connected query. Its parent query name is AR_SRCH_ITEM
AR_SRCH_PAYMENT_CQ	AR Payment Connected Query	This is a connected query. Its parent query name is AR_SRCH_PAYMENT
AR_SRCH_PMT_ENTRY_CQ	AR Payment Entry Connected Query	This is a connected query. Its parent query name is AR_SRCH_PMT_ENTRY