Project

General

Profile

bug #7828

Remove date published from journals in E+M

Added by Andreas Müller 3 months ago. Updated 2 months ago.

Status:
In Progress
Priority:
New
Category:
data
Target version:
Start date:
10/15/2018
Due date:
% Done:

0%

Severity:
normal
Found in Version:
Tags:

Description

1200 journals from the initial import in 2004 do have a date published. Journals generally should not have a date published.

This is critical for the deduplication as the date published is handled as difference. Also in general it should be cleaned.


SELECT  ref.*
FROM Reference ref 
WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' ;

SELECT DISTINCT subref.title, subRef.id, subRef.*, ref.*
FROM Reference ref INNER JOIN Reference subRef ON subRef.inReference_id = ref.id
WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' AND subRef.datePublished_start IS NULL

Also journals should not have authors.


Related issues

Related to Edit - bug #7915: Remove date published from journals and print series Closed 11/20/2018
Related to Edit - bug #7913: Remove authorship from IJournal and IPrintSeries Closed 11/20/2018

History

#1 Updated by Andreas Müller 2 months ago

  • Subject changed from Remove date published from journals to Remove date published from journals in E+M

#2 Updated by Andreas Müller 2 months ago

  • Duplicates bug #7839: IJournal should not have author, date published etc. added

#3 Updated by Andreas Müller 2 months ago

  • Status changed from New to Duplicate

#4 Updated by Andreas Müller 2 months ago

  • Duplicates deleted (bug #7839: IJournal should not have author, date published etc.)

#5 Updated by Andreas Müller 2 months ago

  • Status changed from Duplicate to In Progress

#6 Updated by Andreas Müller 2 months ago

  • Related to bug #7915: Remove date published from journals and print series added

#7 Updated by Andreas Müller 2 months ago

  • Related to bug #7913: Remove authorship from IJournal and IPrintSeries added

#8 Updated by Andreas Müller 2 months ago

  • Description updated (diff)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)