View data (query results) and metadata (columns) in the view

You are here: Primavera Unifier Administration Mode > Company Administration > Data Views > View data (query results) and metadata (columns) in the view

View data (query results) and metadata (columns) in the view

The Data button will return the query results of the view (essentially, a preview of the report results, without any user entered parameters).

The Metadata button will return all of the columns in the view. The Metadata button will return the definition of the columns: names, type and labels of the columns used in the view. For example:

To view query results

In Administration Mode, go to the Company Workspace tab and click Company > Data Structure Setup > Data Views in the left Navigator. The User-Defined Data Views log opens.

Select a view in the User-Defined Data Views log.

Click the Data button. The results window will display the query results.

To view columns

Select a view in the User-Defined Data Views log.

Click the Metadata button. The results window will return all of the columns in the view.

Oracle Corporation