{"action":"created","issue":{"url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/35","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/35/labels{/name}","comments_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/35/comments","events_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/35/events","html_url":"https://github.com/bo-io-gov-mo/website/issues/35","id":170807279,"number":35,"title":"search performace","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":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":67,"created_at":"2016-08-12T06:30:05Z","updated_at":"2016-08-26T06:29:06Z","closed_at":null,"body":"http://betan.io.gov.mo/cn/search/?sc=0&tab=&q=%E9%81%8A%E8%89%87\r\n![image](https://cloud.githubusercontent.com/assets/19220046/17581734/28139896-5fda-11e6-9566-70c684b9b394.png)\r\n\r\nhttp://betan.io.gov.mo/cn/search/?sc=0&tab=&q=%E6%BE%B3%E9%96%80\r\n![image](https://cloud.githubusercontent.com/assets/19220046/17581711/f5150c86-5fd9-11e6-819b-9defaed9a3f2.png)\r\n"},"comment":{"url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/comments/242641172","html_url":"https://github.com/bo-io-gov-mo/website/issues/35#issuecomment-242641172","issue_url":"https://api.github.com/repos/bo-io-gov-mo/website/issues/35","id":242641172,"user":{"login":"xiquinho","id":3314293,"avatar_url":"https://avatars.githubusercontent.com/u/3314293?v=3","gravatar_id":"","url":"https://api.github.com/users/xiquinho","html_url":"https://github.com/xiquinho","followers_url":"https://api.github.com/users/xiquinho/followers","following_url":"https://api.github.com/users/xiquinho/following{/other_user}","gists_url":"https://api.github.com/users/xiquinho/gists{/gist_id}","starred_url":"https://api.github.com/users/xiquinho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xiquinho/subscriptions","organizations_url":"https://api.github.com/users/xiquinho/orgs","repos_url":"https://api.github.com/users/xiquinho/repos","events_url":"https://api.github.com/users/xiquinho/events{/privacy}","received_events_url":"https://api.github.com/users/xiquinho/received_events","type":"User","site_admin":false},"created_at":"2016-08-26T06:29:06Z","updated_at":"2016-08-26T06:29:06Z","body":"I have now 3 queries for text:\r\n\r\na)\tThe original query you post in te first issu\r\nb)\tThe query in search 2015 before the SP in the comment above\r\nc)\tThe final query in the SP\r\n\r\nI’m confused which should I use. I am going to change with this below for title only, please confirm and send me one similar for text.\r\n\r\nWITH result_set AS \r\n(SELECT ROW_NUMBER() OVER (ORDER BY title_Rank DESC, DatePublished DESC) AS [row_number], TBL_Display.LinkID, TBL_Display.Tab , TBL_Display.DipName, TBL_Display.DipDesc, TBL_Display.DatePublished, TBL_Display.DiplomUrl, TBL_Display.BONumber, TBL_Display.BOYear, TBL_Display.Serie, TBL_Display.suplemento,  TBL_Display.diplomlvl, TBL_Display.org_title_Rank, TBL_Display.title_Rank as rank FROM (SELECT FT_TBL.LinkID, FT_TBL.CAT AS Tab,FT_TBL.DiplomNamecn AS DipName,FT_TBL.DiplomDesccn AS DipDesc,FT_TBL.DiplomUrl, FT_TBL.BONumber, FT_TBL.BOYear, FT_TBL.Serie, FT_TBL.suplemento , Title_Rank as org_title_Rank,(tbl_rank.title_Rank+isNull(FT_TBL.diplomlvl,0)*100) AS title_Rank, FT_TBL.diplomlvl,FT_TBL.DatePublished\r\n FROM vwIndexQuery AS FT_TBL INNER JOIN \r\n(\r\n SELECT t.Title_Rank AS Title_RANK, s.tboID,s.LinkID,s.tab FROM (SELECT [KEY], Rank as Title_Rank FROM CONTAINSTABLE(search, title_cn, N'澳門',language 1033))as t inner join Search as s on t.[key]=s.tboID\r\n)\r\nAS TBL_Rank on (FT_TBL.LinkID=TBL_Rank.LinkID and FT_TBL.cat=TBL_Rank.tab)) AS TBL_Display\r\n) SELECT * FROM result_set WHERE [row_number] BETWEEN 0 AND 24\r\n"}}
{"actor":{"display_login":"xiquinho"}}