When running below CZQL query:
SELECT WorkItem.Name, WorkItem.SYSID, Resource.Name, Resource.C_FMNO, Resource.C_Role.Name, C_StaffedPerDiem, CreatedOn, CreatedBy.Name, CreatedBy.C_FMNO, LastUpdatedOn, LastUpdatedBy.Name, LastUpdatedBy.C_FMNO FROM RegularResourceLink WHERE WorkItem IN ( SELECT id FROM Project WHERE SYSID = "P-375201" ) LIMIT 1000 OFFSET 0
Results:
{"entities":[{"id":"/RegularResourceLink/2jz9loq55med0ufwjxxm8qrib1240","WorkItem":{"id":"/Project/2jz9loq55med0ufwjxxm8qrib1233","Name":"Proj. TEST company – CX Solutions – Work Plan Update - Istvan/Rohan","SYSID":"P-375201"},"Resource":{"id":"/User/acb96087-95ed-47ed-ac2f-f879f45b7cee","Name":"Istvan Szabo","C_FMNO":"135931","C_Role":{"id":"/C_ResourceEntityRole/Operations Coordinator","Name":"Operations Coordinator"}},"C_StaffedPerDiem":{"currency":"USD","value":12.0},"CreatedOn":"2019-07-19T07:11:10.2663770","CreatedBy":{"id":"/User/3rrom3al9dpfs47birnql1fl10","Name":"Rohan Gulati","C_FMNO":"164803"},"LastUpdatedOn":"2019-07-23T14:16:29.4862270","LastUpdatedBy":{"id":"/User/acb96087-95ed-47ed-ac2f-f879f45b7cee","Name":"Istvan Szabo","C_FMNO":"135931","C_Role":{"id":"/C_ResourceEntityRole/Operations Coordinator","Name":"Operations Coordinator"}}},{"id":"/RegularResourceLink/2jz9loq55med0ufwjxxm8qrib1235","WorkItem":{"id":"/Project/2jz9loq55med0ufwjxxm8qrib1233","Name":"Proj. TEST company – CX Solutions – Work Plan Update - Istvan/Rohan","SYSID":"P-375201"},"Resource":{"id":"/User/3rrom3al9dpfs47birnql1fl10","Name":"Rohan Gulati","C_FMNO":"164803"},"C_StaffedPerDiem":{"currency":"USD","value":8.0},"CreatedOn":"2019-07-19T07:11:10.2113810","CreatedBy":{"id":"/User/3rrom3al9dpfs47birnql1fl10","Name":"Rohan Gulati","C_FMNO":"164803"},"LastUpdatedOn":"2019-07-23T14:16:45.5096000","LastUpdatedBy":{"id":"/User/acb96087-95ed-47ed-ac2f-f879f45b7cee","Name":"Istvan Szabo","C_FMNO":"135931","C_Role":{"id":"/C_ResourceEntityRole/Operations Coordinator","Name":"Operations Coordinator"}}}],"paging":{"from":2,"limit":1000,"hasMore":false}}
Expected:
See attached image for details (under "/RegularResourceLink/2jz9loq55med0ufwjxxm8qrib1235" Resource "Rohan Gulati" should have "Operations Coordinator" as Role)
Hi Istvan,
Unfortunately I could not reproduce the error. In my case everything works as expected.
Does it happens for other ResourceLinks or only for this one? Did you see this once or it happens all the time?
If you still suffer from this issue, please open a Support Ticket.
Regards.
Please sign in to leave a comment.
Hi Alex,
Thanks for your reply.
Unfortunately this is not a one-time issue but it's systematically incorrect for this query in our organization.
I have already opened a support ticket, but they closed due to "The API is outside the scope of this support channel (see image below). We would recommend working with your Clarizen Professional Services consultant on issues such as these":
https://success.clarizen.com/hc/en-us/requests/64619
Best regards,
Istvan
Hi Istvan,
I read the ticket.
Please contact your PS consultant as suggested by @Josh Santos.
Regards.