{"action":"created","issue":{"url":"https://api.github.com/repos/apache/cloudstack/issues/1085","labels_url":"https://api.github.com/repos/apache/cloudstack/issues/1085/labels{/name}","comments_url":"https://api.github.com/repos/apache/cloudstack/issues/1085/comments","events_url":"https://api.github.com/repos/apache/cloudstack/issues/1085/events","html_url":"https://github.com/apache/cloudstack/pull/1085","id":117532044,"number":1085,"title":"[4.6] Cannot list vlanipranges by keyword","user":{"login":"ustcweizhou","id":3204966,"avatar_url":"https://avatars.githubusercontent.com/u/3204966?v=3","gravatar_id":"","url":"https://api.github.com/users/ustcweizhou","html_url":"https://github.com/ustcweizhou","followers_url":"https://api.github.com/users/ustcweizhou/followers","following_url":"https://api.github.com/users/ustcweizhou/following{/other_user}","gists_url":"https://api.github.com/users/ustcweizhou/gists{/gist_id}","starred_url":"https://api.github.com/users/ustcweizhou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ustcweizhou/subscriptions","organizations_url":"https://api.github.com/users/ustcweizhou/orgs","repos_url":"https://api.github.com/users/ustcweizhou/repos","events_url":"https://api.github.com/users/ustcweizhou/events{/privacy}","received_events_url":"https://api.github.com/users/ustcweizhou/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-18T07:41:52Z","updated_at":"2015-11-23T08:16:06Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/cloudstack/pulls/1085","html_url":"https://github.com/apache/cloudstack/pull/1085","diff_url":"https://github.com/apache/cloudstack/pull/1085.diff","patch_url":"https://github.com/apache/cloudstack/pull/1085.patch"},"body":"Before change:\r\n\r\ncloudmonkey> list vlanipranges  keyword=118\r\n: Caught: com.mysql.jdbc.JDBC4PreparedStatement@18f36b6e: SELECT vlan.id, vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, vlan.ip6_cidr, vlan.data_center_id, vlan.description, vlan.ip6_range, vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid, vlan.removed, vlan.created FROM vlan WHERE  ( OR vlan.description LIKE ** NOT SPECIFIED ** )  AND vlan.removed IS NULL  ORDER BY vlan.id ASC  LIMIT 0, 500\r\n\r\nAfter change:\r\n\r\ncloudmonkey> list vlanipranges  keyword='118'\r\ncount = 1\r\nvlaniprange:\r\nid = 0d80fd9c-cd6b-4f99-96c6-261420e75f58\r\naccount = system\r\ndomain = ROOT\r\ndomainid = 2044762d-c4a5-11e3-8379-005056ac4490\r\n......"},"comment":{"url":"https://api.github.com/repos/apache/cloudstack/issues/comments/158874483","html_url":"https://github.com/apache/cloudstack/pull/1085#issuecomment-158874483","issue_url":"https://api.github.com/repos/apache/cloudstack/issues/1085","id":158874483,"user":{"login":"bhaisaab","id":95203,"avatar_url":"https://avatars.githubusercontent.com/u/95203?v=3","gravatar_id":"","url":"https://api.github.com/users/bhaisaab","html_url":"https://github.com/bhaisaab","followers_url":"https://api.github.com/users/bhaisaab/followers","following_url":"https://api.github.com/users/bhaisaab/following{/other_user}","gists_url":"https://api.github.com/users/bhaisaab/gists{/gist_id}","starred_url":"https://api.github.com/users/bhaisaab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhaisaab/subscriptions","organizations_url":"https://api.github.com/users/bhaisaab/orgs","repos_url":"https://api.github.com/users/bhaisaab/repos","events_url":"https://api.github.com/users/bhaisaab/events{/privacy}","received_events_url":"https://api.github.com/users/bhaisaab/received_events","type":"User","site_admin":false},"created_at":"2015-11-23T08:16:06Z","updated_at":"2015-11-23T08:16:06Z","body":"LGTM"}}