跳到主要内容

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