{"action":"created","issue":{"url":"https://api.github.com/repos/chembl/user_interface/issues/39","repository_url":"https://api.github.com/repos/chembl/user_interface","labels_url":"https://api.github.com/repos/chembl/user_interface/issues/39/labels{/name}","comments_url":"https://api.github.com/repos/chembl/user_interface/issues/39/comments","events_url":"https://api.github.com/repos/chembl/user_interface/issues/39/events","html_url":"https://github.com/chembl/user_interface/issues/39","id":149413306,"number":39,"title":"Mechanism refs missing & malformed links","user":{"login":"ndedman","id":6928576,"avatar_url":"https://avatars.githubusercontent.com/u/6928576?v=3","gravatar_id":"","url":"https://api.github.com/users/ndedman","html_url":"https://github.com/ndedman","followers_url":"https://api.github.com/users/ndedman/followers","following_url":"https://api.github.com/users/ndedman/following{/other_user}","gists_url":"https://api.github.com/users/ndedman/gists{/gist_id}","starred_url":"https://api.github.com/users/ndedman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ndedman/subscriptions","organizations_url":"https://api.github.com/users/ndedman/orgs","repos_url":"https://api.github.com/users/ndedman/repos","events_url":"https://api.github.com/users/ndedman/events{/privacy}","received_events_url":"https://api.github.com/users/ndedman/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/chembl/user_interface/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"ndedman","id":6928576,"avatar_url":"https://avatars.githubusercontent.com/u/6928576?v=3","gravatar_id":"","url":"https://api.github.com/users/ndedman","html_url":"https://github.com/ndedman","followers_url":"https://api.github.com/users/ndedman/followers","following_url":"https://api.github.com/users/ndedman/following{/other_user}","gists_url":"https://api.github.com/users/ndedman/gists{/gist_id}","starred_url":"https://api.github.com/users/ndedman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ndedman/subscriptions","organizations_url":"https://api.github.com/users/ndedman/orgs","repos_url":"https://api.github.com/users/ndedman/repos","events_url":"https://api.github.com/users/ndedman/events{/privacy}","received_events_url":"https://api.github.com/users/ndedman/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/chembl/user_interface/milestones/4","html_url":"https://github.com/chembl/user_interface/milestones/ChEMBL_22%20Release","labels_url":"https://api.github.com/repos/chembl/user_interface/milestones/4/labels","id":1717107,"number":4,"title":"ChEMBL_22 Release","description":null,"creator":{"login":"agaulton","id":7058697,"avatar_url":"https://avatars.githubusercontent.com/u/7058697?v=3","gravatar_id":"","url":"https://api.github.com/users/agaulton","html_url":"https://github.com/agaulton","followers_url":"https://api.github.com/users/agaulton/followers","following_url":"https://api.github.com/users/agaulton/following{/other_user}","gists_url":"https://api.github.com/users/agaulton/gists{/gist_id}","starred_url":"https://api.github.com/users/agaulton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agaulton/subscriptions","organizations_url":"https://api.github.com/users/agaulton/orgs","repos_url":"https://api.github.com/users/agaulton/repos","events_url":"https://api.github.com/users/agaulton/events{/privacy}","received_events_url":"https://api.github.com/users/agaulton/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":1,"state":"open","created_at":"2016-04-19T14:28:15Z","updated_at":"2016-04-25T15:53:47Z","due_on":null,"closed_at":null},"comments":12,"created_at":"2016-04-19T10:12:35Z","updated_at":"2016-04-27T13:05:25Z","closed_at":null,"body":"\r\n\r\n\r\n1. in browse_drug_targets, if you search for ‘serelaxin’ (molregno 1380624) you’ll find two mechanisms of action: ‘Relaxin receptor 1’ and ‘Relaxin receptor 2’;\r\nif you click on ‘Relaxin receptor 2’ (the one with no mechanism refs), it takes to the target report card and there one should find ’serelaxin’ under the ‘Approved Drugs and Clinical Candidates’ section, but instead no section is displayed. We think this is due to the fact that there’s no mechanism references for these target and potentially there should be an outer join (instead of a join) to the mechanism_refs table.\r\n\r\n2. in browse_drug_targets, if you search again for ’serelaxin’, there’s three refs for ‘Relaxin receptor 1’ but only one, the PubMed ref, is working. There’s different reasons why the other two references do not work:\r\n\r\n - for the first reference ‘Other’, the ref_url in the mechanism_refs table is null (despite the fact there’s a ref_id). Ideally these cases should not be displayed in the interface.\r\n\r\n - for the second reference “Other’, the ref_url from the mechanism_refs tables is in the interface preceded by the ebi/chembl url and therefore the link doesn’t work properly.\r\nThe url that precedes the ref_url is even different depending on which page you are (as expected)\r\n- in the target report card for ‘Relaxin receptor 1’, the link is pointing to 'https://www.ebi.ac.uk/chembl/target/inspect/www.ema.europa.eu/docs/en_GB/document_library/EPAR_-_Public_assessment_report/human/002817/WC500171911.pdf'\r\n- in the browse_drug_targets it is pointing to 'https://www.ebi.ac.uk/chembl/drug/www.ema.europa.eu/docs/en_GB/document_library/EPAR_-_Public_assessment_report/human/002817/WC500171911.pdf'.\r\nAs you can expect, in both cases the link should point to 'www.ema.europa.eu/docs/en_GB/document_library/EPAR_-_Public_assessment_report/human/002817/WC500171911.pdf'.\r\n"},"comment":{"url":"https://api.github.com/repos/chembl/user_interface/issues/comments/215075362","html_url":"https://github.com/chembl/user_interface/issues/39#issuecomment-215075362","issue_url":"https://api.github.com/repos/chembl/user_interface/issues/39","id":215075362,"user":{"login":"ndedman","id":6928576,"avatar_url":"https://avatars.githubusercontent.com/u/6928576?v=3","gravatar_id":"","url":"https://api.github.com/users/ndedman","html_url":"https://github.com/ndedman","followers_url":"https://api.github.com/users/ndedman/followers","following_url":"https://api.github.com/users/ndedman/following{/other_user}","gists_url":"https://api.github.com/users/ndedman/gists{/gist_id}","starred_url":"https://api.github.com/users/ndedman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ndedman/subscriptions","organizations_url":"https://api.github.com/users/ndedman/orgs","repos_url":"https://api.github.com/users/ndedman/repos","events_url":"https://api.github.com/users/ndedman/events{/privacy}","received_events_url":"https://api.github.com/users/ndedman/received_events","type":"User","site_admin":false},"created_at":"2016-04-27T13:05:25Z","updated_at":"2016-04-27T13:05:25Z","body":"Changes deployed to [Dev](https://wwwdev.ebi.ac.uk/chembl/)."}}