517745 - Links in tabular reports about assignees and other user roles are broken for logged out users

Status: NEW

(Bugzilla :: Reporting/Charting, defect)

Description

[Steffen Pingel]

User-Agent:       Mozilla/5.0 (compatible; Konqueror/4.3; Linux 2.6.31-10-generic-pae; X11) KHTML/4.3.1 (like Gecko)
Build Identifier: 

If I click on an assignee in this report I am redirected to a query with 0 results. It appears that in the query link "assigned_to=mylyn-inbox" is set instead of "email1=mylyn-inbox&email2=&emailassigned_to1=1".

Reproducible: Always

Steps to Reproduce:
1. Run the queries linked in the description

Actual Results:  
https://bugs.eclipse.org/bugs/query.cgi?=&action=wrap&assigned_to=mylyn-inbox&bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&chfield=resolution&chfieldfrom=2008-07-01&chfieldto=Now&chfieldvalue=&classification=Tools&email1=&email2=&emailtype1=substring&emailtype2=substring&field0-0-0=noop&keywords=&keywords_type=allwords&longdesc=&longdesc_type=allwordssubstr&product=Mylyn&query_format=advanced&resolution=FIXED&short_desc=&short_desc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&type0-0-0=noop&value0-0-0=&votes=

Expected Results:  
https://bugs.eclipse.org/bugs/buglist.cgi?bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&chfield=resolution&chfieldfrom=2008-07-01&chfieldto=Now&chfieldvalue=&classification=Tools&email1=mylyn-inbox&email2=&emailassigned_to1=1&emailtype1=substring&emailtype2=substring&field0-0-0=noop&keywords=&keywords_type=allwords&longdesc=&longdesc_type=allwordssubstr&product=Mylyn&query_format=advanced&resolution=FIXED&short_desc=&short_desc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&type0-0-0=noop&value0-0-0=&votes=&order=bug_id&query_based_on=

Comment 1

[Steffen Pingel]

Query for the report:

https://bugs.eclipse.org/bugs/report.cgi?x_axis_field=&y_axis_field=assigned_to&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&classification=Tools&product=Mylyn&longdesc_type=allwordssubstr&longdesc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&resolution=FIXED&emailtype1=substring&email1=&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=2008-07-01&chfieldto=Now&chfield=resolution&chfieldvalue=&format=table&action=wrap&field0-0-0=noop&type0-0-0=noop&value0-0-0=

Actual Result:
https://bugs.eclipse.org/bugs/buglist.cgi?action=wrap&bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&chfield=resolution&chfieldfrom=2008-07-01&chfieldto=Now&chfieldvalue=&classification=Tools&email1=&email2=&emailtype1=substring&emailtype2=substring&field0-0-0=noop&keywords=&keywords_type=allwords&longdesc=&longdesc_type=allwordssubstr&product=Mylyn&resolution=FIXED&short_desc=&short_desc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&type0-0-0=noop&value0-0-0=&votes=&=&assigned_to=mylyn-inbox

Expected Result:
https://bugs.eclipse.org/bugs/buglist.cgi?bug_file_loc=&bug_file_loc_type=allwordssubstr&bug_id=&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&bugidtype=include&chfield=resolution&chfieldfrom=2008-07-01&chfieldto=Now&chfieldvalue=&classification=Tools&email1=mylyn-inbox&email2=&emailassigned_to1=1&emailtype1=substring&emailtype2=substring&field0-0-0=noop&keywords=&keywords_type=allwords&longdesc=&longdesc_type=allwordssubstr&product=Mylyn&query_format=advanced&resolution=FIXED&short_desc=&short_desc_type=allwordssubstr&status_whiteboard=&status_whiteboard_type=allwordssubstr&type0-0-0=noop&value0-0-0=&votes=&order=bug_id&query_based_on=

Comment 2

[Frédéric Buclin]

The problem comes from the fact that logged out users don't have the full assignee login name displayed, and so all the links in tabular reports are broken as assigned_to expect to get a complete login name. I can reproduce the problem with Bugzilla 3.5.

Comment 3

[Max Kanat-Alexander]

No, not a blocker for 3.4.3, but certainly something that should be fixed. It's easy enough to work around by logging in.

Probably the solution is to make the search "starts with" or "contains regexp ^\Qblah\E" for logged-out users.

Comment 4

[Frédéric Buclin]

Bugzilla 3.4 is now restricted to security bugs. We will retarget this bug (to 3.6 or later) when it's fixed.

Comment 5

[Frédéric Buclin]

(In reply to comment #3)
> Probably the solution is to make the search "starts with" or "contains regexp
> ^\Qblah\E" for logged-out users.

As this solution is not optimal as you can have many people with the same first part of the email address (e.g. bugzilla@ is very common), we could also decide to not display the links at all if a user field is involved and the user is logged out.

Comment 6

[Frédéric Buclin]

Thinking about it again, a way to fix this problem would be to use the user ID instead of the login name. I guess this would require some work in the Search.pm area, but this is doable.