Bug 283200 - [bugzilla] support querying over custom fields
Summary: [bugzilla] support querying over custom fields
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Mylyn (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P2 enhancement (vote)
Target Milestone: 3.5   Edit
Assignee: Frank Becker CLA
QA Contact:
URL:
Whiteboard:
Keywords: noteworthy, plan
Depends on: 323474 324041
Blocks: 304104
  Show dependency tree
 
Reported: 2009-07-10 16:23 EDT by Shawn Minto CLA
Modified: 2011-02-23 15:29 EST (History)
3 users (show)

See Also:


Attachments
example (18.61 KB, image/png)
2010-10-26 17:22 EDT, Steffen Pingel CLA
no flags Details
screenshot (125.60 KB, image/jpeg)
2010-11-09 15:06 EST, Frank Becker CLA
no flags Details
current implematation (18.44 KB, patch)
2010-11-09 15:08 EST, Frank Becker CLA
no flags Details | Diff
mylyn/context/zip (10.84 KB, application/octet-stream)
2010-11-09 15:08 EST, Frank Becker CLA
no flags Details
screenshot of Bugzilla 4.0 UI (190.14 KB, image/jpeg)
2010-11-12 13:48 EST, Frank Becker CLA
no flags Details
patch V2 (56.68 KB, patch)
2011-02-02 15:08 EST, Frank Becker CLA
no flags Details | Diff
mylyn/context/zip (72.31 KB, application/octet-stream)
2011-02-02 15:08 EST, Frank Becker CLA
no flags Details
example of the patch V2 UI (127.21 KB, image/jpeg)
2011-02-02 23:44 EST, Frank Becker CLA
no flags Details
patch V3 (64.67 KB, patch)
2011-02-09 17:01 EST, Frank Becker CLA
eclipse: review?
Details | Diff
mylyn/context/zip (52.52 KB, application/octet-stream)
2011-02-09 17:01 EST, Frank Becker CLA
no flags Details
Mac sreenshot (178.25 KB, image/jpeg)
2011-02-10 01:15 EST, Frank Becker CLA
no flags Details
patch V4 (5.63 KB, patch)
2011-02-16 16:40 EST, Frank Becker CLA
no flags Details | Diff
mylyn/context/zip (136.29 KB, application/octet-stream)
2011-02-16 16:40 EST, Frank Becker CLA
no flags Details
expanded boolean charts (4.89 KB, image/png)
2011-02-22 13:47 EST, Sam Davis CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Shawn Minto CLA 2009-07-10 16:23:54 EDT
Now there there is support for editing custom fields in the bugzilla editor, it would be nice if a user could create a query over the custom fields in bugzill using the rich query editor instead of using the URL.
Comment 1 Robert Elves CLA 2009-12-22 22:00:41 EST
Will raise in 3.4 planning
Comment 2 Frank Becker CLA 2010-10-26 15:16:50 EDT
I start working on this.

I think we should support Charts for all fields an not only for custom fields.

Thoughts?
Comment 3 Steffen Pingel CLA 2010-10-26 15:25:19 EDT
Frank, what do you have in mind for the design of user interface to support charts and custom fields?

(In reply to comment #2)
> I think we should support Charts for all fields an not only for custom fields.

That makes sense to me.
Comment 4 Frank Becker CLA 2010-10-26 16:51:46 EDT
(In reply to comment #3)
> Frank, what do you have in mind for the design of user interface to support
> charts and custom fields?

I want to try to keep this like the /query.cgi#chart UI. So we may need an scroller. Or should we use to tab controls one for the current fields under "More Options" and the other for the Chart Controls. But I thine we also need the scroller.

Thoughts?
Comment 5 Steffen Pingel CLA 2010-10-26 17:22:31 EDT
Created attachment 181786 [details]
example
Comment 6 Steffen Pingel CLA 2010-10-26 17:29:16 EDT
I would prefer if we discussed this on the next Mylyn call first. I think it would be a great addition but we should be careful about adding a lot of extra complexity to an already crowded dialog.
Comment 7 Frank Becker CLA 2010-10-27 14:20:27 EDT
(In reply to comment #6)
> I would prefer if we discussed this on the next Mylyn call first. I think it
> would be a great addition but we should be careful about adding a lot of extra
> complexity to an already crowded dialog.

OK

so I first try to manage the background work.
Comment 8 Frank Becker CLA 2010-11-09 15:06:04 EST
Created attachment 182765 [details]
screenshot

here is a screenshot of my current UI state. Only the negate checkbox is not implemented.

I think we should do an redesign of the whole dialog.

Maybe we should use a similar UI like Bugzilla 4.?

OR should we use tabs instead of expands?

Thoughts?
Comment 9 Frank Becker CLA 2010-11-09 15:08:07 EST
Created attachment 182766 [details]
current implematation

Her are my changes. If you want to try it out.
Comment 10 Frank Becker CLA 2010-11-09 15:08:09 EST
Created attachment 182767 [details]
mylyn/context/zip
Comment 11 Steffen Pingel CLA 2010-11-11 15:49:18 EST
Thanks. I'll add this as a discussion item for next week's call. Can you post a screenshot of the Bugzilla 4 UI?
Comment 12 Frank Becker CLA 2010-11-12 13:48:49 EST
Created attachment 183027 [details]
screenshot of Bugzilla 4.0 UI

you can use http://mylyn.eclipse.org/bugshead/query.cgi to see this in action.
Comment 13 Steffen Pingel CLA 2010-11-18 14:47:30 EST
We did a quick UI review on today's call. The proposed design looks pretty good and everyone liked it.

Here are some suggestions:

* Remove all groups except for the inner most grouping around connected OR rows.
* Try reducing horizontal spacing withing OR groups. 

The following questions came up:

* Is it necessary to support multiple charts? What is the difference to adding another "And" row?
* How can rows or charts be deleted? Is an extra control for deleting needed?
Comment 14 Frank Becker CLA 2011-02-02 15:08:32 EST
Created attachment 188185 [details]
patch V2

(In reply to comment #13)
> We did a quick UI review on today's call. The proposed design looks pretty good
> and everyone liked it.
> 
> Here are some suggestions:
> 
> * Remove all groups except for the inner most grouping around connected OR rows.
> * Try reducing horizontal spacing withing OR groups.
> 

This is in this patch!

Should we do an review or can I commit this?

> The following questions came up:
> 
> * Is it necessary to support multiple charts? What is the difference to adding
> another "And" row?
This is because you can negate a  chart
> * How can rows or charts be deleted? Is an extra control for deleting needed?
If a field is "---" it is removed when you save the query.
Comment 15 Frank Becker CLA 2011-02-02 15:08:37 EST
Created attachment 188187 [details]
mylyn/context/zip
Comment 16 Steffen Pingel CLA 2011-02-02 20:30:05 EST
Let's do a quick review on the call tomorrow committing. I have added this to the agenda.
Comment 17 Frank Becker CLA 2011-02-02 23:44:14 EST
Created attachment 188209 [details]
example of the patch V2 UI
Comment 18 Frank Becker CLA 2011-02-02 23:52:01 EST
(In reply to comment #16)
> Let's do a quick review on the call tomorrow committing. I have added this to
> the agenda.

Maybe you can also look forhttps://bugs.eclipse.org/bugs/show_bug.cgi?id=335278#c10 where I describe an new UI for the search page.
Comment 19 Steffen Pingel CLA 2011-02-03 16:45:52 EST
This is looking pretty good.

Notes from the UI review:
* Call the new section "Boolean Charts (Advanced)".
* Set a minimum height for list boxes and add a vertical scroll bar as needed.
* Remove the border if adding a new chart and use a single separator line between charts instead.
* Consider changing the "OR" buttons to "X" once pressed to allow users to remove lines.
* Remove indentation for Boolean Chart section content.
* Negate is a bit confusing as it applies to chart above the check box. Not sure how we can best address this without using up vertical space.
* "negate" should be "Negate"
* "New chart" should be "Add Chart"

I had a number of problems with the layout:
* The main section does not grow to all available space when resizing the dialog
* If I press "And" the UI is not updated until I toggle a section
* I got exceptions:
org.eclipse.swt.SWTException: Widget is disposed
	at org.eclipse.swt.SWT.error(SWT.java:4209)
	at org.eclipse.swt.SWT.error(SWT.java:4124)
	at org.eclipse.swt.SWT.error(SWT.java:4095)
	at org.eclipse.swt.widgets.Widget.error(Widget.java:466)
	at org.eclipse.swt.widgets.Widget.checkWidget(Widget.java:403)
	at org.eclipse.swt.widgets.Button.setSelection(Button.java:905)
	at org.eclipse.mylyn.internal.bugzilla.ui.search.BugzillaSearchPage.refreshChartControls(BugzillaSearchPage.java:2887)
	...
	
I wonder if there is a good way to make this kind of UI with the scrolling and nested sections commons so other connectors could use it as well?
Comment 20 Frank Becker CLA 2011-02-04 14:18:12 EST
OK I start with this now!

Hope that I can refactor a new common class.
Comment 21 Steffen Pingel CLA 2011-02-04 14:56:34 EST
You can put the common abstractions that are query page specific in AbstractRepositoryQueryPage2. SectionComposite already provides a UI component with some of the support that we need for this.
Comment 22 Frank Becker CLA 2011-02-09 17:01:36 EST
Created attachment 188628 [details]
patch V3

committed patch.

Steffen can you please verify and comment on the new layout.
Comment 23 Frank Becker CLA 2011-02-09 17:01:41 EST
Created attachment 188629 [details]
mylyn/context/zip
Comment 24 Steffen Pingel CLA 2011-02-09 18:42:38 EST
That's great! I like the green background color :). I'll do some more testing and add this to an upcoming meeting agenda for another UI review. Can you attach a Mac screenshot?
Comment 25 Frank Becker CLA 2011-02-10 01:15:52 EST
Created attachment 188651 [details]
Mac sreenshot

Here the requested screenshot.

Sorry the green color was only to see if there is no error by setting the background.
Comment 26 Frank Becker CLA 2011-02-15 15:37:50 EST
Steffen,

What was the result of your tests?

Can I close this?

Frank
Comment 27 Steffen Pingel CLA 2011-02-15 16:21:41 EST
We are almost done here :). Just a few minor nits remaining:

* The Boolean Charts composite has a margin that should be removed.
* Can we make the "Or" buttons turn into "X" buttons once a new row is added? I tried pressing Ctrl but it didn't work on my system and it's difficult to discover.
* Is it possible to increase the minimum height for the Product, Priority etc. list boxes? I think they should at least display three rows.
Comment 28 Steffen Pingel CLA 2011-02-15 17:13:03 EST
Just noticed a regression: More Options is not expanded when the query dialog is opened and a Milestone was selected for a query.
Comment 29 Frank Becker CLA 2011-02-16 16:40:35 EST
Created attachment 189135 [details]
patch V4

(In reply to comment #27)
> We are almost done here :). Just a few minor nits remaining:
> 
> * The Boolean Charts composite has a margin that should be removed.
Sorry I found no way to remove this.
> * Can we make the "Or" buttons turn into "X" buttons once a new row is added? I
> tried pressing Ctrl but it didn't work on my system and it's difficult to
> discover.
Now we use SHIFT(MOD2) and no longer CTRL (MOD4 on MAC)
see copy from SWT.class:
	/*
	* These values can be different on different platforms.
	* Therefore they are not initialized in the declaration
	* to stop the compiler from inlining.
	*/
	String platform = getPlatform ();
	if ("carbon".equals (platform) || "cocoa".equals (platform)) { //$NON-NLS-1$ //$NON-NLS-2$
		MOD1 = COMMAND;
		MOD2 = SHIFT;
		MOD3 = ALT;
		MOD4 = CONTROL;
	} else {
		MOD1 = CONTROL;
		MOD2 = SHIFT;
		MOD3 = ALT;
		MOD4 = 0;
	}

> * Is it possible to increase the minimum height for the Product, Priority etc.
> list boxes? I think they should at least display three rows.
Change to four lines.
(In reply to comment #28)
> Just noticed a regression: More Options is not expanded when the query dialog is
> opened and a Milestone was selected for a query.

more and chart are now expanded
Comment 30 Frank Becker CLA 2011-02-16 16:40:40 EST
Created attachment 189136 [details]
mylyn/context/zip
Comment 31 Sam Davis CLA 2011-02-16 19:36:25 EST
The next button in the new query wizard is no longer greyed out but doesn't do anything.
Comment 32 Steffen Pingel CLA 2011-02-16 19:39:13 EST
Thanks. I have removed some nested composites that weren't required and tweaked the margins some.

I noticed that clear does not clear the boolean charts. Frank, can you look into that and comment#31?
Comment 33 Steffen Pingel CLA 2011-02-16 19:39:34 EST
Reopening to address comment#31 and comment#32.
Comment 34 Frank Becker CLA 2011-02-17 13:38:47 EST
(In reply to comment #33)
> Reopening to address comment#31 and comment#32.

Done!
Comment 35 Sam Davis CLA 2011-02-22 13:46:01 EST
This is badly broken for me. I cannot search for bugs at all. When I open the search dialog, the Boolean Charts section is expanded as shown, and clicking clear fields has no effect, but when I do any search (e.g. bugs assigned to me) I get no results.
Comment 36 Sam Davis CLA 2011-02-22 13:47:33 EST
Created attachment 189525 [details]
expanded boolean charts
Comment 37 Sam Davis CLA 2011-02-22 13:54:00 EST
I was able to fix myself by repeatedly collapsing and expanding the section and clicking clear fields, and now I can't get it into the bad state it was in, but I have been in that bad state before (I had assumed the problem had been fixed). I may not be completely up to date though because pserver access was out of date for several days.
Comment 38 Frank Becker CLA 2011-02-23 15:29:31 EST
(In reply to comment #36)
> Created attachment 189525 [details]
> expanded boolean charts

Sam that screenshot is the presentation for an empty boolean chart. But I do not know why you get this expanded when you open the page.

If you can reproduce this or find other problems please reoppen this bug.