{"action":"created","issue":{"url":"https://api.github.com/repos/jakob/Postico/issues/110","labels_url":"https://api.github.com/repos/jakob/Postico/issues/110/labels{/name}","comments_url":"https://api.github.com/repos/jakob/Postico/issues/110/comments","events_url":"https://api.github.com/repos/jakob/Postico/issues/110/events","html_url":"https://github.com/jakob/Postico/issues/110","id":114796914,"number":110,"title":"Is it possible to search by JSONB field?","user":{"login":"1st","id":630224,"avatar_url":"https://avatars.githubusercontent.com/u/630224?v=3","gravatar_id":"","url":"https://api.github.com/users/1st","html_url":"https://github.com/1st","followers_url":"https://api.github.com/users/1st/followers","following_url":"https://api.github.com/users/1st/following{/other_user}","gists_url":"https://api.github.com/users/1st/gists{/gist_id}","starred_url":"https://api.github.com/users/1st/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/1st/subscriptions","organizations_url":"https://api.github.com/users/1st/orgs","repos_url":"https://api.github.com/users/1st/repos","events_url":"https://api.github.com/users/1st/events{/privacy}","received_events_url":"https://api.github.com/users/1st/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-11-03T11:35:38Z","updated_at":"2015-11-03T12:00:36Z","closed_at":null,"body":"Hello Jakob!\r\n\r\nI like to use JSONB field in some tables and search by them. For example, I have a table `products` with some required fields (like `cost`, `quantity`, `name`) and one additional JSONB field `properties` where I can push any JSON data (for TV it can be `screen_size` and for `car` it can be `wheels_size`).\r\n\r\nI don't know is Portico have support of querying this typeof fields? For example, I need to select all products with `screen_size=15` and `product_type=TV`. How to do this in Portico?\r\n\r\nThank you."},"comment":{"url":"https://api.github.com/repos/jakob/Postico/issues/comments/153331593","html_url":"https://github.com/jakob/Postico/issues/110#issuecomment-153331593","issue_url":"https://api.github.com/repos/jakob/Postico/issues/110","id":153331593,"user":{"login":"jakob","id":198305,"avatar_url":"https://avatars.githubusercontent.com/u/198305?v=3","gravatar_id":"","url":"https://api.github.com/users/jakob","html_url":"https://github.com/jakob","followers_url":"https://api.github.com/users/jakob/followers","following_url":"https://api.github.com/users/jakob/following{/other_user}","gists_url":"https://api.github.com/users/jakob/gists{/gist_id}","starred_url":"https://api.github.com/users/jakob/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakob/subscriptions","organizations_url":"https://api.github.com/users/jakob/orgs","repos_url":"https://api.github.com/users/jakob/repos","events_url":"https://api.github.com/users/jakob/events{/privacy}","received_events_url":"https://api.github.com/users/jakob/received_events","type":"User","site_admin":false},"created_at":"2015-11-03T12:00:36Z","updated_at":"2015-11-03T12:00:36Z","body":"<img width=\"764\" alt=\"screen shot 2015-11-03 at 13 00 11\" src=\"https://cloud.githubusercontent.com/assets/198305/10907496/db0c2bb8-822a-11e5-92ff-631ee931c6ee.png\">\r\n"}}