{"action":"opened","issue":{"url":"https://api.github.com/repos/ODM2/ODM2/issues/155","repository_url":"https://api.github.com/repos/ODM2/ODM2","labels_url":"https://api.github.com/repos/ODM2/ODM2/issues/155/labels{/name}","comments_url":"https://api.github.com/repos/ODM2/ODM2/issues/155/comments","events_url":"https://api.github.com/repos/ODM2/ODM2/issues/155/events","html_url":"https://github.com/ODM2/ODM2/issues/155","id":351081877,"node_id":"MDU6SXNzdWUzNTEwODE4Nzc=","number":155,"title":"Storing the minimum and maximum value for a range","user":{"login":"PleiadesAustralia","id":38876803,"node_id":"MDQ6VXNlcjM4ODc2ODAz","avatar_url":"https://avatars0.githubusercontent.com/u/38876803?v=4","gravatar_id":"","url":"https://api.github.com/users/PleiadesAustralia","html_url":"https://github.com/PleiadesAustralia","followers_url":"https://api.github.com/users/PleiadesAustralia/followers","following_url":"https://api.github.com/users/PleiadesAustralia/following{/other_user}","gists_url":"https://api.github.com/users/PleiadesAustralia/gists{/gist_id}","starred_url":"https://api.github.com/users/PleiadesAustralia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PleiadesAustralia/subscriptions","organizations_url":"https://api.github.com/users/PleiadesAustralia/orgs","repos_url":"https://api.github.com/users/PleiadesAustralia/repos","events_url":"https://api.github.com/users/PleiadesAustralia/events{/privacy}","received_events_url":"https://api.github.com/users/PleiadesAustralia/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-16T07:10:11Z","updated_at":"2018-08-16T07:10:11Z","closed_at":null,"author_association":"NONE","body":"Hello all,\r\n\r\nMy ecosystem health database stores many observed values as ranges >X and <Y.\r\n\r\nI have tried to save this in MeasurementResults and MeasurementResultsValues bu creating 2 MeasurementResults - one with an censor code of > (and aggregation code of minimum) and the other with a censor code of < (and aggregation code of maximum).  However, this creates an objection to inserting a duplicate ResultID in the MeasurementResults table.  What is the accepted ODM approach to storing range values?\r\n\r\nMuch thanks for getting back to me quickly on this one.\r\n\r\nRegards,\r\nSam"}}
{"actor":{"display_login":"PleiadesAustralia"}}