)]}'
{"id":"openstack%2Fcloudkitty~663029","triplet_id":"openstack%2Fcloudkitty~master~Ia253175b45b8222aaee415ea535fa4102312be5a","project":"openstack/cloudkitty","branch":"master","topic":"fix-sqlalchemy-erros-v1-storage","hashtags":[],"change_id":"Ia253175b45b8222aaee415ea535fa4102312be5a","subject":"Fix sqlalchemy grouping on v1 storage","status":"MERGED","created":"2019-06-04 13:28:42.000000000","updated":"2019-06-28 09:31:04.000000000","submitted":"2019-06-05 12:47:32.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"663029-1559738852789-b7e14b42","meta_rev_id":"7f00f471d4e9ff4b80b37e103dfa47fc47906b13","_number":663029,"virtual_id_number":663029,"owner":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},{"value":2,"date":"2019-06-05 12:47:32.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"all":[{"value":2,"date":"2019-06-05 12:03:42.000000000","_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2019-06-05 08:54:18.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"all":[{"value":1,"date":"2019-06-05 12:03:42.000000000","_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},{"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-06-05 08:54:18.000000000","updated_by":{"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"},"reviewer":{"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"},"state":"REVIEWER"},{"updated":"2019-06-05 12:47:32.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"fd59d998606d4071b45001fdb90216389ffe6d00","author":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"date":"2019-06-04 13:28:42.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"102519620bfb37a5e78de1b23f5e36d812041a0d","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-04 14:32:07.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover http://logs.openstack.org/29/663029/1/check/openstack-tox-cover/2a1c376/cover/ : SUCCESS in 7m 05s\n- openstack-tox-pep8 http://logs.openstack.org/29/663029/1/check/openstack-tox-pep8/57c10bb/ : SUCCESS in 4m 12s\n- openstack-tox-py27 http://logs.openstack.org/29/663029/1/check/openstack-tox-py27/82bde32/ : SUCCESS in 4m 50s\n- openstack-tox-py36 http://logs.openstack.org/29/663029/1/check/openstack-tox-py36/21b7c94/ : SUCCESS in 5m 03s\n- openstack-tox-py37 http://logs.openstack.org/29/663029/1/check/openstack-tox-py37/dcc22dd/ : SUCCESS in 6m 12s\n- openstack-tox-docs http://logs.openstack.org/29/663029/1/check/openstack-tox-docs/f0a054f/html/ : SUCCESS in 4m 45s\n- build-openstack-releasenotes http://logs.openstack.org/29/663029/1/check/build-openstack-releasenotes/2b967fd/html/ : SUCCESS in 3m 59s\n- cloudkitty-tempest-full http://logs.openstack.org/29/663029/1/check/cloudkitty-tempest-full/75a8170/ : SUCCESS in 1h 01m 18s\n- cloudkitty-tempest-full-python3 http://logs.openstack.org/29/663029/1/check/cloudkitty-tempest-full-python3/67f5b40/ : SUCCESS in 37m 27s\n- cloudkitty-tox-bandit http://logs.openstack.org/29/663029/1/check/cloudkitty-tox-bandit/aeafcac/ : SUCCESS in 4m 48s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"ca11142726c88cfdf5e7598dadb3bfcf81e8e9f6","author":{"_account_id":29503,"name":"Justin Ferrieu","email":"jferrieu@objectif-libre.com","username":"jferrieu"},"date":"2019-06-05 08:54:18.000000000","message":"Patch Set 1: Code-Review+1\n\nLGTM.","accounts_in_message":[],"_revision_number":1},{"id":"42690b8af1686d3bb386301ce17a9f68e784bf6c","author":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"date":"2019-06-05 12:03:42.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"86f14a578e6064d2224456496bfbb0fc9d89ebea","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-05 12:03:53.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"750be40c646f84e9fb7383d4ac34b49e65e60948","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-05 12:47:32.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-pep8 http://logs.openstack.org/29/663029/1/gate/openstack-tox-pep8/828d488/ : SUCCESS in 5m 47s\n- openstack-tox-py27 http://logs.openstack.org/29/663029/1/gate/openstack-tox-py27/dca0dea/ : SUCCESS in 4m 49s\n- openstack-tox-py36 http://logs.openstack.org/29/663029/1/gate/openstack-tox-py36/ecace08/ : SUCCESS in 4m 48s\n- openstack-tox-py37 http://logs.openstack.org/29/663029/1/gate/openstack-tox-py37/f5b18b5/ : SUCCESS in 5m 11s\n- openstack-tox-docs http://logs.openstack.org/29/663029/1/gate/openstack-tox-docs/2fb2280/html/ : SUCCESS in 6m 51s\n- build-openstack-releasenotes http://logs.openstack.org/29/663029/1/gate/build-openstack-releasenotes/b45f90e/html/ : SUCCESS in 5m 16s\n- cloudkitty-tempest-full http://logs.openstack.org/29/663029/1/gate/cloudkitty-tempest-full/9d8a4ee/ : SUCCESS in 35m 47s\n- cloudkitty-tempest-full-python3 http://logs.openstack.org/29/663029/1/gate/cloudkitty-tempest-full-python3/bc2c6f2/ : SUCCESS in 36m 19s","accounts_in_message":[],"_revision_number":1},{"id":"c148aa0f55deff652b8a4b166f208bd2a0b449e8","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-05 12:47:32.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1},{"id":"239ddf666a2fc105a98da3efd4bd628b170cdf2d","author":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"date":"2019-06-28 09:18:44.000000000","message":"Patch Set 1: Cherry Picked\n\nThis patchset was cherry picked to branch stable/rocky as commit df869e4588c937dc0e78680a3b9fe9d0fc937e57","accounts_in_message":[],"_revision_number":1},{"id":"6f5108715ac8fcd8c75bbfced41bdc6148d3e2ce","author":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"date":"2019-06-28 09:31:04.000000000","message":"Patch Set 1: Cherry Picked\n\nThis patchset was cherry picked to branch stable/stein as commit 5e16701f4787336dae9732f42399ed64192ec3e4","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"5fef2d68f35577a62120ab64a2f67edf2522c259","revisions":{"5fef2d68f35577a62120ab64a2f67edf2522c259":{"kind":"REWORK","_number":1,"created":"2019-06-04 13:28:42.000000000","uploader":{"_account_id":23060,"name":"Luka Peschke","email":"mail@lukapeschke.com","username":"lukapeschke"},"ref":"refs/changes/29/663029/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/29/663029/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/29/663029/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/29/663029/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/29/663029/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/29/663029/1"}}},"commit":{"parents":[{"commit":"559a16d7108b0c3022a4b36f492d4f08d4760bc5","subject":"Merge \"Remove \"group_filters\" parameter from v2 storage interface\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/559a16d7108b0c3022a4b36f492d4f08d4760bc5"}]}],"author":{"name":"Luka Peschke","email":"luka.peschke@objectif-libre.com","date":"2019-06-04 13:21:05.000000000","tz":120},"committer":{"name":"Luka Peschke","email":"luka.peschke@objectif-libre.com","date":"2019-06-04 13:28:08.000000000","tz":120},"subject":"Fix sqlalchemy grouping on v1 storage","message":"Fix sqlalchemy grouping on v1 storage\n\nThis fixes \"CompileError: Can\u0027t resolve label reference for\nORDER BY / GROUP BY.\" error messages raised by sqlalchemy when the groupby\nexpression includes a comma.\n\nChange-Id: Ia253175b45b8222aaee415ea535fa4102312be5a\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5fef2d68f35577a62120ab64a2f67edf2522c259"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5fef2d68f35577a62120ab64a2f67edf2522c259"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}