select 1 from bt_versions where version_id = :version_id
insert into bt_versions (
version_id,
project_id,
version_name,
description,
anticipated_freeze_date,
anticipated_release_date,
actual_freeze_date,
actual_release_date,
maintainer,
supported_platforms,
assignable_p
) values (
:version_id,
:package_id,
:version_name,
:description ,
$anticipated_freeze_date,
$anticipated_release_date,
$actual_freeze_date,
$actual_release_date,
:maintainer,
:supported_platforms,
:assignable_p
)
update bt_versions
set version_id = :version_id,
project_id = :package_id,
version_name = :version_name,
description = :description,
anticipated_freeze_date = $anticipated_freeze_date,
anticipated_release_date = $anticipated_release_date,
actual_freeze_date = $actual_freeze_date,
actual_release_date = $actual_release_date,
maintainer = :maintainer,
supported_platforms = :supported_platforms,
assignable_p = :assignable_p
where version_id = :version_id
select version_id,
version_name,
description,
to_char(anticipated_freeze_date, 'YYYY MM DD HH24 MI') as anticipated_freeze_date,
to_char(anticipated_release_date, 'YYYY MM DD HH24 MI') as anticipated_release_date,
to_char(actual_freeze_date, 'YYYY MM DD HH24 MI') as actual_freeze_date,
to_char(actual_release_date, 'YYYY MM DD HH24 MI') as actual_release_date,
maintainer,
supported_platforms,
assignable_p
from bt_versions
where version_id = :version_id
select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
from cc_users u
where upper(coalesce(u.first_names || ' ', '') ||
coalesce(u.last_name || ' ', '') ||
u.email || ' ' ||
coalesce(u.screen_name, '')) like upper('%'||:value||'%')
order by name