Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.

Changes between Initial Version and Version 1 of Ticket #11009, comment 8


Ignore:
Timestamp:
05/30/13 11:43:50 (11 years ago)
Author:
atarkowska
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11009, comment 8

    initial v1  
    33 
    44 
    5 omero=# select plate.id, plate.name from plate, experimenter [[BR]] 
    6 omero-# where plate.owner_id = experimenter.id [[BR]] 
    7 omero-# and experimenter.omename = 'user-7';[[BR]] 
    8  
    9  
    10 [[BR]] id |                                                         name                                                          
    11 [[BR]]----+---------------------------------------------------------------------------------------------------------------------- 
    12 [[BR]] 53 | /Users/ola/OMERO/images/perkinelmer-operetta/P004-CC Edu-pHH3__2009-02-03T17_36_29-Measurement1/Images/Index.idx.xml 
    13 [[BR]] 52 | /Users/ola/OMERO/images/ome-xml/testImportPlate/testImportPlateMultiplePlateAcquisitions1508.ome 
    14 [[BR]]  7 | /Volumes/ome/data_repo/test_images_good/cellworx/hms/plate1/plate1.HTD 
    15 [[BR]]  5 | /Volumes/ome/data_repo/test_images_good/cellworx/hms/plate1/TIFF/plate1.HTD 
    16 [[BR]]  4 | /Volumes/ome/data_repo/test_images_good/cellomics/MFGTMP_081128200001_A02f239d1.C01 
    17 [[BR]]  3 | /Volumes/ome/data_repo/test_images_good/cellomics/MFGTMP_081222130005_E07f00d0.C01 
     5[[BR]]omero=# select plate.id, plate.name, plate.permissions, experimentergroup.id, experimentergroup.name  
     6[[BR]]from plate, experimenter, experimentergroup 
     7[[BR]]omero-# where plate.owner_id = experimenter.id  
     8[[BR]]omero-# and plate.group_id=experimentergroup.id  
     9[[BR]]and experimenter.omename = 'user-7'; 
     10[[BR]] id |                                                         name                                                         | permissions | id |   name     
     11[[BR]]----+----------------------------------------------------------------------------------------------------------------------+-------------+----+----------- 
     12[[BR]] 53 | /Users/ola/OMERO/images/perkinelmer-operetta/P004-CC Edu-pHH3__2009-02-03T17_36_29-Measurement1/Images/Index.idx.xml |        -120 |  9 | private-1 
     13[[BR]] 52 | /Users/ola/OMERO/images/ome-xml/testImportPlate/testImportPlateMultiplePlateAcquisitions1508.ome                     |        -120 |  9 | private-1 
     14[[BR]]  7 | /Volumes/ome/data_repo/test_images_good/cellworx/hms/plate1/plate1.HTD                                               |        -120 |  9 | private-1 
     15[[BR]]  5 | /Volumes/ome/data_repo/test_images_good/cellworx/hms/plate1/TIFF/plate1.HTD                                          |        -120 |  9 | private-1 
     16[[BR]]  4 | /Volumes/ome/data_repo/test_images_good/cellomics/MFGTMP_081128200001_A02f239d1.C01                                  |        -120 |  9 | private-1 
     17[[BR]]  3 | /Volumes/ome/data_repo/test_images_good/cellomics/MFGTMP_081222130005_E07f00d0.C01                                   |        -120 |  9 | private-1 

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.11709 sec.)

© 2000-2014 University of Dundee & Open Microscopy Environment. Creative Commons Attribution 3.0 Unported License
OME source code is available under the GNU General public license or through commercial license from Glencoe Software

We're Hiring!