RE: Select Type from Task

54 views
Skip to first unread message

Ramachandra, Rajesh

unread,
Jul 17, 2012, 6:12:55 PM7/17/12
to version...@googlegroups.com

Hi ,

 

I am new to this group..

 

How do I pull all the sprints for a specific team..?

 

What query I need to use for this..?

 

Thanks in advance.

 

Raj

 

From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Gustavsen, Daniel
Sent: Monday, July 16, 2012 1:14 PM
To: version...@googlegroups.com
Subject: Select Type from Task

 

Hello,

 

In my Task query, how can I pull in the task Type?

 

This is my current query:

 

Thanks,

Dan

--
You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
To view this discussion on the web visit https://groups.google.com/d/msg/versionone-dev/-/Bz8l3foHHiYJ.
To post to this group, send email to version...@googlegroups.com.
To unsubscribe from this group, send email to versionone-de...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/versionone-dev?hl=en.

 

 

 

 

*****************************************************************************

This email may contain confidential or privileged information. If you believe

you have received the message in error, please notify the sender and delete

the message without copying or disclosing it.

*****************************************************************************

 

ibuchanan

unread,
Jul 17, 2012, 8:08:47 PM7/17/12
to version...@googlegroups.com
Rajesh,
 
Welcome to the group. As a first pointer, I would suggest starting a new thread for a new question. Next, I recommend reading up on the core API documentation. The example-based approach makes it a great learning resource.
 
To your specific question, one of the first things you need from the above document is the "secret decoder ring" for converting the things you see in the UI to the name in the underlying system. When you look at Table 1, you'll see that Sprint in the UI maps to Timebox in the system. As the documentation shows, it is usually helpful to query the metadata first, as so:
 
Based on the attributes for Timebox, let's get a list of all Timeboxes with just Name, Begin Date, and State Code, showing only 10 at a time:
 
The next part of the query gets really interesting. You said Sprints for a specific Team. While there is an asset type for Team, there's no direct relationship between Team and Timebox. Moreover, I suspect you really have a Project node for your team. Again, using Table 1, we can see the asset type is called Scope. What makes this really iteresting is that you see Sprints in a Project in the UI but there's an indirection through Schedule. So, we need to know which Scope is the parent:
 
For the sake of example, I may have determined the Scope of interest is Scope:1025. So, to get the Timeboxes in that Scope:
 
(Note: in a real production API client, you aren't required to use the paging attribute. However, some sets of data can be huge, so for testing and experimentation, it's a good idea. For all queries above, you can use admin/admin credentials. There's a lot of data in that sandbox so be sure to use paging.)
 
The docs will give you a lot more context for how I got to the last step. Hope that helps.
 
Yours truly,
Ian Buchanan
Product Manager for Platform and Integrations
 

On Tuesday, July 17, 2012 6:12:55 PM UTC-4, Ramachandra, Rajesh wrote:

Hi ,

 

I am new to this group..

 

How do I pull all the sprints for a specific team..?

 

What query I need to use for this..?

 

Thanks in advance.

 

Raj

 

From: versionone-dev@googlegroups.com [mailto:versionone-dev@googlegroups.com] On Behalf Of Gustavsen, Daniel
Sent: Monday, July 16, 2012 1:14 PM
To: versionone-dev@googlegroups.com
Subject: Select Type from Task

 

Hello,

 

In my Task query, how can I pull in the task Type?

 

This is my current query:

 

Thanks,

Dan

--
You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
To view this discussion on the web visit https://groups.google.com/d/msg/versionone-dev/-/Bz8l3foHHiYJ.

To post to this group, send email to versionone-dev@googlegroups.com.
To unsubscribe from this group, send email to versionone-dev+unsubscribe@googlegroups.com.


For more options, visit this group at http://groups.google.com/group/versionone-dev?hl=en.

Ramachandra, Rajesh

unread,
Jul 18, 2012, 1:54:13 PM7/18/12
to version...@googlegroups.com

Thanks a lot Ian.

 

Regards

Raj

To post to this group, send email to version...@googlegroups.com.
To unsubscribe from this group, send email to versionone-de...@googlegroups.com.


For more options, visit this group at http://groups.google.com/group/versionone-dev?hl=en.

 

 

 

 

*****************************************************************************

This email may contain confidential or privileged information. If you believe

you have received the message in error, please notify the sender and delete

the message without copying or disclosing it.

*****************************************************************************

 

--

You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.

To view this discussion on the web visit https://groups.google.com/d/msg/versionone-dev/-/LYFUWl3D8M8J.
To post to this group, send email to version...@googlegroups.com.
To unsubscribe from this group, send email to versionone-de...@googlegroups.com.

Reply all
Reply to author
Forward
0 new messages