Install guide

To turn on the display of the SQL in WOW, set the WOW_SHOW_SQL environmental
variable to 1 (on) in $OWHOME/WebApps/conf/wow.env. The default is 0 (off):
# Show SQL in QC/QA module: 1=on 0=off
WOW_SHOW_SQL=1; export WOW_SHOW_SQL
An example QC/QA query is provided below:
REM title: Wells with 0 or null total depth
REM dtype: well
REM description: This query checks for wells with TD.
select
well_id ID,
well_uwi "UWI",
well_name_free "Common Well Name",
final_td "TD"
from
well_master
where
final_td is null
or
final_td = 0
order by
well_name_free
/
Important note: Optionally, individual lists of QC/QA queries will be picked up from a
user's $HOME/sqlscripts directory, if present. This option will only work if level C
security is configured. Users should prefix query names with their initials to ensure they
are grouped together in the browser.
WOW 5000.0.1.11 Release Notes Page 39 of 104 March 2014