{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":118617073,"defaultBranch":"master","name":"SQL","ownerLogin":"Thallerich","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2018-01-23T13:52:52.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/20878157?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1516715573.0","currentOid":""},"activityList":{"items":[{"before":"b171f839afa87c9d7c3a3cab4df60f8f82278253","after":"6b9c9d73fa668ed3ed5b7605ec84a983c963cb1b","ref":"refs/heads/master","pushedAt":"2024-07-02T10:39:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"rolled back previous changes and impl. break logic","shortMessageHtmlLink":"rolled back previous changes and impl. break logic"}},{"before":"6cad847295b7aa75ce92b5fb56c16510752f6951","after":"b171f839afa87c9d7c3a3cab4df60f8f82278253","ref":"refs/heads/master","pushedAt":"2024-07-02T08:17:07.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"performance optimization","shortMessageHtmlLink":"performance optimization"}},{"before":"69275b6e916e303c78847ca5d85ab6a6ab36b6ae","after":"6cad847295b7aa75ce92b5fb56c16510752f6951","ref":"refs/heads/master","pushedAt":"2024-07-01T11:39:17.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-84137\n - initial version","shortMessageHtmlLink":"IT-84137"}},{"before":"bd35b9ca29368f8b28eb5384bb739f81b770f9b8","after":"69275b6e916e303c78847ca5d85ab6a6ab36b6ae","ref":"refs/heads/master","pushedAt":"2024-07-01T08:04:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-83871\n - bugfix percentage calculation","shortMessageHtmlLink":"IT-83871"}},{"before":"38e6f6105fe219a4769af90c3d8b5a891bd5e3c9","after":"bd35b9ca29368f8b28eb5384bb739f81b770f9b8","ref":"refs/heads/master","pushedAt":"2024-06-27T13:35:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version","shortMessageHtmlLink":"initial version"}},{"before":"54a07a6baa6814ef55fdc27c3a1a8471ffe4eaf6","after":"38e6f6105fe219a4769af90c3d8b5a891bd5e3c9","ref":"refs/heads/master","pushedAt":"2024-06-14T07:00:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"added customers 15001, 15007","shortMessageHtmlLink":"added customers 15001, 15007"}},{"before":"d743bcb1e8adbf7035b91102c1d23c23dced11c0","after":"54a07a6baa6814ef55fdc27c3a1a8471ffe4eaf6","ref":"refs/heads/master","pushedAt":"2024-06-13T12:59:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version","shortMessageHtmlLink":"initial version"}},{"before":"f28c1e82366e5f101ed6a3f204be6d97ced239ee","after":"d743bcb1e8adbf7035b91102c1d23c23dced11c0","ref":"refs/heads/master","pushedAt":"2024-06-11T14:25:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version","shortMessageHtmlLink":"initial version"}},{"before":"93f2d5c560ce4f2036f282b460cdd51859d18309","after":"f28c1e82366e5f101ed6a3f204be6d97ced239ee","ref":"refs/heads/master","pushedAt":"2024-06-11T07:33:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"added \"additional_info\" column","shortMessageHtmlLink":"added \"additional_info\" column"}},{"before":"112a82644a7e5943392dc1c459c4fe636b701e16","after":"93f2d5c560ce4f2036f282b460cdd51859d18309","ref":"refs/heads/master","pushedAt":"2024-06-10T11:06:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-83616\n - reused script from IT-83535\n - support using an import-table","shortMessageHtmlLink":"IT-83616"}},{"before":"97af0cfc36c1ca76379aa530673e73ae0030a3c2","after":"112a82644a7e5943392dc1c459c4fe636b701e16","ref":"refs/heads/master","pushedAt":"2024-06-10T08:13:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"show blocking in last hour by default","shortMessageHtmlLink":"show blocking in last hour by default"}},{"before":"ec8f806e2f39c1aedcd397acbb534fbe375c4455","after":"97af0cfc36c1ca76379aa530673e73ae0030a3c2","ref":"refs/heads/master","pushedAt":"2024-06-10T08:13:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"refined activation on central server","shortMessageHtmlLink":"refined activation on central server"}},{"before":"57bc382ec258dfa3d602e6954901c01a6f6d4759","after":"ec8f806e2f39c1aedcd397acbb534fbe375c4455","ref":"refs/heads/master","pushedAt":"2024-06-06T11:18:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"added flag if invoice has been printed","shortMessageHtmlLink":"added flag if invoice has been printed"}},{"before":"c6471ec9d2432f10c6100759caa2c3e11c49aa82","after":"57bc382ec258dfa3d602e6954901c01a6f6d4759","ref":"refs/heads/master","pushedAt":"2024-06-06T06:57:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-83562\n - added a parameter to only count active \"Q\" parts","shortMessageHtmlLink":"IT-83562"}},{"before":"a32ec31f5880a31d98d65fa7522506061a482270","after":"c6471ec9d2432f10c6100759caa2c3e11c49aa82","ref":"refs/heads/master","pushedAt":"2024-06-06T06:39:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"bugfix\n - VsaLeasChange finished","shortMessageHtmlLink":"bugfix"}},{"before":"272726fc41308f14af460619a4a065070a518de0","after":"a32ec31f5880a31d98d65fa7522506061a482270","ref":"refs/heads/master","pushedAt":"2024-06-05T14:10:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-83547\n - initial version","shortMessageHtmlLink":"IT-83547"}},{"before":"29f22ad06d00140fa81bdcd027f3d6ed540e647b","after":"272726fc41308f14af460619a4a065070a518de0","ref":"refs/heads/master","pushedAt":"2024-06-05T09:23:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"use INFORMATION_SCHEMA for easier reporting","shortMessageHtmlLink":"use INFORMATION_SCHEMA for easier reporting"}},{"before":"fcaf90b1feefa9b86608019916a85af4da91add7","after":"29f22ad06d00140fa81bdcd027f3d6ed540e647b","ref":"refs/heads/master","pushedAt":"2024-06-05T08:00:58.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"added preliminary script for vsaleas-change","shortMessageHtmlLink":"added preliminary script for vsaleas-change"}},{"before":"2fbb7745b87fbcb3a3f11a37feb58993ffd9a5a1","after":"fcaf90b1feefa9b86608019916a85af4da91add7","ref":"refs/heads/master","pushedAt":"2024-06-04T12:35:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-82668 - initial version\ninsert new article as a copy of existing ones (list)","shortMessageHtmlLink":"IT-82668 - initial version"}},{"before":"c92b193251197f84f8557a907184c43ffbe174a1","after":"2fbb7745b87fbcb3a3f11a37feb58993ffd9a5a1","ref":"refs/heads/master","pushedAt":"2024-06-04T11:18:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"bugfix\n - DROP temp tables in the end","shortMessageHtmlLink":"bugfix"}},{"before":"3e2bf5af1f3e6510024045bc90dec17fdcd215b7","after":"c92b193251197f84f8557a907184c43ffbe174a1","ref":"refs/heads/master","pushedAt":"2024-06-04T11:16:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"IT-82420 - initial version\nscript to change article of pool parts\nanalog to function \"Artikelwechsel (Poolteile)\" in AdvanTex","shortMessageHtmlLink":"IT-82420 - initial version"}},{"before":"d5b6f4aa8f95500a230e1c0a9867072bb7a1a4ed","after":"3e2bf5af1f3e6510024045bc90dec17fdcd215b7","ref":"refs/heads/master","pushedAt":"2024-06-04T07:04:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version","shortMessageHtmlLink":"initial version"}},{"before":"52f02cf0882852182b82556ffbea3d74e01f9ef4","after":"d5b6f4aa8f95500a230e1c0a9867072bb7a1a4ed","ref":"refs/heads/master","pushedAt":"2024-06-03T08:25:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"bugfix\n - do not check for curreinzhist","shortMessageHtmlLink":"bugfix"}},{"before":"e764d962c354906d8474c7c8204687bce5270a37","after":"52f02cf0882852182b82556ffbea3d74e01f9ef4","ref":"refs/heads/master","pushedAt":"2024-06-03T05:33:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"delete scans from 2020 next :)","shortMessageHtmlLink":"delete scans from 2020 next :)"}},{"before":"044c5ffeefb44e9d9f7a22771144e90f45a293e6","after":"e764d962c354906d8474c7c8204687bce5270a37","ref":"refs/heads/master","pushedAt":"2024-05-29T13:32:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"only reset \"temporary server error\"","shortMessageHtmlLink":"only reset \"temporary server error\""}},{"before":"b544b3e1edeca037b2bb50d27fc3413db3757dd5","after":"044c5ffeefb44e9d9f7a22771144e90f45a293e6","ref":"refs/heads/master","pushedAt":"2024-05-29T12:13:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version","shortMessageHtmlLink":"initial version"}},{"before":"555ee81e9e11710ce2fa8dc2f783e47b91b7be14","after":"b544b3e1edeca037b2bb50d27fc3413db3757dd5","ref":"refs/heads/master","pushedAt":"2024-05-28T09:54:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"initial version as copy of 997a","shortMessageHtmlLink":"initial version as copy of 997a"}},{"before":"0bc396106cb831b7087305868bb2ce7b2be5d93b","after":"555ee81e9e11710ce2fa8dc2f783e47b91b7be14","ref":"refs/heads/master","pushedAt":"2024-05-27T11:11:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"bugfix and optimization\n - rewrote prep-query completely\n - include sets at customer now too","shortMessageHtmlLink":"bugfix and optimization"}},{"before":"8211c320f8d57db59d0a11a8062dd348ffc256b8","after":"0bc396106cb831b7087305868bb2ce7b2be5d93b","ref":"refs/heads/master","pushedAt":"2024-05-27T10:21:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"bugfix\n - split into two selects into a temp table\n - separate report pipeline","shortMessageHtmlLink":"bugfix"}},{"before":"64185461f486b16b98801622773f14ca590042f7","after":"8211c320f8d57db59d0a11a8062dd348ffc256b8","ref":"refs/heads/master","pushedAt":"2024-05-27T08:37:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Thallerich","name":null,"path":"/Thallerich","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/20878157?s=80&v=4"},"commit":{"message":"simplified import / new import table structure","shortMessageHtmlLink":"simplified import / new import table structure"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEdK_R-AA","startCursor":null,"endCursor":null}},"title":"Activity · Thallerich/SQL"}