Hi Jared,
Sorry for the late response.
Function are currently not supported in this API action. Please open a CR and I hope we will be able to handle it in the near future.
Thanks,
Elad
Comment actions
Post
Follow
CZQL: StartDate >= today()
Having looked through the documentation I am not seeing this or anything like it.
Is there a way to get a query to limit itself by saying only return the results that have a StartDate >= today?
Here is the current query I am using that I want to limit the tasks returned to those that have a StartDate greater than or equal to the date that the query is executed.
SELECT
@Name,
StartDate
FROM
Task
WHERE project in (
Select id
from project
where @Name = 'CALENDAR: Engineering')
limit 1000
The reason why is because there are going to be many thousands of results to this query and it would greatly simplify it if I could just add in something like: StartDate >= today()
Please sign in to leave a comment.
3 comments
Date
Votes
Elad,
Just to confirm to open a CR as you requested, is that done by just posting the request to this forum:
https://success.clarizen.com/hc/en-us/community/topics/200269468-Share-Your-Ideas-Suggestions
?
If not - what is the process I should follow to open a CR?
Comment actions
Hello Jared,
The forum Share Your Ideas and Suggestions is correct:
https://success.clarizen.com/hc/en-us/community/topics/200269468-Share-Your-Ideas-Suggestions. Once you post your feature request there, we'll escalate it to our Product Team. As other customers add their comments and support for the request, it will increase its priority. We will also provide status updates via the community so that all customers have transparency around the request.
Comment actions