#38 Valflag of 'Y' in database means DELETED

Defect
closed-fixed
David Benn
8
2010-03-03
2009-09-14
David Benn
No

Since a valflag of 'Y' in a database observation record denotes DELETED, the corresponding observation should not be included in the list of observations displayed in tables and plots.

Discussion

  • David Benn
    David Benn
    2009-09-24

    Check that any other validation flag that denotes "deleted" is similarly acted upon.

     
  • David Benn
    David Benn
    2009-09-24

    • priority: 5 --> 7
     
  • David Benn
    David Benn
    2009-09-25

    • priority: 7 --> 8
     
  • David Benn
    David Benn
    2009-09-29

    • assigned_to: david_benn --> jorgeltx
    • status: open --> open-accepted
     
  • David Benn
    David Benn
    2010-02-13

    • assigned_to: jorgeltx --> david_benn
     
  • David Benn
    David Benn
    2010-02-13

    Consider adding a constraint to the SQL query to ignore valflag='Y' obs rows.

     
  • David Benn
    David Benn
    2010-02-14

    • status: open-accepted --> open-fixed
     
  • Sara Beck
    Sara Beck
    2010-03-03

    Tested with a small set of R LEO data that looked like this:

    mysql> select name, JD, valflag from observations where name = "R LEO" and JD > 2455250 and JD < 2455260;
    +-------+---------------+---------+
    | name | JD | valflag |
    +-------+---------------+---------+
    | R LEO | 2455251.96667 | Z |
    | R LEO | 2455258.28264 | Z |
    | R LEO | 2455257.4708 | Z |
    | R LEO | 2455259.34375 | Y |
    | R LEO | 2455259.34375 | Z |
    +-------+---------------+---------+
    5 rows in set (16.22 sec)

    and the one observation with valflag = 'Y" didn't show up so this looks good.

     
  • Sara Beck
    Sara Beck
    2010-03-03

    • status: open-fixed --> closed-fixed