Query to find hours for Install Testing
6 views
Skip to first unread message
Pat O
Aug 31, 2010, 3:42:49 PM8/31/10
to VersionOne-dev
Hello,
Although I have been using VersionOne for a couple of years now, I
find that I never get any better at using the query interface. I
suppose it is because I use it so infrequently. At any rate, I am
attempting to figure out how many hours we put into testing our
installer. We use Stories for manual tests, so the QA team can put in
time. What I would like to so in SQL is:
Select sum(effort) from Stories where Scope='Scope:35561' and Name
like 'Install '
I seem to recall that there is a trick to accumulating the actual
effort. Also I do not know of a way to do a like in the where
parameter.
Pat O
Although I have been using VersionOne for a couple of years now, I
find that I never get any better at using the query interface. I
suppose it is because I use it so infrequently. At any rate, I am
attempting to figure out how many hours we put into testing our
installer. We use Stories for manual tests, so the QA team can put in
time. What I would like to so in SQL is:
Select sum(effort) from Stories where Scope='Scope:35561' and Name
like 'Install '
I seem to recall that there is a trick to accumulating the actual
effort. Also I do not know of a way to do a like in the where
parameter.
Pat O
Joel Tosi
Aug 31, 2010, 3:52:48 PM8/31/10
to version...@googlegroups.com
Hi Pat,
Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
Here is a quick sample query, showing total recorded effort for tests from a story like 'List' (think %List%'). You could of course replace 'Test' with 'Task' if you prefer that route. If you want to limit it down more (scope) add the where clause - i.e. &where=Scope='Scope:35561'
Hope this helps,
Joel
Joel | 678.394.3376
Pat O
--
You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
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.
Pat O
Aug 31, 2010, 5:57:36 PM8/31/10
to VersionOne-dev
We track effort at the story level. We are not using the Test
element, but create a backlog item (Story) for each test we wish to
run. The following query returns nothing in the Actuals values:
http://localhost/VersionOne/rest-1.v1/Data/Story?sel=Name,Actuals.Value.@Sum&where=Scope='Scope:35561'
What do find and findin do? Why is there still no documentation for
this query language?
Pat O
On Aug 31, 2:52 pm, "Joel Tosi" <Joel.T...@versionone.com> wrote:
> Hi Pat,
> Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
>
> Here is a quick sample query, showing total recorded effort for tests from a story like 'List' (think %List%'). You could of course replace 'Test' with 'Task' if you prefer that route. If you want to limit it down more (scope) add the where clause - i.e. &where=Scope='Scope:35561'
>
> http://localhost/VersionOne_Demo/rest-1.v1/Data/Test?sel=Parent.ID,Ac...
>
> Hope this helps,
> Joel
>
> Joel |678.394.3376begin_of_the_skype_highlighting 678.394.3376 end_of_the_skype_highlighting
>
> - Show quoted text -
element, but create a backlog item (Story) for each test we wish to
run. The following query returns nothing in the Actuals values:
http://localhost/VersionOne/rest-1.v1/Data/Story?sel=Name,Actuals.Value.@Sum&where=Scope='Scope:35561'
What do find and findin do? Why is there still no documentation for
this query language?
Pat O
On Aug 31, 2:52 pm, "Joel Tosi" <Joel.T...@versionone.com> wrote:
> Hi Pat,
> Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
>
> Here is a quick sample query, showing total recorded effort for tests from a story like 'List' (think %List%'). You could of course replace 'Test' with 'Task' if you prefer that route. If you want to limit it down more (scope) add the where clause - i.e. &where=Scope='Scope:35561'
>
>
> Hope this helps,
> Joel
>
> Joel |678.394.3376begin_of_the_skype_highlighting 678.394.3376 end_of_the_skype_highlighting
>
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 3:43 PM
> To: VersionOne-dev
> Subject: Query to find hours for Install Testing
>
> Hello,
> Although I have been using VersionOne for a couple of years now, I
> find that I never get any better at using the query interface. I
> suppose it is because I use it so infrequently. At any rate, I am
> attempting to figure out how many hours we put into testing our
> installer. We use Stories for manual tests, so the QA team can put in
> time. What I would like to so in SQL is:
>
> Select sum(effort) from Stories where Scope='Scope:35561' and Name
> like 'Install '
>
> I seem to recall that there is a trick to accumulating the actual
> effort. Also I do not know of a way to do a like in the where
> parameter.
>
> Pat O
>
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
> 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 athttp://groups.google.com/group/versionone-dev?hl=en.- Hide quoted text -
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 3:43 PM
> To: VersionOne-dev
> Subject: Query to find hours for Install Testing
>
> Hello,
> Although I have been using VersionOne for a couple of years now, I
> find that I never get any better at using the query interface. I
> suppose it is because I use it so infrequently. At any rate, I am
> attempting to figure out how many hours we put into testing our
> installer. We use Stories for manual tests, so the QA team can put in
> time. What I would like to so in SQL is:
>
> Select sum(effort) from Stories where Scope='Scope:35561' and Name
> like 'Install '
>
> I seem to recall that there is a trick to accumulating the actual
> effort. Also I do not know of a way to do a like in the where
> parameter.
>
> Pat O
>
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
> To post to this group, send email to version...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-de...@googlegroups.com.
>
> - Show quoted text -
Pat O
Aug 31, 2010, 6:01:50 PM8/31/10
to VersionOne-dev
Ok,
I found the docs for find and findin, silly me I was trying to use a
where clause. The actuals still returns nothing for my query. BTW,
these items are all closed (We are done with that sprint). I assume
that is not an issue.
>
> Hope this helps,
> Joel
>
> Joel |678.394.3376begin_of_the_skype_highlighting 678.394.3376 end_of_the_skype_highlighting
I found the docs for find and findin, silly me I was trying to use a
where clause. The actuals still returns nothing for my query. BTW,
these items are all closed (We are done with that sprint). I assume
that is not an issue.
> Hi Pat,
> Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
>
> Here is a quick sample query, showing total recorded effort for tests from a story like 'List' (think %List%'). You could of course replace 'Test' with 'Task' if you prefer that route. If you want to limit it down more (scope) add the where clause - i.e. &where=Scope='Scope:35561'
>
> http://localhost/VersionOne_Demo/rest-1.v1/Data/Test?sel=Parent.ID,Ac...
> Are you tracking effort at the story level or at the task / test level? Also, in your query below, is 'Name like Install' referring to all of the stories / task /tests are named with Install?
>
> Here is a quick sample query, showing total recorded effort for tests from a story like 'List' (think %List%'). You could of course replace 'Test' with 'Task' if you prefer that route. If you want to limit it down more (scope) add the where clause - i.e. &where=Scope='Scope:35561'
>
>
> Hope this helps,
> Joel
>
> Joel |678.394.3376begin_of_the_skype_highlighting 678.394.3376 end_of_the_skype_highlighting
>
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 3:43 PM
> To: VersionOne-dev
> Subject: Query to find hours for Install Testing
>
> Hello,
> Although I have been using VersionOne for a couple of years now, I
> find that I never get any better at using the query interface. I
> suppose it is because I use it so infrequently. At any rate, I am
> attempting to figure out how many hours we put into testing our
> installer. We use Stories for manual tests, so the QA team can put in
> time. What I would like to so in SQL is:
>
> Select sum(effort) from Stories where Scope='Scope:35561' and Name
> like 'Install '
>
> I seem to recall that there is a trick to accumulating the actual
> effort. Also I do not know of a way to do a like in the where
> parameter.
>
> Pat O
>
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
> To post to this group, send email to version...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-de...@googlegroups.com.
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 3:43 PM
> To: VersionOne-dev
> Subject: Query to find hours for Install Testing
>
> Hello,
> Although I have been using VersionOne for a couple of years now, I
> find that I never get any better at using the query interface. I
> suppose it is because I use it so infrequently. At any rate, I am
> attempting to figure out how many hours we put into testing our
> installer. We use Stories for manual tests, so the QA team can put in
> time. What I would like to so in SQL is:
>
> Select sum(effort) from Stories where Scope='Scope:35561' and Name
> like 'Install '
>
> I seem to recall that there is a trick to accumulating the actual
> effort. Also I do not know of a way to do a like in the where
> parameter.
>
> Pat O
>
> --
> You received this message because you are subscribed to the Google Groups "VersionOne-dev" group.
> To post to this group, send email to version...@googlegroups.com.
> To unsubscribe from this group, send email to versionone-de...@googlegroups.com.
Joel Tosi
Aug 31, 2010, 9:55:44 PM8/31/10
to version...@googlegroups.com
Evening Pat,
The items being closed wouldn't matter. On a local test system, I changed my config to track effort at the story level and added some tracked time to a story. Here is the query - http://localhost/VersionOne_Tosi/rest-1.v1/Data/Story?sel=Name,AssetState,Actuals.Value.@Sum&find=List&findin=Name
The items being closed wouldn't matter. On a local test system, I changed my config to track effort at the story level and added some tracked time to a story. Here is the query - http://localhost/VersionOne_Tosi/rest-1.v1/Data/Story?sel=Name,AssetState,Actuals.Value.@Sum&find=List&findin=Name
It is pretty much the same as the original one I sent, I just changed the asset from Test to Story and modified the findin value. The result I get looks like this:
<Asset href="/VersionOne_Demo/rest-1.v1/Data/Story/8538" id="Story:8538">
<Attribute name="AssetState">128</Attribute>
<Attribute name="Actuals.Value.@Sum">5</Attribute>
<Attribute name="Name">List of Books by Genre</Attribute>
</Asset>
The third line - Actuals.Value.@Sum - shows the tracked time so far as 5 hours.
If this isn't working for you, send over the query you are running and I will look it over to see if anything looks off.
Best,
Joel
Joel | 678.394.3376
Joel Tosi
Aug 31, 2010, 9:56:45 PM8/31/10
to version...@googlegroups.com
Lets try the query just using find and findin without the where clause for now to see if you can get some result for the story.
Joel
Joel | 678.394.3376
-----Original Message-----
From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
Sent: Tuesday, August 31, 2010 5:58 PM
To: VersionOne-dev
Pat O
Sep 1, 2010, 1:02:50 PM9/1/10
to VersionOne-dev
I did figure it out. I end up spending so much time researching the
right commands for the query that I miss simple stuff (like spelling)
in the criteria.
Thanks for your help. Wish there was a more "standard" query
interface. Sometimes it is good to be innovative, sometimes not so
much.
Pat O
On Aug 31, 8:56 pm, "Joel Tosi" <Joel.T...@versionone.com> wrote:
> Lets try the query just using find and findin without the where clause for now to see if you can get some result for the story.
>
> Joel
>
> > For more options, visit this group athttp://groups.google.com/group/versionone-dev?hl=en.-Hide quoted text -
right commands for the query that I miss simple stuff (like spelling)
in the criteria.
Thanks for your help. Wish there was a more "standard" query
interface. Sometimes it is good to be innovative, sometimes not so
much.
Pat O
On Aug 31, 8:56 pm, "Joel Tosi" <Joel.T...@versionone.com> wrote:
> Lets try the query just using find and findin without the where clause for now to see if you can get some result for the story.
>
> Joel
>
> Joel |678.394.3376begin_of_the_skype_highlighting 678.394.3376 end_of_the_skype_highlighting
>
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 5:58 PM
> To: VersionOne-dev
> Subject: Re: Query to find hours for Install Testing
>
> We track effort at the story level. We are not using the Test
> element, but create a backlog item (Story) for each test we wish to
> run. The following query returns nothing in the Actuals values:
>
> http://localhost/VersionOne/rest-1.v1/Data/Story?sel=Name,Actuals.Val...
>
>
>
> -----Original Message-----
> From: version...@googlegroups.com [mailto:version...@googlegroups.com] On Behalf Of Pat O
> Sent: Tuesday, August 31, 2010 5:58 PM
> To: VersionOne-dev
> Subject: Re: Query to find hours for Install Testing
>
> We track effort at the story level. We are not using the Test
> element, but create a backlog item (Story) for each test we wish to
> run. The following query returns nothing in the Actuals values:
>
Joel Tosi
Sep 1, 2010, 1:07:47 PM9/1/10
to version...@googlegroups.com
Good to hear that you were able to get it Pat.
If you have any recommendations / ideas on how the interface could be improved, please do let me know - either via the groups or feel free to call me or email me.
Joel
Joel | 678.394.3376
Reply all
Reply to author
Forward
0 new messages