Shreedhar,
I had trouble defining a query that gets all the open
wist defects on a given date, for example 2006-08-27.
Here is a query that I defined that uses boolean charts to
filter on defects created before 2006-08-28 and then selects
defects still open or defects resolved after 2006-08-27 --
figuring they must have been open on 8/27 if they were created
before 8/27 and resolved after 8/27.
https://wsit.dev.java.net/issues/query.cgi?issue_type=DEFECT&component=wsit&version=current&emailtype1=exact&emailassigned_to1=1&emailtype2=exact&emailreporter2=1&issueidtype=include&chfieldto=Now&short_desc_type=substring&long_desc_type=substring&issue_file_loc_type=substring&status_whiteboard_type=substring&keywords_type=anytokens&field0-0-0=creation_ts&type0-0-0=lessthan&value0-0-0=2006-08-29&field0-1-0=issue_status&type0-1-0=anywords&value0-1-0=NEW%2CREOPENED%2CSTARTED&field0-1-1=resolution&type0-1-1=changedafter&value0-1-1=2006-08-27&cmdtype=doit&order=Reuse%20same%20sort%20as%20last%20time&Submit%20query=Submit%20query
Notice the above query only returns 9 defects. By doing a query
of all issues regardless of status, I was able to verify that 14 issues
where actually open on 2006-08-27.
Here is a hack query that selects bugs created before the taget date
that are still open and explicitly adds issues 6 and 31 which were
subsequently resolved. Of course, this is no good for long becasue
everytime a bug is resolved it going forward it would need to be
added, like issue 27 was recently resolved.
https://wsit.dev.java.net/issues/query.cgi?issue_type=DEFECT&component=wsit&version=current&emailtype1=exact&emailassigned_to1=1&emailtype2=exact&emailreporter2=1&issueidtype=include&chfieldto=Now&short_desc_type=substring&long_desc_type=substring&issue_file_loc_type=substring&status_whiteboard_type=substring&keywords_type=anytokens&field0-0-0=creation_ts&type0-0-0=lessthan&value0-0-0=2006-08-28&field0-1-0=issue_id&type0-1-0=equals&value0-1-0=6&field0-1-1=issue_id&type0-1-1=equals&value0-1-1=31&field0-1-2=issue_status&type0-1-2=anywords&value0-1-2=NEW%2CSTARTED%2CREOPENED%2CUNCONFIRMED&cmdtype=doit&order=Reuse%20same%20sort%20as%20last%20time&Submit%20query=Submit%20query
This makes me think I'm using the boolean chart "or" correctly, but
there seems to
be a bug in Issue Tracker when you OR together a "status" and "resolved"
conditions.
Tom
Shreedhar Ganapathy wrote:
> Hi Tom
> Could you send a sample set of steps I could use to convey this to the
> right people?
>
> regards
> Shreedhar
>
> Tom Amiro wrote:
>
>> Hi,
>>
>> I believe there is a bug in Issue Tracker's boolean chart
>> query function. Try as hard as I may, it would not
>> return the correct list of bugs open on a given date.
>> How do we report such problems and get them fixed?
>>
>> Tom
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
>> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>