Hello helix,

Thanks for your response. I would like to know if how can I make our repository as an authority file, specifically I want to use SampleAuthority plugin to lookup to existing names with authority. If it's not that complicated, where would I put your suggested sql query in SampleAuthority.java if ever I want to use it as the basis for my name authority plugin?

Thanks in advance and regards,
Elvi

On Thu, Jan 3, 2013 at 10:57 PM, helix84 <helix84@centrum.sk> wrote:
On Fri, Dec 28, 2012 at 7:40 AM, Nemiz, Elvi <esnemiz@seafdec.org.ph> 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 metadatavalue
WHERE authority IS NOT NULL

or if you want to leave out duplicate authors, do this:
SELECT DISTINCT authority, confidence, text_value FROM metadatavalue
WHERE authority IS NOT NULL


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette