)]}'
{"id":"openstack%2Ffreezer-api~1008085","triplet_id":"openstack%2Ffreezer-api~master~I78d51b0555f5015a6f8529306ed57a95c5b6ce31","project":"openstack/freezer-api","branch":"master","hashtags":[],"change_id":"I78d51b0555f5015a6f8529306ed57a95c5b6ce31","subject":"Filter searches on job schedule fields in sql","status":"NEW","created":"2026-09-30 15:47:45.000000000","updated":"2026-09-30 16:18:18.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":true,"submittable":false,"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"c96dc152dc7fb2c9b13d6b0f6041bd95a78cbe5f","_number":1008085,"virtual_id_number":1008085,"owner":{"_account_id":39044,"name":"Alicja Filipek","display_name":"alaf01","email":"alicja.filipek@cleura.com","username":"alaf01"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2026-09-30 16:18:18.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"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":{"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2026-09-30 15:58:49.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":"CC"},{"updated":"2026-09-30 16:18:18.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":"3f0d3c2774d0bd3c8860fe3103a806c2d4eb2683","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":39044,"name":"Alicja Filipek","display_name":"alaf01","email":"alicja.filipek@cleura.com","username":"alaf01"},"date":"2026-09-30 15:47:45.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"95994aa95b53e432b20b8c0bb9cfcede74e848e8","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-09-30 15:58:49.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/c1b0ef3cad8347cfa94f8c5f066cc84e\n\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/01dc57296ab24b3eb539cb483a68919b : SUCCESS in 4m 54s (non-voting)\n- openstack-tox-py314-arm64 https://zuul.opendev.org/t/openstack/build/81a1ebc80be346ee9d5ed833bf8a8d01 : SUCCESS in 7m 41s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"c96dc152dc7fb2c9b13d6b0f6041bd95a78cbe5f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-09-30 16:18:18.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/3fb051cf0c9d44989db497d7394aa832\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/04bf7586ffaa471998e6dbe694b54b7b : SUCCESS in 3m 25s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/8f5c896d81054d0288b12797b2d2b6db : SUCCESS in 4m 17s\n- openstack-tox-py314 https://zuul.opendev.org/t/openstack/build/b6d3ad56ca7a42548621f99fb588277a : SUCCESS in 8m 31s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2fbeac22b40244c09bf66420bb00a54c : SUCCESS in 3m 24s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/d3981aa120324bb0b0f477e3b6ade3c4 : SUCCESS in 4m 04s\n- openstack-tox-pylint https://zuul.opendev.org/t/openstack/build/af7907a5132b49adad3d6e923e8c1084 : SUCCESS in 4m 27s\n- freezer-tempest-basic https://zuul.opendev.org/t/openstack/build/348868f9ea034f43aa62fb92a1a0ed12 : SUCCESS in 27m 38s\n- freezer-tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/b4bb933d214b481d9044987c2dd9dc0e : SUCCESS in 24m 16s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"ea5e36a4e945e9506e24ec3e2f4c94dd885e108a","revisions":{"ea5e36a4e945e9506e24ec3e2f4c94dd885e108a":{"kind":"REWORK","_number":1,"created":"2026-09-30 15:47:45.000000000","uploader":{"_account_id":39044,"name":"Alicja Filipek","display_name":"alaf01","email":"alicja.filipek@cleura.com","username":"alaf01"},"ref":"refs/changes/85/1008085/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/freezer-api","ref":"refs/changes/85/1008085/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/freezer-api refs/changes/85/1008085/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/freezer-api refs/changes/85/1008085/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/freezer-api refs/changes/85/1008085/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/freezer-api refs/changes/85/1008085/1"}}},"commit":{"parents":[{"commit":"40ece7b122a06956c013ba7d9d4206c3039fee9d","subject":"Bind resources by project_id for Elasticsearch","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/freezer-api/commit/40ece7b122a06956c013ba7d9d4206c3039fee9d"}]}],"author":{"name":"Alicja Filipek","email":"alicja.filipek@cleura.com","date":"2026-09-29 12:20:49.000000000","tz":120},"committer":{"name":"Alicja Filipek","email":"alicja.filipek@cleura.com","date":"2026-09-30 15:42:55.000000000","tz":120},"subject":"Filter searches on job schedule fields in sql","message":"Filter searches on job schedule fields in sql\n\nThe schedule of a job is stored as a single json blob, so a search on\nits \u0027event\u0027, \u0027status\u0027 or \u0027result\u0027 loads every job and filters and pages\nin python. Move these fields to indexed columns of the jobs table and\nfilter and page searches on column keys in sql.\n\nA search is turned into (key, value, op) filters, so another\nsource of filters, such as query parameters, can reuse the sql part.\nA malformed \u0027match\u0027 or \u0027match_not\u0027 is rejected with 400.\n\nChange-Id: I78d51b0555f5015a6f8529306ed57a95c5b6ce31\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\nSigned-off-by: Alicja Filipek \u003calicja.filipek@cleura.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/freezer-api/commit/ea5e36a4e945e9506e24ec3e2f4c94dd885e108a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/freezer-api/commit/ea5e36a4e945e9506e24ec3e2f4c94dd885e108a"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"OK","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY"},{"label":"Workflow","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{"label:Code-Review\u003dMAX":"","label:Code-Review\u003dMIN":""}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}