Query Trees

Browse PeopleSoft Query Access Trees with record hierarchies and the permission lists that grant access.
Categories:
Tags:
Tailored Operational Context
  • Target Database: —
  • Context Type: —
  • Alert Severity: —
  • Triggered Time: —
  • Firing Context: —

What It Is

Query Access Trees are the security backbone of PeopleSoft Query — hierarchical groupings of records (PSTREEDEFN / PSTREENODE) that determine which records a Query author can build queries against. A permission list grants access to one or more access groups within a tree, and the Query Manager UI only lists records that fall under the granted nodes. psLens shows the tree’s full record hierarchy and the permission lists that authorize it, combining what you’d otherwise need to assemble from Tree Manager and Permission List security separately.

Search Page

URL: /querytrees?db={database}

Query Tree search results showing EOQF_QUERY_TREE, PACKAGING, PTPN_VIEWALL and others

Query Tree search results

Search auto-matches as starts with. Typing EOQF finds every tree whose name begins with EOQF. Include % yourself for ends-with or contains patterns, or use % alone to list every query tree in the database.

Detail Page

URL: /querytrees/{TREE_NAME}?db={database}

Detail page for EOQF_QUERY_TREE

Query Tree detail page for EOQF_QUERY_TREE

The main pane shows Tree Properties (status, version, audit metadata) and the full Tree Hierarchy, a recursive view of every node in the tree with the record name it grants access to. The sidebar has one related-data toggle.

Query Tree detail page with all panels expanded

Full Query Tree page with the Permission Lists panel expanded

Tree Hierarchy

Tree Hierarchy panel

The full record hierarchy of the tree, with each record linked to its detail page

The recursive node-by-node breakdown of the tree. Each record link jumps into the record’s detail page so you can see what data the tree grants query access to.

Permission Lists

Permission Lists panel for the query tree

Permission lists with access to nodes in this tree

Permission lists that have been granted access to nodes in this tree. Pair with each permission list’s role membership in the Security pages to get the user-level answer for which users can build queries against these records.

What This Consolidates

In PIA / Tree Manager:

  • Open PeopleTools → Tree Manager and navigate to the tree
  • Click through the tree nodes one branch at a time to see records
  • Open the Query Profile for each permission list separately to see which trees and nodes it authorizes
  • Cross-reference manually to answer “who has Query access to record X”

psLens shows the record hierarchy and the permission lists granting access on one page — the source data for any PS/Query security audit. Pairs with the Queries page’s tree placement panel for the inverse question.