{"action":"created","issue":{"url":"https://api.github.com/repos/kuali/kc/issues/1577","labels_url":"https://api.github.com/repos/kuali/kc/issues/1577/labels{/name}","comments_url":"https://api.github.com/repos/kuali/kc/issues/1577/comments","events_url":"https://api.github.com/repos/kuali/kc/issues/1577/events","html_url":"https://github.com/kuali/kc/pull/1577","id":69934754,"number":1577,"title":"[KRACOEUS-7230] Re-implementing 5.2.1 QuestionResolver changes in KC 6.x","user":{"login":"rojlarge","id":9733343,"avatar_url":"https://avatars.githubusercontent.com/u/9733343?v=3","gravatar_id":"","url":"https://api.github.com/users/rojlarge","html_url":"https://github.com/rojlarge","followers_url":"https://api.github.com/users/rojlarge/followers","following_url":"https://api.github.com/users/rojlarge/following{/other_user}","gists_url":"https://api.github.com/users/rojlarge/gists{/gist_id}","starred_url":"https://api.github.com/users/rojlarge/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rojlarge/subscriptions","organizations_url":"https://api.github.com/users/rojlarge/orgs","repos_url":"https://api.github.com/users/rojlarge/repos","events_url":"https://api.github.com/users/rojlarge/events{/privacy}","received_events_url":"https://api.github.com/users/rojlarge/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-21T19:49:53Z","updated_at":"2015-04-30T19:37:00Z","closed_at":"2015-04-30T14:51:19Z","pull_request":{"url":"https://api.github.com/repos/kuali/kc/pulls/1577","html_url":"https://github.com/kuali/kc/pull/1577","diff_url":"https://github.com/kuali/kc/pull/1577.diff","patch_url":"https://github.com/kuali/kc/pull/1577.patch"},"body":"KRACOEUS-7230\r\n\r\nThis re-implements some changes to the QuestionResolver code that we contributed before, and which made it into KC 5.2.1 but seem to have been left out of KC 6.0. It also includes a couple of our additional improvements/fixes to the QuestionResolver functionality, such as using the module sub item key when retrieving Answer Headers, filtering retrieved Answer Headers to only include those for the latest versions of Questionnaires, and making sure the Question Seq Id comparison is properly comparing String values. \r\n\r\nPlease note that since the existing KRMS Question terms use \"Question ID\" and \"Questionnaire ID\" as parameters, the following SQL will need to be run to update them to the new \"Seq ID\" terminology:\r\n\r\n```\r\nupdate KRMS_TERM_RSLVR_PARM_SPEC_T set nm = 'Question Seq ID' where nm = 'Question ID';\r\nupdate KRMS_TERM_RSLVR_PARM_SPEC_T set nm = 'Questionnaire Seq ID' where nm = 'Questionnaire ID';\r\nupdate KRMS_TERM_PARM_T set nm = 'Question Seq ID' where nm = 'Question ID';\r\nupdate KRMS_TERM_PARM_T set nm = 'Questionnaire Seq ID' where nm = 'Questionnaire ID';\r\n``` \r\n\r\nAlternatively, the parameter names that QuestionResolver looks for could be changed to \"Questionnaire ID\" and \"Question ID\" to avoid the need for any SQL. "},"comment":{"url":"https://api.github.com/repos/kuali/kc/issues/comments/97940438","html_url":"https://github.com/kuali/kc/pull/1577#issuecomment-97940438","issue_url":"https://api.github.com/repos/kuali/kc/issues/1577","id":97940438,"user":{"login":"leoherbie","id":188602,"avatar_url":"https://avatars.githubusercontent.com/u/188602?v=3","gravatar_id":"","url":"https://api.github.com/users/leoherbie","html_url":"https://github.com/leoherbie","followers_url":"https://api.github.com/users/leoherbie/followers","following_url":"https://api.github.com/users/leoherbie/following{/other_user}","gists_url":"https://api.github.com/users/leoherbie/gists{/gist_id}","starred_url":"https://api.github.com/users/leoherbie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leoherbie/subscriptions","organizations_url":"https://api.github.com/users/leoherbie/orgs","repos_url":"https://api.github.com/users/leoherbie/repos","events_url":"https://api.github.com/users/leoherbie/events{/privacy}","received_events_url":"https://api.github.com/users/leoherbie/received_events","type":"User","site_admin":false},"created_at":"2015-04-30T19:37:00Z","updated_at":"2015-04-30T19:37:00Z","body":"FYI. You can add new sql files if you want in the next logical sequence and I'll be sure to resequence them when I merge."}}