Invoke Configuration Page
Select the tables and columns in Oracle Primavera Cloud or Oracle Primavera P6 EPPM that you want to query and fetch data from.
| Element | Description |
|---|---|
| Primavera Data Service application type |
This field is automatically set based on the selected data service type. If the data service type is Oracle Primavera Cloud Data Service, the application type is set to Primavera Cloud. If the data service type is Primavera Data Service, the application type is set to P6. |
| Select primary table | Select the primary table in Oracle Primavera Cloud or Oracle Primavera P6 EPPM that you want to fetch data from. |
| Select join table | (Optional) Select the secondary table in Oracle Primavera Cloud or Oracle Primavera P6 EPPM that you want to join to the primary table. When a join table is used, it acts as a filter on the primary table to narrow down the results. For example, if you want to fetch the activities that belong to a particular project, the activities table would be the primary table, and the project table would be the join (secondary) table. |
| Select Columns | The Available Options field shows the columns that are available in the selected primary table and join table. Select the table columns you want to fetch data from and use the Move to select button to move them to the Selected Options field, or use the Move all to selected button to move all the available table columns to the Selected Options field. |
| Provide query condition |
Enter the condition you want to apply to the query. For example:
|
|
Provide join table details (for Oracle Primavera P6 EPPM only) |
If using a join table, enter the condition you want to apply to the join table query. For example:
|