{"action":"created","issue":{"url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/1","labels_url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/1/comments","events_url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/1/events","html_url":"https://github.com/sqlparser/isf_notepad/issues/1","id":74205687,"number":1,"title":"Doesn't work of NP++ v6.7.5 on windows 8.1","user":{"login":"sqlparser","id":1305435,"avatar_url":"https://avatars.githubusercontent.com/u/1305435?v=3","gravatar_id":"","url":"https://api.github.com/users/sqlparser","html_url":"https://github.com/sqlparser","followers_url":"https://api.github.com/users/sqlparser/followers","following_url":"https://api.github.com/users/sqlparser/following{/other_user}","gists_url":"https://api.github.com/users/sqlparser/gists{/gist_id}","starred_url":"https://api.github.com/users/sqlparser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sqlparser/subscriptions","organizations_url":"https://api.github.com/users/sqlparser/orgs","repos_url":"https://api.github.com/users/sqlparser/repos","events_url":"https://api.github.com/users/sqlparser/events{/privacy}","received_events_url":"https://api.github.com/users/sqlparser/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"cnfree","id":1320575,"avatar_url":"https://avatars.githubusercontent.com/u/1320575?v=3","gravatar_id":"","url":"https://api.github.com/users/cnfree","html_url":"https://github.com/cnfree","followers_url":"https://api.github.com/users/cnfree/followers","following_url":"https://api.github.com/users/cnfree/following{/other_user}","gists_url":"https://api.github.com/users/cnfree/gists{/gist_id}","starred_url":"https://api.github.com/users/cnfree/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cnfree/subscriptions","organizations_url":"https://api.github.com/users/cnfree/orgs","repos_url":"https://api.github.com/users/cnfree/repos","events_url":"https://api.github.com/users/cnfree/events{/privacy}","received_events_url":"https://api.github.com/users/cnfree/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-05-08T02:51:40Z","updated_at":"2015-12-16T17:12:20Z","closed_at":null,"body":"I am using v1.01 of the formatter in NP++ v6.7.5 on windows 8.1.\r\n \r\nWhen I try to use the formatter for the following line of SQL it does nothing whatsoever – though if I  run it through your website  formatter it formats perfectly.\r\n \r\nSELECT TOP 5000 n.name_id, COALESCE(n.e_mail_address,'') as Email_address, COALESCE(n.title_code,'') as Title_Code, COALESCE(n.first_name,'') as First_Name, COALESCE(n.last_name,'') as Last_Name, n.ok_to_email, n.ok_to_sell_name,a.country_id,(MAX(li.update_dtm)) as Last_Purchase_date,(COUNT(DISTINCT li. order_number)) as Number_Of_purchases,COALESCE(n.promotion_id,'') as Promotion_Id,SUM(li.product_price) AS Life_time_spend FROM line_item li WITH(nolock) INNER JOIN names n WITH(nolock) ON li.name_id=n.name_id INNER JOIN Addresses A WITH(Nolock) on li.address_id=a.address_id INNER JOIN Orders o ON o.order_number = li.order_number WHERE n.company_id IS NULL AND li.parent_sku IS NULL AND o.Catalog_id NOT IN ('12516','STAPLES','12502','EZIBUY','EZIBUYNZ1','32211','12821','42114','JDWUK','JDWIRE','UKWHOL40','32537','32538','SKYMALL','CUTEKID','11125','11123','US208','UKWHOL40',) AND coalesce(n.e_mail_address,'') <>'' GROUP BY n.Name_id, n.e_mail_address, n.title_code, n.first_name, n.last_name, n.ok_to_email, n.ok_to_sell_name, n.promotion_id, a.country_id ORDER BY Life_time_spend DESC\r\n \r\nEven if I try to format some really simple SQL such as the following it still does nothing:\r\n \r\nselect * from table1 where surname = 'smith' and age > 50 order by cust_id\r\n \r\nI have also tried removing the fo.json file from the plugins/config/sqlformat folder in case that was causing the issue but it made no difference."},"comment":{"url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/comments/165179374","html_url":"https://github.com/sqlparser/isf_notepad/issues/1#issuecomment-165179374","issue_url":"https://api.github.com/repos/sqlparser/isf_notepad/issues/1","id":165179374,"user":{"login":"cnfree","id":1320575,"avatar_url":"https://avatars.githubusercontent.com/u/1320575?v=3","gravatar_id":"","url":"https://api.github.com/users/cnfree","html_url":"https://github.com/cnfree","followers_url":"https://api.github.com/users/cnfree/followers","following_url":"https://api.github.com/users/cnfree/following{/other_user}","gists_url":"https://api.github.com/users/cnfree/gists{/gist_id}","starred_url":"https://api.github.com/users/cnfree/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cnfree/subscriptions","organizations_url":"https://api.github.com/users/cnfree/orgs","repos_url":"https://api.github.com/users/cnfree/repos","events_url":"https://api.github.com/users/cnfree/events{/privacy}","received_events_url":"https://api.github.com/users/cnfree/received_events","type":"User","site_admin":false},"created_at":"2015-12-16T17:12:20Z","updated_at":"2015-12-16T17:12:20Z","body":"I can't reproduce your problem  in NP++ v6.7.5 on windows 8.1. Please check your network, it should enable to access the website http://www.gudusoft.com/format.php.\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1320575/11847977/f4e097de-a45a-11e5-9519-e99e18425ddb.png)\r\n"}}