{"action":"closed","issue":{"url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/69","repository_url":"https://api.github.com/repos/bo-io-gov-mo/website","labels_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/69/labels{/name}","comments_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/69/comments","events_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/69/events","html_url":"https://github.com/bo-io-gov-mo/website/issues/69","id":174994779,"number":69,"title":"search rank of diplomlvl adjust","user":{"login":"bo-io-gov-mo","id":19220046,"avatar_url":"https://avatars.githubusercontent.com/u/19220046?v=3","gravatar_id":"","url":"https://api.github.com/users/bo-io-gov-mo","html_url":"https://github.com/bo-io-gov-mo","followers_url":"https://api.github.com/users/bo-io-gov-mo/followers","following_url":"https://api.github.com/users/bo-io-gov-mo/following{/other_user}","gists_url":"https://api.github.com/users/bo-io-gov-mo/gists{/gist_id}","starred_url":"https://api.github.com/users/bo-io-gov-mo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bo-io-gov-mo/subscriptions","organizations_url":"https://api.github.com/users/bo-io-gov-mo/orgs","repos_url":"https://api.github.com/users/bo-io-gov-mo/repos","events_url":"https://api.github.com/users/bo-io-gov-mo/events{/privacy}","received_events_url":"https://api.github.com/users/bo-io-gov-mo/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2016-09-05T04:47:41Z","updated_at":"2016-09-08T01:35:11Z","closed_at":"2016-09-08T01:35:10Z","body":"I'm trying to adjust the adjust diplomlvl of text_rank order, to optimize this cases: (the title name not same as inside text's title)\r\nhttp://betan.io.gov.mo/cn/search/?o=0&tab=&s=0&q=%E5%B7%A5%E7%A8%8B%E3%80%81%E5%8F%96%E5%BE%97%E8%B2%A1%E8%B2%A8%E5%8F%8A%E5%8B%9E%E5%8B%99%E4%B9%8B%E9%96%8B%E6%94%AF%E5%88%B6%E5%BA%A6\r\n\r\n\r\nSP GetFilteredTable_all_cn /pt\r\nfrom:\r\n````\r\n...\r\n(CASE WHEN title_Rank > 0 THEN tbl_rank.title_Rank+isNull(FT_TBL.diplomlvl,0)*100 ELSE tbl_rank.title_Rank END) AS [Rank], \r\nFT_TBL.diplomlvl, \r\ntbl_rank.text_Rank,\r\n...\r\n````\r\nto \r\n````\r\n...\r\n(CASE WHEN title_Rank > 0 THEN tbl_rank.title_Rank+isNull(FT_TBL.diplomlvl,0)*100 ELSE tbl_rank.title_Rank END) AS [Rank], \r\nFT_TBL.diplomlvl, \r\ntbl_rank.text_Rank,\r\n (CASE WHEN tbl_rank.text_Rank > 0 THEN tbl_rank.text_Rank+isNull(FT_TBL.diplomlvl,0)*100 ELSE tbl_rank.text_Rank END) AS text_Rank,\r\n...\r\n````\r\n\r\nI will tell you change TAB A query or not later.\r\n\r\n"}}
{"actor":{"display_login":"bo-io-gov-mo"}}