Product: E-Notebook Enterprise
Need a database query to get the list of experiments with status in E-Notebook
SELECT collection_name "Notebook-ExpID",
'<collection key="'
|| cs.collection_key
|| '"/>' "Notebook-ExpID_link",
c.name,
creation_date - (creation_tzb / 1440.0) "Creation Date",
creation_tzb,
transition_type_name "Last Transition",
transition_date - (transition_tzb / 1440.0) "Transition
Date",
transition_tzb
FROM ENV_collection_states cs,
ENV_collection_creation_dates ccd,
ELN_collections c,
ELN_states s,
eln_collections t,
ELN_People pl
WHERE
cs.collection_key
= c.section_set_key
AND
ccd.collection_key
= c.section_set_key
AND
cs.state_key
= s.primary_key
AND (s.existing_annotation_level <> 0
OR
s.new_annotation_level
<> 0)
AND
c.section_set_key
<> c.collection_type_key
AND
c.is_active
= 1
AND
c.is_template
= 0
and c.collection_type_key= t.section_set_key
and t.name like '%xperiment%'
AND
pl.primary_key
= c.owner_key
ORDER BY lower(collection_name)