According to the doc here: https://api.clarizen.com/V2.0/services/data/Query
Under the section called "Relations"
"You can include data from entities related to the main entity you are querying if a Relation exists between them"
The example provided is:
SELECT name, (SELECT name FROM Resources)
WHERE Manager = '/User/69936402-07d6-4620-9f36-9480a6527f6f'
Why then, where a relationship exists between a Project and a Task, can I not:
LastUpdatedBySystemOn > 2015-08-18T00:00:00
and externalid = '<alphanumeric>'
Running that query results in the following error referenceId 3DvKdZfnN31irJ3huKPrTl
Also, wondering whether CZQL supports the Month() function, so I can "group by" the nested query by "Month(Task.StartDate)"