Changes between Version 10 and Version 11 of AddStarMD_PV2

Timestamp:

Jun 6, 2014, 3:24:40 PM (12 years ago)

Author:

heather

Comment:

--

AddStarMD_PV2

@@ -91 +91 @@
 }}}
 
+ * slower query, to be used to find out if all the minis are done and with no faults:
 
+{{{
+ select minidvodbRun.minidvodb_name, minidvodbRun.state, minidvodbProcessed.fault,count(*) from minidvodbRun left join minidvodbProcessed using (minidvodb_id) left join addRun using (minidvodb_name)  where minidvodbRun.minidvodb_name like 'MD__.PV2.201406%' group by minidvodb_name;
+}}}
 === how to addstar part 2 (merge) ===