How do you add a record to a query tree in peoplesoft

How do I add a record to query manager?

  1. Navigation. From the BFS Home Page, click the ‘Reporting Tools’ tile.
  2. Create New Query. From the Reporting Tools page, click the Query folder to access the Query Manager. …
  3. Search Record. Records Page. …
  4. Add Record. In the Search Results section, click on ‘Add Record’ to add the record to your query. …
  5. Choose Fields.

How do I add a record in PeopleSoft?

To create a new record definition:
  1. Select File, New.
  2. Select Record.
  3. Click OK. The object workspace appears so that you can build a list of fields in a record definition.
  4. Select the Record Type tab to define the type of record definition. SQL Table.

How do I add a field to a PeopleSoft query?

Expression
  1. Select Reporting Tools, Query, Query Manager.
  2. Create a new query or search for an existing one.
  3. Access the Criteria page, and click the Add Criteria button. …
  4. In the Edit Criteria Properties page, specify the criteria for the field, and click the OK button to return to the Fields or Criteria page.

How do I add a subquery in PeopleSoft?

Select Reporting Tools > Query > Query Manager. Click the Use As Criteria icon on the Query page, or click the Add Criteria button on the Criteria page. On the Edit Criteria Properties page, select Subquery as the comparison value. PeopleSoft Query displays a special Query Manager view where you can select a record.

What is record in PeopleSoft?

A record in PeopleSoft refers to the collection of fields similar to that of a table in RDMBS. Records are of 7 types, out of which the last two are also database objects. Each of these types have a particular use in PeopleSoft – say, an SQL Table is used when a permanent storage of data in the database is required.

How do I add a prompt table in PeopleSoft?

What is Page in PeopleSoft?

Pages are the graphical interface between your users and your application database. … Using PeopleSoft Application Designer, you can create, modify, and delete page definitions in your PeopleSoft system.

What is query view in PeopleSoft?

Query Viewer is a PeopleSoft end user reporting tool. With Query Viewer you can access preexisting queries or requests for information created by other users. A user who creates queries may place the results in a public file that can be viewed by other users.
Access the properties dialog box for the new edit box. Select the Use tab. Select Related Field. Select the appropriate control field from the Related Control Field drop-down list box.

How do you create a field in PeopleSoft?

To create a new field definition:
  1. Click the New button on the PeopleSoft Application Designer toolbar. The New dialog box appears.
  2. Select Field.
  3. Click OK. A new character field opens in the definition workspace area.
  4. Select one of the following field types from the Field Type drop-down list box. Note.

What is event mapping in PeopleSoft?

The Event Mapping button is a visual indicator of custom PeopleCode programs mapped to events of a component, page, component record, or component record field.

How do you find the components of a page in PeopleSoft?

Depending on the PeopleSoft application that you are using, you can access the Find Object Navigation (EOEC_FIND_NAV) page in the following ways:
  1. Select Setup <Product>, System Administration, Utilities, Find Object Navigation .
  2. Select Enterprise Components, Find Object Navigation.

How do I add a component to a page in AEM?

Articles are an extension of AEM page templates. Select an article, you want to edit and click on Edit to add components to the article. Choose the ‘+’ on the left panel to add components to your article.

What is a component in PeopleSoft?

A PeopleSoft Component is a collection of pages which are logically grouped. Earlier to the introduction of PIA in 8.0, the Component was called Panel Group. You can add pages to the Component by a simple drag and drop. All components in PeopleSoft should have a search record associated with it.

What is a menu in PeopleSoft?

A menu is a logical grouping of components for assigning security to your system. … You can create two types of menus using PeopleSoft Application Designer: Custom (component) menus provide an internal reference for components and pages. They are grouped logically into menu groups to assign security.

How do you add a component to a permission list in PeopleSoft?

From the PeopleSoft menu tree, select PeopleTools > Security > Permissions & Roles > Permission Lists. Search for the ALLPAGES permission list link. The Permission List component is displayed. Set Full Access for each method of the component interfaces that were added in the previous step.

How do you find navigation of component in Peoplesoft?

If you know the component name & have SQL access, you can use this SQL to find the navigation to the component. However there is an easier way to find the navigation to a component or page from PIA. Navigate to Enterprise Components > Find Object Navigation.
You May Also Like