Post

1 follower Follow
0
Avatar

support functions in czql

Refer to the origin here: 
https://success.clarizen.com/hc/en-us/community/posts/360014367113-CZQL-StartDate-today-

and

https://success.clarizen.com/hc/en-us/requests/53912?page=1

 

The idea is sometimes we don't want to page through the data, and we only need the result set that is newer or equal to today.

 

Here is the text of the original post:

 

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 Not planned

Please sign in to leave a comment.