select variable_id
from logger_entries le,
acs_objects ao
where ao.creation_date = (select max(ao.creation_date)
from logger_entries le,
acs_objects ao
where ao.object_id = le.entry_id
[ad_decode $project_clause "" "" "and $project_clause"]
)
and ao.object_id = le.entry_id
[ad_decode $project_clause "" "" "and $project_clause"]
select lp.name as label,
lp.project_id as project_id,
(select count(*) from logger_entries e where e.project_id = lp.project_id and variable_id = :variable_id) as count
from logger_projects lp,
logger_project_pkg_map lppm
where lp.project_id = lppm.project_id
and lppm.package_id = :package_id
order by lp.name
select lv.name || ' (' || lv.unit || ')' as name,
lv.variable_id as unique_id
from logger_variables lv,
logger_projects lp,
logger_project_var_map lpvm
where lp.project_id = lpvm.project_id
and lv.variable_id = lpvm.variable_id
and exists (select 1
from logger_project_pkg_map
where project_id = lp.project_id
and package_id = :package_id
)
group by lv.variable_id, lv.name, lv.unit
select submitter.first_names || ' ' || submitter.last_name as label,
submitter.user_id as user_id
from cc_users submitter,
logger_entries le,
acs_objects ao
where ao.object_id = le.entry_id
and submitter.user_id = ao.creation_user
and exists (select 1
from logger_project_pkg_map
where project_id = le.project_id
and package_id = :package_id)
group by submitter.user_id, submitter.first_names, submitter.last_name
select lpe.projection_id as unique_id,
lpe.name,
to_char(lpe.start_time, 'YYYY-MM-DD') as start_date,
to_char(lpe.end_time, 'YYYY-MM-DD') as end_date
from logger_projections lpe
where lpe.project_id = :selected_project_id
and lpe.variable_id = :selected_variable_id