{"action":"closed","issue":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/4742","labels_url":"https://api.github.com/repos/dmwm/WMCore/issues/4742/labels{/name}","comments_url":"https://api.github.com/repos/dmwm/WMCore/issues/4742/comments","events_url":"https://api.github.com/repos/dmwm/WMCore/issues/4742/events","html_url":"https://github.com/dmwm/WMCore/issues/4742","id":18175252,"number":4742,"title":"Fetch info on physics group membership from SiteDB for permissions","user":{"login":"ericvaandering","id":1672366,"avatar_url":"https://avatars.githubusercontent.com/u/1672366?v=3","gravatar_id":"","url":"https://api.github.com/users/ericvaandering","html_url":"https://github.com/ericvaandering","followers_url":"https://api.github.com/users/ericvaandering/followers","following_url":"https://api.github.com/users/ericvaandering/following{/other_user}","gists_url":"https://api.github.com/users/ericvaandering/gists{/gist_id}","starred_url":"https://api.github.com/users/ericvaandering/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericvaandering/subscriptions","organizations_url":"https://api.github.com/users/ericvaandering/orgs","repos_url":"https://api.github.com/users/ericvaandering/repos","events_url":"https://api.github.com/users/ericvaandering/events{/privacy}","received_events_url":"https://api.github.com/users/ericvaandering/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dmwm/WMCore/labels/ReqMgr","name":"ReqMgr","color":"DDDDDD"},{"url":"https://api.github.com/repos/dmwm/WMCore/labels/StoreResults","name":"StoreResults","color":"dddddd"}],"state":"closed","locked":false,"assignee":{"login":"ticoann","id":1247993,"avatar_url":"https://avatars.githubusercontent.com/u/1247993?v=3","gravatar_id":"","url":"https://api.github.com/users/ticoann","html_url":"https://github.com/ticoann","followers_url":"https://api.github.com/users/ticoann/followers","following_url":"https://api.github.com/users/ticoann/following{/other_user}","gists_url":"https://api.github.com/users/ticoann/gists{/gist_id}","starred_url":"https://api.github.com/users/ticoann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ticoann/subscriptions","organizations_url":"https://api.github.com/users/ticoann/orgs","repos_url":"https://api.github.com/users/ticoann/repos","events_url":"https://api.github.com/users/ticoann/events{/privacy}","received_events_url":"https://api.github.com/users/ticoann/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/dmwm/WMCore/milestones/84","html_url":"https://github.com/dmwm/WMCore/milestones/StoreResults3.%20ReqMgr%20side","labels_url":"https://api.github.com/repos/dmwm/WMCore/milestones/84/labels","id":403804,"number":84,"title":"StoreResults3. ReqMgr side","description":"The thing necessary for building a complete StoreResults spec file. From this plan:\r\n\r\n\r\nWorkflow chain:\r\n\r\n  1. User enters data\r\n      * Input dataset\r\n      * physics group (drop down, missing from cmsweb)\r\n      * \r\n         * DBS has the list. should be API in v3\r\n         * in Phedex? SiteDB?\r\n      * DBS instance (drop down as is)\r\n      * Request is \"created\" with new dataset name (already part of ReqMgr, could have a different set of rules. Try to keep similar rules to what we have now.)\r\n      * Email is sent to coordinators (e-mail info is in SiteDB). Should have hyperlink to request\r\n  2. Physics coordinator asked for approval\r\n      * Info on who can approve comes from SiteDB\r\n      * Makes sense to get from SiteDB\r\n  3. Physics coordinator approves\r\n      * Request status is \"Assignment-approved\"\r\n      * Optional: e-mail sent to user, coordinators, ops?\r\n      * Migration requested\r\n      * Location is retrieved here\r\n      * Algorithm to pick correct version? (Can be done by ops too, so could be descoped)\r\n  4. Ops assigns\r\n    1. How do operators know there is a request ready? WMStats has this info. Can filter by Type\r\n    2. Migration is checked, ops warned to check back later\r\n    3. Optional: add a state to RegMgr for \"migrated\", add polling to ReqMgr to automatically flip state to migrated (or state migrating -> assignment approved)\r\n    4. status is \"assigned\"\r\n\r\nSpecial things about spec to be checked\r\n\r\n\r\n   * locations not in Phedex, may require changes to work queue\r\n   * \r\n      * does it update location table for xrootd workflows?\r\n   * should have xrootd flag set, specify where to run\r\n   * writes to /store/results, not /store/mc\r\n   * How do we get the physics group info into PhEDEx? Possibly in the spec? DBS2/3 is getting physics group from WMAgent.\r\n","creator":{"login":"ericvaandering","id":1672366,"avatar_url":"https://avatars.githubusercontent.com/u/1672366?v=3","gravatar_id":"","url":"https://api.github.com/users/ericvaandering","html_url":"https://github.com/ericvaandering","followers_url":"https://api.github.com/users/ericvaandering/followers","following_url":"https://api.github.com/users/ericvaandering/following{/other_user}","gists_url":"https://api.github.com/users/ericvaandering/gists{/gist_id}","starred_url":"https://api.github.com/users/ericvaandering/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericvaandering/subscriptions","organizations_url":"https://api.github.com/users/ericvaandering/orgs","repos_url":"https://api.github.com/users/ericvaandering/repos","events_url":"https://api.github.com/users/ericvaandering/events{/privacy}","received_events_url":"https://api.github.com/users/ericvaandering/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":2,"state":"open","created_at":"2013-08-16T19:41:28Z","updated_at":"2015-05-08T14:08:39Z","due_on":"2013-12-01T08:00:00Z","closed_at":null},"comments":0,"created_at":"2013-08-16T19:46:01Z","updated_at":"2015-05-08T14:08:39Z","closed_at":"2015-05-08T14:08:39Z","body":"See milestone for context."}}