ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/COMP/DBS/Servers/JavaServer/test/queries.txt
Revision: 1.4
Committed: Thu Nov 20 16:58:08 2008 UTC (16 years, 6 months ago) by sekhri
Content type: text/plain
Branch: MAIN
Changes since 1.3: +7 -0 lines
Log Message: 
fixed site != abc problem reported by Valentin

File Contents

# User Rev Content
1 sekhri 1.1 find file where file.release=CMSSW_1_7_1
2     find file,file.status,file.type where procds.release=CMSSW_1_7_1
3     find file.id,lumi.id where procds.release=CMSSW_1_7_1
4     find file.name, file.createdate where run.number=35672 and run.moddate>2
5     find file,file.size,dataset where procds.name=Online and file.size>546294916
6     find file, lumi where dataset = /CalPrivateGlobal-default/Online/RAW
7     find lumi where dataset=/CalPrivateGlobal-default/Online/RAW and procds.release=CMSSW_1_7_1
8     find count(file) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM or run > 0
9     find file.release,file where dataset=/CalPrivateGlobal-default/Online/RAW and procds.release=CMSSW_1_7_1
10     find count(run) where run.number > 1 and run.number < 888800
11     find lumi.id,lumi.id,file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
12     find run where run.number>1 and run.number<100
13     find run.count where run.number > 1 and run.number < 100
14     find run.count where run > 1 and run < 100
15     find run.count where dataset=/CalPrivateGlobal-default/Online/RAW
16     find file,run,lumi where dataset=/GlobalMar08-Express/Online/RAW and file.type = STREAMER
17     find file, run,lumi where dataset like %Online%
18     find run,lumi where dataset like %Online%
19     find run,lumi,file where dataset like %Online%
20     find file.release where dataset=/CalPrivateGlobal-default/Online/RAW
21     find primds where primds.name like %test%
22     find dataset
23     find procds, procds.createdate
24     find primds
25     find procds.createby, run.modby
26     find file, procds.createby where file.modby like %sekhri% and dataset = /CalPrivateGlobal-default/Online/RAW
27     find file, procds.createby, file.modby, procds.createdate
28     find file where file.modby like %sekhri%
29     find procds.parent,procds.name,file,file.parent where procds.parent like %
30     find file where file.createby like %sekhri% or file.createby = abc
31     find file.parent,file where file.name = NEW_TEST0005
32     find lumi.id,file.id where dataset in (/CalPrivateGlobal-default/Online/RAW,/GlobalMar08-Express/Online/RAW)
33     find file,file.parent,run,dataset where file.parent like %NEW% or file.parent like %
34     find file.id,lumi.id,dataset where procds.release=CMSSW_1_7_1
35     find file.createby,file.modby,file.modby where file.createby like %sekhri% or file.modby like %sekhri% and file.createby like %sek%
36     find procds, procds.createdate,run,lumi.moddate where run.number in (1,2,3)
37     find run, run.numevents, run.numlss, run.starttime, run.endtime
38     find dataset where site = T1_FR_CCIN2P3
39     find file where run > 1 and run < 1000000
40     find procds.status where dataset = /CalPrivateGlobal-default/Online/RAW
41     find procds, procds.era, procds.tag
42     find procds, procds.era, procds.tag where dataset = /CalPrivateGlobal-default/Online/RAW
43     find site
44     find run, run.createdate where run.createdate > 2008-05-01 12:05:12 order by run, run.createdate
45     find file.parent,file.parent, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
46     find procds.parent,procds.name where procds.name like %Test% or procds.parent like %
47     find file.release where dataset=/CalPrivateGlobal-default/Online/RAW or dataset=/abc/Online/RAW
48     find file where dq = TIB_DCS=UNKNOWN&Tracker_Global=GOOD&TIB_Local=GOOD
49     find dataset, procds.createdate where dq = Tracker_Global=GOOD&TIB_Local=GOOD
50     find file,lumi,dataset where dq = Tracker_Global=GOOD&TIB_Local=GOOD&TIB_DCS=UNKNOWN or file.size > 1000
51     find file, file.tier
52     find file where file.tier = GEN
53     find run where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
54     find block , dataset where site = srm-disk.pic.es
55     find procds,file where procds.tier = GEN
56     find procds,file,file.tier where dataset like *
57     find file where site in ( srm-disk.pic.es, castorsrm.cr)
58     find procds,file where procds.tier in (GEN,SIM,RAW)
59     find ads,file
60     find release where file like *
61     find release where dataset like *
62     find release where dataset like * or file like *
63     find release where procds like * or file like *
64     find file.release where procds like * or file like *
65     find file,run,lumi where ads.name = MyAds
66     find lumi,ads
67     find ads, ads.type, ads.status, ads.createby
68     find file,lumi where ads.name = /TestPrimary_001_20080501_10h06m06s/TestProcessed_20080501_10h06m06s/GEN-SIM/TestAnalysisDSDef_005_20080501_10h06m06s
69     find ads, ads.dataset
70     find file,run,lumi where ads.name in ( MyAds, Myades )
71     find ads,file where dataset = /TestPrimary_001_20080501_10h06m06s/TestProcessed_20080501_10h06m06s/GEN-SIM
72     find ads, ads.def, file
73     find dataset.parent where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.createdate > 0
74     find lumi.startevnum, lumi.endevnum, lumi.id where file.createdate > 0
75     find file where lumi.evnum = 150
76     find lumi, dataset where lumi.evnum = 150
77     find file, file.createdate where file.createdate = 2007-04-20
78     find file, file.createdate where file.createdate = 2007-04-20 11:27:21 CDT or file.moddate > 2008
79     find file, file.createdate where file.createdate = 2007-04-20 11:27:21
80     find run, run.createdate where run.createdate = 2008-05-01 12:05:12 order by run
81     find run, run.createdate where run.createdate = 2008-05-01 12:05
82     find run, run.createdate where run.createdate = 2008-05-01 12
83     find run, run.createdate where run.createdate = 2008-05-01
84     find run, run.createdate where run.createdate = 2008
85     find run, run.createdate where run.createdate < 2008
86     find run, run.createdate where run.createdate > 2008
87     find run,file order by file
88     find run,file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM order by file.createdate
89     find ilumi where run > 0
90     find ilumi where run > 0
91     find ilumi, file.name
92     find run where primds = test_primary_001
93     find count(file), dataset where dataset like *
94     find run, ilumi, file
95     find sum(file.size), dataset where file.size > 0
96     find file, dataset where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
97     find file where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
98     find dataset where release = test_Ver1_eaf67699-b539-487d-8713-07df617379db
99     find run, ilumi, file where run in (1,2,3)
100     find ilumi, file where run in (1,2,3)
101     find ilumi, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
102     find ilumi, file where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM order by file
103     find ilumi, dataset where run > 0
104     find ilumi
105     find block
106     find block, block.size, block.createdate, block.moddate, block.createby, block.modby where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
107     find block.size, block.createdate, block.moddate, block.createby, block.modby where block = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO#01123fd3-5486-41fe-8b90-7dbb8fbe69b8
108     find block.count where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
109     find count(block) where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
110     find run.count where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
111     find lumi, lumi.starttime, lumi.endtime
112     find dataset.id, dataset.status, dataset.era, dataset.tag, dataset.createdate, dataset.moddate, dataset.createby, dataset.modby where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
113     find dataset.release, dataset.era, dataset.tag, dataset.status, dataset.createdate, dataset.moddate, dataset.createby, dataset.modby where dataset = /CSA07Muon/Skim-zToTauTau_MuTau-Tier0-A1-Chowder/USER
114     find file.child, file where file = NEW_TEST0002
115     find file where file.child = NEW_TEST0005
116     find sum(file.size) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.size > 0
117     find sum(run.numevents) where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM and file.size > 0
118     find sum(block.size) where dataset = /CSA07Muon/CMSSW_1_6_7-CSA07-Tier0-A1-Chowder/RECO
119     find phygrp
120     find phygrp where dataset = /test_primary_001/TestProcessedDS002/GEN-SIM
121     find dataset where phygrp like *BPositive
122     find dataset where phygrp in (BPositive,Any )
123     find file where phygrp in (BPositive,Any )
124     find file,run where phygrp in (BPositive,Any )
125     find phygrp.id, phygrp.name
126     find phygrp, phygrp.id, phygrp.createdate , phygrp.moddate, phygrp.createby, phygrp.modby
127     find dataset where pset = associatorL25PixelTauIsolated.coneSize>0&associatorL25SingleTau.coneSize>0&associatorL25SingleTau.jets<>a
128     find file, lumi where pset = associatorL25PixelTauIsolated.coneSize>0
129     find dataset where site = T1_FR_CCIN2P3
130     find dataset where site in ( T1_FR_CCIN2P3, T1_TW_ASGC)
131     find dataset where site like *A*
132     find dataset where site like castorsrm.cr.cnaf*
133     find dataset where site = castorsrm.cr.cnaf.infn.it
134     find dataset where site = test_seM_ee563854-0ed2-4010-82ba-e94e7868cbff
135     find dataset, site
136     find site
137     find dataset where run between 51437 and 51450 or run between 0 and 30000
138     find dataset where dataset.id between 1 and 2 or dataset like *on*
139 sekhri 1.2 find algo.id, algo.family, algo.exe,algo.hash, algo.content where dataset like *on*
140     find dataset where algo.exe = *CMS* or algo.family=*C*
141     find file where algo.exe = *CMS* or algo.family=*C*
142     find algo, algo.createby, algo.modby, algo.moddate where dataset like *on*
143 sekhri 1.3 find datatype
144     find dataset where datatype = cosmic
145     find file where datatype = cosmic
146     find datatype where dataset = *on*
147     find datatype, datatype.id, datatype.createdate, datatype.moddate, datatype.createby, datatype.modby where dataset = *on*
148 sekhri 1.4 find dataset where site != caf.cern.ch
149     find dataset where site = caf.cern.ch
150     find dataset where site = T1_CH_CERN
151     find dataset where site != T1_CH_CERN
152     find dataset where site in (T1_CH_CERN , T0_CH_CERN)
153    
154