DbHandle)) { // SQL $sql="-- references select year, '' || decode(reference_type, 'Journal Article', '' || Author || ', ' || Year ||':
' || Title || '. ' || Secondary_Title || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', 'Book Section', '' || Author || ', ' || Year ||':
' || Title || '. ' || 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || publisher || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', 'Book', '' || Author || ', ' || Year ||':
' || Title || '. ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || decode(secondary_title,null,'',Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || publisher || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', 'Conference Proceedings', '' || Author || ', ' || Year ||':
' || Title || '. ' || decode(secondary_title, null, '', 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(date_conference,null,'',date_conference || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(publisher,null,'', publisher ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', 'Thesis', '' || Author || ', ' || Year ||':
' || Title || '. ' || decode(secondary_title,null,Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(date_conference,null,'',date_conference || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(publisher,null,'', publisher ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', '' || Author || ', ' || Year ||':
' || Title || '. ' || decode(secondary_author, null, '', 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(date_conference,null,'',date_conference || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(publisher,null,'', publisher ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.') || decode(url, null, '', ' [ >>> ] ') || decode(doi, null, '', ' [' || doi || '] ') || decode(abstract,null,'', ' [abstract] ') as ref from waldner.lwf_publications where year is not null \n"; // Query-Parameter if (isset($messnetz)) $sql=$sql." and upper(label) like '%".strtoupper($messnetz)."%'\n"; if (isset($site)) if ($site=="All") {} else {$sql=$sql." and (lower(custom_7) like '%".strtolower($site)."%' or upper(custom_7) like '%".strtoupper($site)."%' or upper(custom_7) like '%".strtoupper($site)."%')\n";} if (isset($thema)) $sql=$sql." and upper(custom_4) like '%".strtoupper($thema)."%'\n"; $sql=$sql." order by year desc, author"; $Db->HtmlReport($sql,"h4"); } ?>