{"action":"closed","issue":{"url":"https://api.github.com/repos/translate/pootle/issues/3570","labels_url":"https://api.github.com/repos/translate/pootle/issues/3570/labels{/name}","comments_url":"https://api.github.com/repos/translate/pootle/issues/3570/comments","events_url":"https://api.github.com/repos/translate/pootle/issues/3570/events","html_url":"https://github.com/translate/pootle/issues/3570","id":56240200,"number":3570,"title":"Make resources list query work in all DB backends","user":{"login":"julen","id":16768,"avatar_url":"https://avatars.githubusercontent.com/u/16768?v=3","gravatar_id":"","url":"https://api.github.com/users/julen","html_url":"https://github.com/julen","followers_url":"https://api.github.com/users/julen/followers","following_url":"https://api.github.com/users/julen/following{/other_user}","gists_url":"https://api.github.com/users/julen/gists{/gist_id}","starred_url":"https://api.github.com/users/julen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julen/subscriptions","organizations_url":"https://api.github.com/users/julen/orgs","repos_url":"https://api.github.com/users/julen/repos","events_url":"https://api.github.com/users/julen/events{/privacy}","received_events_url":"https://api.github.com/users/julen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/translate/pootle/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/translate/pootle/milestones/15","labels_url":"https://api.github.com/repos/translate/pootle/milestones/15/labels","id":834522,"number":15,"title":"2.7.0","description":"Pootle core merge and 2.7 release","creator":{"login":"jleclanche","id":235410,"avatar_url":"https://avatars.githubusercontent.com/u/235410?v=3","gravatar_id":"","url":"https://api.github.com/users/jleclanche","html_url":"https://github.com/jleclanche","followers_url":"https://api.github.com/users/jleclanche/followers","following_url":"https://api.github.com/users/jleclanche/following{/other_user}","gists_url":"https://api.github.com/users/jleclanche/gists{/gist_id}","starred_url":"https://api.github.com/users/jleclanche/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jleclanche/subscriptions","organizations_url":"https://api.github.com/users/jleclanche/orgs","repos_url":"https://api.github.com/users/jleclanche/repos","events_url":"https://api.github.com/users/jleclanche/events{/privacy}","received_events_url":"https://api.github.com/users/jleclanche/received_events","type":"User","site_admin":false},"open_issues":74,"closed_issues":41,"state":"open","created_at":"2014-10-21T14:47:33Z","updated_at":"2015-02-02T14:20:06Z","due_on":"2015-03-30T22:00:00Z","closed_at":null},"comments":1,"created_at":"2015-02-02T14:03:58Z","updated_at":"2015-02-02T14:20:06Z","closed_at":"2015-02-02T14:20:06Z","body":"The current resources list which is used in the last drop-down only works for MySQL backends, since it uses a custom SQL query with some MySQL-only functions. The query needs to be adapted to whichever DB backends master wants to support."}}