Post

1 follower Follow
0
Avatar

CZQL reference Project

Could anyone please help me to get the project SYSID of the Project I'm in.  I have created a custom Panel and I can't figure out how to call the CurrentObject. 

In the code below, I need the "P-801" to dynamically update when I go from one project to another.

I'm using CZQL inside a script

 

var projectsQuery = "Select Name, C_WorksiteAddress, C_GPSLocation, Description, TrackStatus, PlannedRevenue, DueDate, Duration from Task " +
"where C_WorksiteAddress<>'' AND State='Active' and Project IN (SELECT ID FROM project WHERE SYSID='" + "P-801" + "') limit 1000 ";

API.Objects.query(projectsQuery, function(markers)

 

 

Juan Holtzhausen

Please sign in to leave a comment.