Changeset 2483


Ignore:
Timestamp:
Aug 3, 2006, 8:35:49 AM (16 years ago)
Author:
Nicklas Nordborg
Message:

Fixes #309: count spots in bioassayset

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/src/core/net/sf/basedb/core/BioAssaySet.java

    r2382 r2483  
    990990    query.join(
    991991      new DynamicJoin(
    992         getVirtualDb(), JoinType.INNER, VirtualTable.POSITION,
     992        getVirtualDb(), JoinType.LEFT, VirtualTable.POSITION,
    993993        VirtualColumn.CUBE, VirtualColumn.POSITION
    994994      )
     
    10091009      SELECT COUNT(*) AS spotCount, COUNT(DISTINCT pos.reporter_id) AS reporterCount
    10101010      FROM Dynamic#PerSpot spt
    1011       JOIN Dynamic#PerPosition pos spt.cube = pos.cube AND spt.position = pos.position
     1011      LEFT JOIN Dynamic#PerPosition pos spt.cube = pos.cube AND spt.position = pos.position
    10121012      WHERE spt.cube = ? AND spt.layer = ?
    10131013    */
Note: See TracChangeset for help on using the changeset viewer.