Menu

#1342 Cleanup report to find CHAPBOOKs with multiple fiction titles

Approved
closed
None
5
2020-05-09
2020-04-24
Ahasuerus
No

Create a new cleanup report to find CHAPBOOKs with multiple fiction titles. The query logic should be:

select distinct p.pub_id from pubs p where pub_ctype='CHAPBOOK' and
(select count(t.title_id) from pub_content pc, titles t
where p.pub_id = pc.pub_id and pc.title_id = t.title_id
and t.title_ttype in ('SHORTFICTION', 'POEM', 'SERIAL')) > 1

Discussion

  • Ahasuerus

    Ahasuerus - 2020-04-25
    • status: open --> closed
    • assigned_to: Ahasuerus
     
  • Ahasuerus

    Ahasuerus - 2020-04-25

    Implemented in:

    edit/cleanup_lib.py
    edit/cleanup_report.py
    nightly/nightly_job.py
    

    Installed in SVN 517 on 2020-04-25. Closing the FR.

     
  • Ahasuerus

    Ahasuerus - 2020-05-09

    Part 2 - Let moderators ignore records. Implemented in edit/cleanup_report.py, installed in SVN 525 on 2020-05-09. Keeping the FR closed.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB