Skip to main content
Version: 20 R7 BETA

$queryplan

Returns the query as it was passed to 4D Server (e.g., $queryplan=true)

Description

$queryplan returns the query plan as it was passed to 4D Server.

PropertyTypeDescription
itemStringActual query executed
subqueryArrayIf there is a subquery, an additional object containing an item property (as the one above)

For more information about query plans, refer to queryPlan and queryPath.

Example

If you pass the following query:

GET /rest/People/$filter="employer.name=acme AND lastName=Jones"&$queryplan=true

Response:

__queryPlan: {
And: [
{
item: "Join on Table : Company : People.employer = Company.ID",
subquery: [
{
item: "Company.name = acme"
}
]
},
{
item: "People.lastName = Jones"
}
]
}