#974: Your Comments
------------------------+------------------------
Reporter: skaplun | Owner: jcaffaro
Type: enhancement | Status: new
Priority: major | Component: WebComment
Version: | Keywords: usability
------------------------+------------------------
From a real request we received on CDS:
[...]
I would like to search for all CDS records to which I have posted a
'comment' (a.k.a discussion tab). In the advanced search it appears I
can't do that. Is there a way to be able to do that?
[...]
This can be implemented in a couple of ways:
* can be as part of the #852 ticket, by making comments (and their
metadata such a commenter and comment date) indexable.
* by providing a your comment functionality in the account pages of the
user, where the user can then have an overview of the record he commented
What would have really worked for the user case is the latter solution.
As a workaround this can be computed by hand via SQL with:
{{{
#!python
from invenio.dbquery import run_sql
from invenio.intbitset import intbitset
from invenio.config import CFG_SITE_URL
email = "[email protected]"
uid = run_sql("SELECT id FROM user WHERE mail=%s", (email, ))[0][0]
for recid in intbitset(run_sql("SELECT id_bibrec FROM cmtRECORDCOMMENT
WHERE id_user=%s", (uid, ))):
print "%s/record/%s" % (CFG_SITE_URL, recid)
}}}
--
Ticket URL: <http://invenio-software.org/ticket/974>
Invenio <http://invenio-software.org>
