Post

2 followers Follow
0
Avatar

REST API CZQL - Get active projects list from Group Alpha and Group Beta

I'm trying to automate a report using Clarizen API. I'm new to this Clarizen API and CZQL, can you please help with the CZQL to get the project id for the projects in Active state and in groups Alpha, Beta

I've been using the below CZQL to get the Active project, but couldn't figure out how to filter the only projects in Alpha and Beta groups

POST https://api2.clarizen.com/v2.0/services/data/query

{

"q" : "SELECT Name, sysid, state.name From Project Where state = 'Active'"

}

Kagita, Avinash Answered

Official comment

Avatar

Hi Avinash,

Could you please clarify what makes a project belong to Alpha or Beta group? Is group a custom field on the project? Is it something else?

Thank you,

Roland

Roland Pumputis
Comment actions Permalink

Please sign in to leave a comment.

4 comments

0
Avatar

Hi Roland,

Thanks for your response. Group is a custom field in project. We're using it to filter the active projects in this two groups as shown in the attached screenshot. 

Please let me know if need any further information.

Regards,

Avinash

Kagita, Avinash 0 votes
Comment actions Permalink
1
Avatar

Hi Avinash,

If the API name of the Group field is C_Group, then please try the following query:

SELECT Name, sysid, state.name From Project Where state = 'Active' AND (C_Group='RBG' OR C_Group='RFG')

I hope this helps.
Roland

Roland Pumputis 1 vote
Comment actions Permalink
0
Avatar

Thanks Roland, I got right Group name from my admin and your query worked. Thanks a lot!

Kagita, Avinash 0 votes
Comment actions Permalink