64946 - Query based on who attached a file

Status: RESOLVED DUPLICATE of bug 333040

(Bugzilla :: Query/Bug List, enhancement, P3)

Description

[Jacob Steenhagen]

As requested in #mozwebtools, it would be nice if there was a way to find all
bugs where user x created an attachment.   My thoughts on this would be to put
this in the "Email 1/2" section as another checkbox.  The actual query should be
able to be done the same way as the one for "Added Comment".

I will try to work on this when I get a chance, but if somebody else out there
wants to do it, feel free as I'm a bit intimidated by the code in buglist.cgi
(still quite new to SQL so formulating queries is mostly beyond me... esp. one
as advanced as what buglist.cgi does).

Comment 1

[Jesse Ruderman]

It's possible to approximate this query by searching for comments which 
include "created an attachment" in the text.

Comment 2

[Jacob Steenhagen]

Yes and No.

If you search for "user x added a comment" and "comment contains 'created an
attachment' you'll get all bugs that have attachments and are comment on by user
x... in addition to all bugs that user x added an attachment... follow?

The patch to record who was adding the attachment in the attachments table was
added 6/22/99 (which was in the 2.5 days) so the field should be populated.

Comment 3

[Jacob Steenhagen]

Attachment: Failed Attempt at making this work

Comment 4

[Jacob Steenhagen]

OK, I tried to make a patch for this, but I don't now enough about SQL 
statements to do it.  Basically, what I attempted was to copy and modify the 
stuff for "Added Comment".  What I ran into was that when the "Added 
Attachment" box was checked, only bugs with attachments would get returned by 
the SQL statement.  It didn't necessarily matter who attachted the file, just 
that the bug had an attachment.  I suspect it's related to the JOIN, but no 
matter what I did with it, I couldn't get it to work.

I attached my attempt to this bug in case somebody wants to try to make it work.

Comment 5

[Jacob Steenhagen]

*** Bug 82371 has been marked as a duplicate of this bug. ***

Comment 6

[Asa Dotzler [:asa]]

what's wrong with the boolean search "Attachment Description" "changed by"
"[e-mail]"? It seems to return all the bugs where I attached something.

Comment 7

[[e-mail]]

*** Bug 90115 has been marked as a duplicate of this bug. ***

Comment 8

[Asa Dotzler [:asa]]

so is my method of running this query broken or can we resolve this as WorksForMe?

Comment 9

[timeless]

I suspect it would be worksforme (except that it's not intuitive, we should 
probably hint somewhere how to do it). but myk's stuff changes how patches are 
handled will that affect this?

Comment 10

[[e-mail]]

I suspect that the correct resolution should be INVALID.

However this area of the form is extremely poorly documented, for instance the
"Attachment is patch" value should only be 0 or 1. Mind you, other parts of the
documentation are out of date as well. While I mention it, does the list of
keywords/products/components needed to be embedded in the documentation?

Comment 11

[Jacob Steenhagen]

-> New Bugzilla Product

Comment 12

[Andreas Franke (gone)]

Reassigning to default owner.

Comment 13

[Asa Dotzler [:asa]]

Attachment description | Changed by | <user> no longer works for this since it
is possible for others to change the attachment description in the Patch
Tracker. I guess we need a specific query "Created Attachment" in the email
section just like the original report requested. 

Comment 14

[timeless]

nope, use "attachment data" /changed by/ [attacher].

Comment 15

[Denis Roy]

A brand-new 3.0 install shows Attachment Creator in the Advanced search... You can also see this on b.m.o.

Recommend someone closes this as FIXED.