Post

2 followers Follow
0
Avatar

Unexpected API results

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)

Istvan Szabo Answered

Official comment

Avatar

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.

Alex Broitman

Please sign in to leave a comment.

3 comments

0
Avatar

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

Istvan Szabo 0 votes
0
Avatar

Hi Istvan,

I read the ticket.

Please contact your PS consultant as suggested by @Josh Santos.

Regards.

Alex Broitman 0 votes