Post

3 followers Follow
0
Avatar

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()

Jared Thompson Answered

Please sign in to leave a comment.

3 comments

0
Avatar

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

Elad Franklin 0 votes
0
Avatar

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.


Diana Sandura 0 votes