Project

General

Profile

DQ Assessments

  • Each example is a SQL query (tested in SQLPLUS on db-desoper) for the equivalent in trivialAccess one should remove the ending ";"
    • Example 1. Checking for most recent SN entries:
      select expnum,accepted,analyst,analyst_comment from prod.firstcut_eval where analyst='SNQUALITY' order by expnum;
    • Example 2a. Checking for SN entries from a specific night:
      select expnum,accepted,analyst,analyst_comment from prod.firstcut_eval where analyst='SNQUALITY' and analyst_comment like '%20141028%' order by expnum;
    • Example 2b. Checking for SN entries from a specific night (more correct because it relies on NITE field in the EXPOSURE table rather than a convention for the analyst_comment):
      select f.expnum,f.accepted,f.analyst,f.analyst_comment from prod.firstcut_eval f, prod.exposure e where f.analyst='SNQUALITY' and e.expnum=f.expnum and e.camsym=f.camsym and e.nite='20141028' order by f.expnum;
    • Example 3. Similar to (1) but for the most recent Survey exposures:
      select expnum,accepted,analyst,analyst_comment from prod.firstcut_eval where program='survey' order by expnum;
    • Example 4. Similar to 2b but for Survey exposures:
      select f.expnum,f.accepted,f.analyst,f.analyst_comment from prod.firstcut_eval f, prod.exposure e where f.program='survey' and e.expnum=f.expnum and e.camsym=f.camsym and e.nite='20141028' order by f.expnum;