If you’re using Tree Selector tables for Department, Business Unit security, once you make changes to the Tree , the tree values in tree selector tables are deleted – while you can use nVision to populate the Tree Selector tables, PeopleSoft PS Query provides an easy a way to populate tree selector tables.
Provided below are the steps:
Step 1: Identify the tree whose tree selector table has to be refreshed
Step 2: Navigate to Main Menu > Reporting Tools > Query Manager > New Query
Step 3: Add a table of your choice to the PS Query
Step 4: Select any field from the table selected in Step 3
Step 5: Add a new criteria using the Criteria tab
Step 6: Choose a field as Expression 1 type and change the Condition Type to in tree. Also, click on the Tree Option radio button and click on the New Node List link
Step 7: Enter the tree identified as part of Step 1 and click on Search
Step 8: Click on the icon to the right of the root node
Step 9: Ensure that the selected note has been added to the Selected Nodes List group box
Step 10: Ensure that the selected nodes have been populated in the Criteria page
Step 11 : Click on OK and run the PS Query
Step 12: The Tree Selector tables will now be populated with requisite data
Hope this helps!
Have fun! 🙂