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?
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<mailto:versionone-dev@googlegroups.com>.
To unsubscribe from this group, send email to versionone-dev+unsubscribe@googlegroups.com<mailto:versionone-dev+unsubscri be@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.
*************************************************************************** **
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. http://community.versionone.com/sdk/Documentation/DataAPI.aspx
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: https://www14.v1host.com/v1sdktesting/meta.v1/Timebox?xsl=api.xsl
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: https://www14.v1host.com/v1sdktesting/rest-1.v1/Data/Scope?sel=Name,B...
(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
> -- > 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.
From: versionone-dev@googlegroups.com [mailto:versionone-dev@googlegroups.com] On Behalf Of ibuchanan
Sent: Tuesday, July 17, 2012 5:09 PM
To: versionone-dev@googlegroups.com
Subject: Re: Select Type from Task
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.
http://community.versionone.com/sdk/Documentation/DataAPI.aspx
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:
https://www14.v1host.com/v1sdktesting/meta.v1/Timebox?xsl=api.xsl
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:
https://www14.v1host.com/v1sdktesting/rest-1.v1/Data/Scope?sel=Name,B...
(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> [mailto: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<mailto:versionone-dev@googlegroups.com>
Subject: Select Type from Task
Hello,
In my Task query, how can I pull in the task Type?
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<mailto:versionone-dev@googlegroups.com>.
To unsubscribe from this group, send email to versionone-dev+unsubscribe@googlegroups.com<mailto:versionone-dev+unsubscri be@googlegroups.com>.
For more options, visit this group at http://groups.google.com/group/versionone-dev?hl=en.
--
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 versionone-dev@googlegroups.com<mailto:versionone-dev@googlegroups.com>.
To unsubscribe from this group, send email to versionone-dev+unsubscribe@googlegroups.com<mailto:versionone-dev+unsubscri be@googlegroups.com>.
For more options, visit this group at http://groups.google.com/group/versionone-dev?hl=en.