Saltar al contenido principal

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