{"action":"created","issue":{"url":"https://api.github.com/repos/cyclus/cymetric/issues/24","labels_url":"https://api.github.com/repos/cyclus/cymetric/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/cyclus/cymetric/issues/24/comments","events_url":"https://api.github.com/repos/cyclus/cymetric/issues/24/events","html_url":"https://github.com/cyclus/cymetric/issues/24","id":55994992,"number":24,"title":"metrics filtering ","user":{"login":"opotowsky","id":5347433,"avatar_url":"https://avatars.githubusercontent.com/u/5347433?v=3","gravatar_id":"","url":"https://api.github.com/users/opotowsky","html_url":"https://github.com/opotowsky","followers_url":"https://api.github.com/users/opotowsky/followers","following_url":"https://api.github.com/users/opotowsky/following{/other_user}","gists_url":"https://api.github.com/users/opotowsky/gists{/gist_id}","starred_url":"https://api.github.com/users/opotowsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opotowsky/subscriptions","organizations_url":"https://api.github.com/users/opotowsky/orgs","repos_url":"https://api.github.com/users/opotowsky/repos","events_url":"https://api.github.com/users/opotowsky/events{/privacy}","received_events_url":"https://api.github.com/users/opotowsky/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cyclus/cymetric/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"scopatz","id":320553,"avatar_url":"https://avatars.githubusercontent.com/u/320553?v=3","gravatar_id":"","url":"https://api.github.com/users/scopatz","html_url":"https://github.com/scopatz","followers_url":"https://api.github.com/users/scopatz/followers","following_url":"https://api.github.com/users/scopatz/following{/other_user}","gists_url":"https://api.github.com/users/scopatz/gists{/gist_id}","starred_url":"https://api.github.com/users/scopatz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scopatz/subscriptions","organizations_url":"https://api.github.com/users/scopatz/orgs","repos_url":"https://api.github.com/users/scopatz/repos","events_url":"https://api.github.com/users/scopatz/events{/privacy}","received_events_url":"https://api.github.com/users/scopatz/received_events","type":"User","site_admin":false},"milestone":null,"comments":8,"created_at":"2015-01-30T05:00:06Z","updated_at":"2015-02-11T23:50:51Z","closed_at":null,"body":"It seems I can filter on a root table just fine, but when I want to filter a metric, I get this type of error when trying to filter by any column other than QualId (pretty sure I tried all of the columns for the Materials metric):\r\n\r\n```bash\r\n$ cymetric lwr.sqlite -e \"print(Materials[NucId != 922380000])\"\r\n/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/metrics.py:12: QAWarning: pyne.data is not yet QA compliant.\r\n  from pyne import data\r\nTraceback (most recent call last):\r\n  File \"/home/opotowsky/.local/bin/cymetric\", line 4, in <module>\r\n    main()\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/main.py\", line 31, in main\r\n    exec_code(ns.exec_code, db)\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/execution.py\", line 197, in exec_code\r\n    exec(code, glb, loc)\r\n  File \"<string>\", line 1, in <module>\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/execution.py\", line 123, in __getitem__\r\n    return self.evaler.eval(self.name, conds=conds)\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/evaluator.py\", line 59, in eval\r\n    d = self.eval(dep[0], conds=conds)\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/evaluator.py\", line 62, in eval\r\n    raw = m(series=series, conds=conds, known_tables=self.known_tables)\r\n  File \"/home/opotowsky/.local/lib/python2.7/site-packages/cymetric/root_metrics.py\", line 27, in __call__\r\n    return self.db.query(self.name, conds=conds)\r\n  File \"cyclus.pyx\", line 123, in cymetric.cyclus._FullBackend.query (/home/opotowsky/cyclus/cymetric/build/cymetric/cyclus.cxx:2586)\r\nRuntimeError: SQL error [SELECT * FROM Resources WHERE NucId != ?;]: no such column: NucId\r\n```"},"comment":{"url":"https://api.github.com/repos/cyclus/cymetric/issues/comments/73990634","html_url":"https://github.com/cyclus/cymetric/issues/24#issuecomment-73990634","issue_url":"https://api.github.com/repos/cyclus/cymetric/issues/24","id":73990634,"user":{"login":"opotowsky","id":5347433,"avatar_url":"https://avatars.githubusercontent.com/u/5347433?v=3","gravatar_id":"","url":"https://api.github.com/users/opotowsky","html_url":"https://github.com/opotowsky","followers_url":"https://api.github.com/users/opotowsky/followers","following_url":"https://api.github.com/users/opotowsky/following{/other_user}","gists_url":"https://api.github.com/users/opotowsky/gists{/gist_id}","starred_url":"https://api.github.com/users/opotowsky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/opotowsky/subscriptions","organizations_url":"https://api.github.com/users/opotowsky/orgs","repos_url":"https://api.github.com/users/opotowsky/repos","events_url":"https://api.github.com/users/opotowsky/events{/privacy}","received_events_url":"https://api.github.com/users/opotowsky/received_events","type":"User","site_admin":false},"created_at":"2015-02-11T23:50:50Z","updated_at":"2015-02-11T23:50:50Z","body":"AWESOME*\r\n\r\n*as long as the issue isn't too hairy"}}