Changeset 5868


Ignore:
Timestamp:
Mar 18, 2020, 12:47:33 PM (21 months ago)
Author:
Nicklas Nordborg
Message:

References #1231: Add support for sequencing with NovaSeq?

Implemented a counter for the number of libraries that are waiting for external sequencing.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/net.sf.basedb.reggie/trunk/src/net/sf/basedb/reggie/counter/CounterService.java

    r5845 r5868  
    10611061    json.put("libraries-all-aligned", query.count(dc));
    10621062    // ---
    1063    
     1063
     1064    // Libraries (RNAseq) waiting for external sequencing
     1065    query = Extract.getQuery();
     1066    Subtype.LIBRARY.addFilter(dc, query);
     1067    Pipeline.RNA_SEQ.addFilter(dc, query);
     1068    query.setIncludes(Reggie.INCLUDE_IN_CURRENT_PROJECT);
     1069    // Filter for empty creation date
     1070    query.join(Hql.innerJoin("creationEvent", "ce"));
     1071    query.restrict(Restrictions.eq(Hql.property("ce", "eventDate"), null));
     1072    // Must be on "External library plate"
     1073    query.join(Hql.innerJoin("bioWell", "bw"));
     1074    query.join(Hql.innerJoin("bw", "bioPlate", "bp"));
     1075    BioplateType.EXTERNAL_LIBRARY.addFilter(dc, query, "bp", true);
     1076    json.put("external-libs-not-sequenced", query.count(dc));
     1077
    10641078  }
    10651079 
Note: See TracChangeset for help on using the changeset viewer.