)]}'
{"specs/juno/filtering.rst":[{"author":{"_account_id":741,"name":"Kiall Mac Innes","email":"kiall@macinnes.ie","username":"kiall"},"change_message_id":"d561292bf2f7e849a7a5c6f66ccaf8463432668b","unresolved":false,"context_lines":[{"line_number":14,"context_line":""},{"line_number":15,"context_line":"The spec is still under heavy revision, and some features need to be discussed further before implementation. The main topic for now regards substring filtering. Currently, the API supports wildcards using SQL LIKE pattern matching (i.e. abc% will match abc.com., %abc will match www.abc, and %abc% will match www.abc.com). However, queries with wildcards on the left side pose a strain on the Designate system when a customer has thousands or tens of thousands of resources to filter through, because they will require a near-full or full scan through these resources. Some questions need to be answered before moving further on this."},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"* Does substring filtering need to be restricted so that wildcards can only be at the far-right end of searches (e.g. abc%)?"},{"line_number":18,"context_line":""},{"line_number":19,"context_line":"  * If so, how would we implement this? Two possible methods:"},{"line_number":20,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"baada198_4ef993c7","line":17,"updated":"2014-07-01 11:28:35.000000000","message":"I personally don\u0027t think we need to be too restrictive","commit_id":"dbb981a65f43625b48dea86eb8f04a2e3b46bb1d"},{"author":{"_account_id":741,"name":"Kiall Mac Innes","email":"kiall@macinnes.ie","username":"kiall"},"change_message_id":"d561292bf2f7e849a7a5c6f66ccaf8463432668b","unresolved":false,"context_lines":[{"line_number":67,"context_line":"| Verb | Resource                                     | Description          |"},{"line_number":68,"context_line":"+\u003d\u003d\u003d\u003d\u003d\u003d+\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d+\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d+"},{"line_number":69,"context_line":"| GET  | zones/{id}/recordsets/{id}/records?          | From the specified   |"},{"line_number":70,"context_line":"|      |   name\u003dwww.example.com\u0026match_type\u003dexact      | recordset, return    |"},{"line_number":71,"context_line":"|      |                                              | any record with a    |"},{"line_number":72,"context_line":"|      |                                              | name that matches    |"},{"line_number":73,"context_line":"|      |                                              | the specified filter |"}],"source_content_type":"text/x-rst","patch_set":2,"id":"baada198_2ee37f08","line":70,"updated":"2014-07-01 11:28:35.000000000","message":"Is match_type\u003dexact required? or can we infer this based on the presence of a wildcard in the filter value?","commit_id":"dbb981a65f43625b48dea86eb8f04a2e3b46bb1d"},{"author":{"_account_id":741,"name":"Kiall Mac Innes","email":"kiall@macinnes.ie","username":"kiall"},"change_message_id":"d561292bf2f7e849a7a5c6f66ccaf8463432668b","unresolved":false,"context_lines":[{"line_number":74,"context_line":"|      |                                              | (“name”) exactly.    |"},{"line_number":75,"context_line":"+------+----------------------------------------------+----------------------+"},{"line_number":76,"context_line":"| GET  | zones/{id}/recordsets/{id}/records?          | From the specified   |"},{"line_number":77,"context_line":"|      |    name\u003dwww.test\u0026match_type\u003dsubstr           | recordset, return    | "},{"line_number":78,"context_line":"|      |                                              | any record with a    |"},{"line_number":79,"context_line":"|      |                                              | name that the        |"},{"line_number":80,"context_line":"|      |                                              | specified filter     |"}],"source_content_type":"text/x-rst","patch_set":2,"id":"baada198_6ee4970d","line":77,"updated":"2014-07-01 11:28:35.000000000","message":"As above, for match_type\u003dsubstr","commit_id":"dbb981a65f43625b48dea86eb8f04a2e3b46bb1d"},{"author":{"_account_id":741,"name":"Kiall Mac Innes","email":"kiall@macinnes.ie","username":"kiall"},"change_message_id":"d561292bf2f7e849a7a5c6f66ccaf8463432668b","unresolved":false,"context_lines":[{"line_number":104,"context_line":"GET zones/{zone-id}/recordsets?name\u003dexample\u0026match-type\u003dsubstr"},{"line_number":105,"context_line":"^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"},{"line_number":106,"context_line":""},{"line_number":107,"context_line":"This call is for a privileged user filtering recordsets by name, for one tenant, using substring matching."},{"line_number":108,"context_line":""},{"line_number":109,"context_line":"Request:"},{"line_number":110,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"baada198_6e79f72e","line":107,"updated":"2014-07-01 11:28:35.000000000","message":"I *think* we can avoud the need for \"X-Tenant-ID:\" by A) exposing tenant_id in the API responses (which will be required anyway, when we eventually implement keystone domain support), and B) add a \"all_tenants\u003dTrue\" query param.\n\nThen - admin\u0027s would be able to GET /collection?all_tenants\u003dTrue\u0026tenant_id\u003d12345\u0026name\u003dexample.com.","commit_id":"dbb981a65f43625b48dea86eb8f04a2e3b46bb1d"},{"author":{"_account_id":741,"name":"Kiall Mac Innes","email":"kiall@macinnes.ie","username":"kiall"},"change_message_id":"cb9ba8fc0d286dbb6f40bc663e3a2bcac2aa43c9","unresolved":false,"context_lines":[{"line_number":66,"context_line":"+------+----------------------------------------------+----------------------+"},{"line_number":67,"context_line":"| Verb | Resource                                     | Description          |"},{"line_number":68,"context_line":"+\u003d\u003d\u003d\u003d\u003d\u003d+\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d+\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d+"},{"line_number":69,"context_line":"| GET  | zones/{id}/recordsets/{id}/records?          | From the specified   |"},{"line_number":70,"context_line":"|      |   name\u003dwww.example.com                       | recordset, return    |"},{"line_number":71,"context_line":"|      |                                              | any record with a    |"},{"line_number":72,"context_line":"|      |                                              | name that matches    |"}],"source_content_type":"text/x-rst","patch_set":4,"id":"baada198_190bfc24","line":69,"updated":"2014-07-18 14:03:46.000000000","message":"So - zones/{id}/recordsets/{id}/records has been removed with Betsy\u0027s change, we should update this spec to account for that.","commit_id":"2688a03757a2bc67ae9f37a8f4f6922a4f63a328"}]}
