Post

1 follower Follow
0
Avatar

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 ";

I've tried

CurrentObject()

$SYSID

None is working.

Any guidance in how to reference the ID will be appreciated.

Thanks Juan

 
 

 

Juan Holtzhausen

Please sign in to leave a comment.