Jump to content
Wiki Home
EPrints Home
Bazaar
Files
Main menu
Main menu
move to sidebar
hide
Navigation
Front Page
EPrints 3 Manual
EPrints Training Course
EPrints Glossary
Installing EPrints
How-to Configure EPrints
EPrints 3.2+ API
EPrints 3 Reference
EPrints Plugins
Wiki
All categories
Recent changes
Main Page
Help
EPrints Documentation
Search
Search
Appearance
Log in
Request account
Personal tools
Log in
Request account
Pages for logged out editors
learn more
Contributions
Talk
Editing
Adding an Institution Field to authors
(section)
Page
Discussion
British English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Special pages
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===Altering the lookup script=== The name fields come with an auto-completer, which (obviously) doesn't know about your new field. <code> use EPrints; use strict; my $session = EPrints::Session->new(); # security? my $content = "text/xml"; $session->send_http_header( content_type=>$content ); my $family = $session->param( "_name_family" ); my $given = $session->param( "_name_given" ); my $id = $session->param( "_id" ); <span style="color:red">my $institution = $session->param( "_institution" ); </span> my $database = $session->get_database; my $dataset = $session->get_repository->get_dataset( "eprint" ); my $name_field = $dataset->get_field( "creators_name" ); my $id_field = $dataset->get_field( "creators_id" ); <span style="color:red">my $institution_field = $dataset->get_field( "creators_institution" );</span> my @fields = ($name_field->get_sql_names, $id_field->get_sql_names, $institution_field->get_sql_names); my $Q_table = $database->quote_identifier($dataset->get_sql_table_name); my $Q_name_table = $database->quote_identifier($dataset->get_sql_sub_table_name($name_field)); my $Q_id_table = $database->quote_identifier($dataset->get_sql_sub_table_name($id_field)); <span style="color:red">my $Q_institution_table = $database->quote_identifier($dataset->get_sql_sub_table_name($institution_field));</span> my $Q_eprintid = $database->quote_identifier( "eprintid" ); my $Q_pos = $database->quote_identifier( "pos" ); my $Q_num_matches = $database->quote_identifier( "num_matches" ); my $Q_eprint_status = $database->quote_identifier( "eprint_status" ); my $sql = "SELECT COUNT($Q_table.$Q_eprintid) AS $Q_num_matches,". join(",", map { $database->quote_identifier($_) } @fields). " FROM $Q_table". " LEFT JOIN $Q_name_table". " ON $Q_table.$Q_eprintid=$Q_name_table.$Q_eprintid". " LEFT JOIN $Q_id_table". " ON $Q_name_table.$Q_eprintid=$Q_id_table.$Q_eprintid ". " AND $Q_name_table.$Q_pos=$Q_id_table.$Q_pos ". <span style="color:red">" LEFT JOIN $Q_institution_table". " ON $Q_institution_table.$Q_pos = $Q_id_table.$Q_pos". " AND $Q_institution_table.$Q_eprintid = $Q_id_table.$Q_eprintid ".</span> " WHERE ". " $Q_table.$Q_eprint_status=".$database->quote_value( "archive" ); if( EPrints::Utils::is_set( $family ) ) { $sql .= " AND ".$database->quote_identifier("creators_name_family") ." ILIKE " .$database->quote_value( '%' . EPrints::Database::prep_like_value($family).'%'); } if( EPrints::Utils::is_set( $given ) ) { $sql .= " AND ".$database->quote_identifier("creators_name_given") ." ILIKE " .$database->quote_value( '%' . EPrints::Database::prep_like_value($given).'%'); } if( EPrints::Utils::is_set( $id ) ) { $sql .= " AND ".$database->quote_identifier("creators_id") ." ILIKE " .$database->quote_value( '%' . EPrints::Database::prep_like_value($id).'%'); } $sql .= "GROUP BY ".join(",",map { $database->quote_identifier($_) } @fields) . " ORDER BY $Q_num_matches DESC," . $database->quote_identifier("creators_name_family").",". $database->quote_identifier("creators_name_given"); my @rows; my $sth = $session->get_database->prepare_select( $sql, 'limit' => 40 ); $session->get_database->execute( $sth , $sql ); while( my @row = $sth->fetchrow_array ) { my $cnt = shift @row; my $name = $name_field->value_from_sql_row( $session, \@row ); my $id = $id_field->value_from_sql_row( $session, \@row ); <span style="color:red">my $institution = $institution_field->value_from_sql_row( $session, \@row );</span> my $item = {}; push @rows, $item; my $frag = $session->make_doc_fragment; $frag->appendChild( $name_field->render_single_value( $session, $name ) ); if( EPrints::Utils::is_set( $id ) ) { $frag->appendChild( $session->make_text( " " ) ); $frag->appendChild( $id_field->render_single_value( $session, $id ) ); } my $small = $session->make_element( "small" ); $frag->appendChild( $small ); <span style="color:red">if( EPrints::Utils::is_set( $institution ) ) { $small->appendChild( $session->make_text( " [" ) ); $small->appendChild( $id_field->render_single_value( $session, $institution ) ); $small->appendChild( $session->make_text( "] " ) ); }</span> $small->appendChild( $session->make_text( " (author of ".$cnt." item".($cnt>1?"s":"")." in this repository)" ) ); $item->{xhtml} = $frag; $item->{values} = [ "for:value:relative:_name_family" => $name->{family}, "for:value:relative:_name_given" => $name->{given}, "for:value:relative:_name_honourific" => $name->{honourific}, "for:value:relative:_name_lineage" => $name->{lineage}, "for:value:relative:_id" => $id, <span style="color:red">"for:value:relative:_institution" => $institution,</span> ]; } $sth->finish(); my $ul = EPrints::Extras::render_lookup_list( $session, \@rows ); $session->send_http_header( content_type => "text/xml; charset=UTF-8" ); binmode(STDOUT,":utf8"); print <<END; <?xml version="1.0" encoding="UTF-8" ?> END print EPrints::XML::to_string( $ul, "utf-8", 1 ); EPrints::XML::dispose( $ul ); $session->terminate; </code>
Summary:
Please note that all contributions to EPrints Documentation may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
EPrints Documentation:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)