{"action":"created","issue":{"url":"https://api.github.com/repos/BasisHub/components/issues/100","repository_url":"https://api.github.com/repos/BasisHub/components","labels_url":"https://api.github.com/repos/BasisHub/components/issues/100/labels{/name}","comments_url":"https://api.github.com/repos/BasisHub/components/issues/100/comments","events_url":"https://api.github.com/repos/BasisHub/components/issues/100/events","html_url":"https://github.com/BasisHub/components/issues/100","id":327228584,"node_id":"MDU6SXNzdWUzMjcyMjg1ODQ=","number":100,"title":"SqlTableBC uses a SELECT statement with WHERE 1=0 to get result meta data, which is slow in BBj database","user":{"login":"StephanWald","id":4833070,"node_id":"MDQ6VXNlcjQ4MzMwNzA=","avatar_url":"https://avatars3.githubusercontent.com/u/4833070?v=4","gravatar_id":"","url":"https://api.github.com/users/StephanWald","html_url":"https://github.com/StephanWald","followers_url":"https://api.github.com/users/StephanWald/followers","following_url":"https://api.github.com/users/StephanWald/following{/other_user}","gists_url":"https://api.github.com/users/StephanWald/gists{/gist_id}","starred_url":"https://api.github.com/users/StephanWald/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StephanWald/subscriptions","organizations_url":"https://api.github.com/users/StephanWald/orgs","repos_url":"https://api.github.com/users/StephanWald/repos","events_url":"https://api.github.com/users/StephanWald/events{/privacy}","received_events_url":"https://api.github.com/users/StephanWald/received_events","type":"User","site_admin":false},"labels":[{"id":43640011,"node_id":"MDU6TGFiZWw0MzY0MDAxMQ==","url":"https://api.github.com/repos/BasisHub/components/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"closed","locked":false,"assignee":{"login":"StephanWald","id":4833070,"node_id":"MDQ6VXNlcjQ4MzMwNzA=","avatar_url":"https://avatars3.githubusercontent.com/u/4833070?v=4","gravatar_id":"","url":"https://api.github.com/users/StephanWald","html_url":"https://github.com/StephanWald","followers_url":"https://api.github.com/users/StephanWald/followers","following_url":"https://api.github.com/users/StephanWald/following{/other_user}","gists_url":"https://api.github.com/users/StephanWald/gists{/gist_id}","starred_url":"https://api.github.com/users/StephanWald/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StephanWald/subscriptions","organizations_url":"https://api.github.com/users/StephanWald/orgs","repos_url":"https://api.github.com/users/StephanWald/repos","events_url":"https://api.github.com/users/StephanWald/events{/privacy}","received_events_url":"https://api.github.com/users/StephanWald/received_events","type":"User","site_admin":false},"assignees":[{"login":"StephanWald","id":4833070,"node_id":"MDQ6VXNlcjQ4MzMwNzA=","avatar_url":"https://avatars3.githubusercontent.com/u/4833070?v=4","gravatar_id":"","url":"https://api.github.com/users/StephanWald","html_url":"https://github.com/StephanWald","followers_url":"https://api.github.com/users/StephanWald/followers","following_url":"https://api.github.com/users/StephanWald/following{/other_user}","gists_url":"https://api.github.com/users/StephanWald/gists{/gist_id}","starred_url":"https://api.github.com/users/StephanWald/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StephanWald/subscriptions","organizations_url":"https://api.github.com/users/StephanWald/orgs","repos_url":"https://api.github.com/users/StephanWald/repos","events_url":"https://api.github.com/users/StephanWald/events{/privacy}","received_events_url":"https://api.github.com/users/StephanWald/received_events","type":"User","site_admin":false},{"login":"DaAmore","id":36035625,"node_id":"MDQ6VXNlcjM2MDM1NjI1","avatar_url":"https://avatars3.githubusercontent.com/u/36035625?v=4","gravatar_id":"","url":"https://api.github.com/users/DaAmore","html_url":"https://github.com/DaAmore","followers_url":"https://api.github.com/users/DaAmore/followers","following_url":"https://api.github.com/users/DaAmore/following{/other_user}","gists_url":"https://api.github.com/users/DaAmore/gists{/gist_id}","starred_url":"https://api.github.com/users/DaAmore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaAmore/subscriptions","organizations_url":"https://api.github.com/users/DaAmore/orgs","repos_url":"https://api.github.com/users/DaAmore/repos","events_url":"https://api.github.com/users/DaAmore/events{/privacy}","received_events_url":"https://api.github.com/users/DaAmore/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-05-29T08:59:00Z","updated_at":"2018-10-18T12:32:46Z","closed_at":"2018-10-18T12:32:46Z","author_association":"CONTRIBUTOR","body":"This turns out to be slow in the BBj Database as BBj seems to execute the full statement. Can we use something better, like a \"SELECT TOP 1\" in BBj. Examine if this is faster.\r\n\r\n(Use a large table to test with, like a DMS Parts Catalogue)"},"comment":{"url":"https://api.github.com/repos/BasisHub/components/issues/comments/430990726","html_url":"https://github.com/BasisHub/components/issues/100#issuecomment-430990726","issue_url":"https://api.github.com/repos/BasisHub/components/issues/100","id":430990726,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMDk5MDcyNg==","user":{"login":"DaAmore","id":36035625,"node_id":"MDQ6VXNlcjM2MDM1NjI1","avatar_url":"https://avatars3.githubusercontent.com/u/36035625?v=4","gravatar_id":"","url":"https://api.github.com/users/DaAmore","html_url":"https://github.com/DaAmore","followers_url":"https://api.github.com/users/DaAmore/followers","following_url":"https://api.github.com/users/DaAmore/following{/other_user}","gists_url":"https://api.github.com/users/DaAmore/gists{/gist_id}","starred_url":"https://api.github.com/users/DaAmore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaAmore/subscriptions","organizations_url":"https://api.github.com/users/DaAmore/orgs","repos_url":"https://api.github.com/users/DaAmore/repos","events_url":"https://api.github.com/users/DaAmore/events{/privacy}","received_events_url":"https://api.github.com/users/DaAmore/received_events","type":"User","site_admin":false},"created_at":"2018-10-18T12:32:46Z","updated_at":"2018-10-18T12:32:46Z","author_association":"CONTRIBUTOR","body":"Finished"}}
{"actor":{"display_login":"DaAmore"}}