{"action":"created","issue":{"url":"https://api.github.com/repos/snabbco/snabb/issues/812","repository_url":"https://api.github.com/repos/snabbco/snabb","labels_url":"https://api.github.com/repos/snabbco/snabb/issues/812/labels{/name}","comments_url":"https://api.github.com/repos/snabbco/snabb/issues/812/comments","events_url":"https://api.github.com/repos/snabbco/snabb/issues/812/events","html_url":"https://github.com/snabbco/snabb/issues/812","id":139477754,"number":812,"title":"Github PR/issue queries","user":{"login":"lukego","id":13791,"avatar_url":"https://avatars.githubusercontent.com/u/13791?v=3","gravatar_id":"","url":"https://api.github.com/users/lukego","html_url":"https://github.com/lukego","followers_url":"https://api.github.com/users/lukego/followers","following_url":"https://api.github.com/users/lukego/following{/other_user}","gists_url":"https://api.github.com/users/lukego/gists{/gist_id}","starred_url":"https://api.github.com/users/lukego/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukego/subscriptions","organizations_url":"https://api.github.com/users/lukego/orgs","repos_url":"https://api.github.com/users/lukego/repos","events_url":"https://api.github.com/users/lukego/events{/privacy}","received_events_url":"https://api.github.com/users/lukego/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/snabbco/snabb/labels/idea","name":"idea","color":"009800"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-03-09T05:16:15Z","updated_at":"2016-08-04T11:19:00Z","closed_at":null,"body":"Creating this issue to work out what are interesting ways to query Github pull requests and issues. I am particularly interested to have some queries that I could execute e.g. daily or weekly to find upstreaming work that I am responsible for.\r\n\r\nFirst off the cuff:\r\n\r\n- [`is:pr is:open no:assignee`](https://github.com/SnabbCo/snabbswitch/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aopen+no%3Aassignee) open PRs that are not yet assigned to an upstream.\r\n- [`is:pr is:open base:next`](https://github.com/SnabbCo/snabbswitch/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aopen+base%3Anext) open PRs that specify `next` as their base branch.\r\n- [`is:pr is:open -label:merged`](https://github.com/SnabbCo/snabbswitch/pulls?utf8=%E2%9C%93&q=is%3Apr+is%3Aopen+-label%3Amerged) open PRs that are not `merged`.\r\n- [`is:issue is:open label:bug`](https://github.com/SnabbCo/snabbswitch/issues?q=is%3Aissue+is%3Aopen+label%3Abug) open bugs.\r\n\r\nThe basic thing I am lacking is a way to express time like \"in the past week\". This can be done with literal dates like `created:>2016-03-01` but that is not bookmark'able.\r\n\r\nCould be that we could use queries to more definitely define a division of labor for upstream activities? at least I would quite like a well-understood way to identify my required actions so that I know what to do and other people know how to make me do stuff. For now the best idea I have is to search for open PRs that have one of my branches as the `base:`.\r\n\r\ncc @eugeneia @wingo @kbara."},"comment":{"url":"https://api.github.com/repos/snabbco/snabb/issues/comments/237525335","html_url":"https://github.com/snabbco/snabb/issues/812#issuecomment-237525335","issue_url":"https://api.github.com/repos/snabbco/snabb/issues/812","id":237525335,"user":{"login":"plajjan","id":841628,"avatar_url":"https://avatars.githubusercontent.com/u/841628?v=3","gravatar_id":"","url":"https://api.github.com/users/plajjan","html_url":"https://github.com/plajjan","followers_url":"https://api.github.com/users/plajjan/followers","following_url":"https://api.github.com/users/plajjan/following{/other_user}","gists_url":"https://api.github.com/users/plajjan/gists{/gist_id}","starred_url":"https://api.github.com/users/plajjan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plajjan/subscriptions","organizations_url":"https://api.github.com/users/plajjan/orgs","repos_url":"https://api.github.com/users/plajjan/repos","events_url":"https://api.github.com/users/plajjan/events{/privacy}","received_events_url":"https://api.github.com/users/plajjan/received_events","type":"User","site_admin":false},"created_at":"2016-08-04T11:19:00Z","updated_at":"2016-08-04T11:19:00Z","body":"@eugeneia \"is:issue is:open NOT wip in:title\" should do that. Here's an example (using 'NFV' instead of wip because there are no wip issues): https://github.com/snabbco/snabb/issues?utf8=%E2%9C%93&q=is%3Aissue%20is%3Aopen%20NOT%20NFV%20in%3Atitle%20\r\n\r\nNote that \"NOT\" must be all capital - syntax is described here: https://help.github.com/articles/searching-issues/"}}
{"actor":{"display_login":"plajjan"}}