On Fri, Dec 28, 2012 at 7:40 AM, Nemiz, Elvi <[email protected]> wrote:
> Previously I used LCName authority plugin to lookup and to make the
authors
> authority-controlled. I edited some authority keys since it shows up in
> sidebar facets and browse by authors pages. If I don't want to use LCName
> plugin anymore, and instead want to lookup to existing authors that have
> already an authority key, how can I achieve this? Did anybody somehow
> modified the existing SampleAuthority plugin to get it to lookup existing
> values from the DSpace database? Would it still be possible if I'm using
> SolrBrowseDAO in my Browse Configuration instead of the default? I'm using
> dspace 3.0, xmlui with discovery enabled. Thanks in advance.
Hi Elvi,
you could do this:
SELECT * FROM metadatavalueWHERE authority IS NOT NULL
or if you want to leave out duplicate authors, do this:
SELECT DISTINCT authority, confidence, text_value FROM
metadatavalueWHERE authority IS NOT NULL
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
