java czql Query - Calling Current Object
Hello All Could someone please point me in the right direction.
I have a Script that runs, that need to reference the current project's Id and inject it into my czql query.
var projectsQuery = "Select Name, C_WorksiteAddress, C_GPSLocation, Description, TrackStatus, PlannedRevenue, DueDate, Duration from Task " +
"where C_WorksiteAddress<>'' AND State='Active' AND Project='" + [I NEED IT TO GO HERE] + "' limit 1000 ";
None is working.
Any guidance in how to reference the ID will be appreciated.
Please sign in to leave a comment.