Skip to main content

PlanviewEnterprise.CallQueryService

Enter the URL, database name associated with your Planview Portfolios account and a SQL query.

Syntax​

PlanviewEnterprise.CallQueryService(
    url as text,
    database as text,
    sqlQueryString as text
) as table

Remarks​

Returns a table with Planview Portfolios data.

Examples​

Example #1​

Returns a table with Planview Portfolios data.

PlanviewEnterprise.CallQueryService(https://contoso.com/planview, pve, select * from PV_Table)

Result:

A table of Planview Portfolios data about database pve