{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":520225885,"defaultBranch":"main","name":"Polaris_TSQL","ownerLogin":"kevintfrench","currentUserCanPush":false,"isFork":true,"isEmpty":false,"createdAt":"2022-08-01T18:45:36.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/1636819?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1686584525.156786","currentOid":""},"activityList":{"items":[{"before":"7aa9b4233ba39ef40186a47d96a7dcfbca82bb45","after":"cfdc2015e6d48cee6c2fd238d34e63cb3d21c82c","ref":"refs/heads/main","pushedAt":"2024-08-26T17:03:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create SQL_Server_Jobs_List_Schedule.sql","shortMessageHtmlLink":"Create SQL_Server_Jobs_List_Schedule.sql"}},{"before":"c112b7b83910c1b6ab25de764671f9daf5e9734c","after":"7aa9b4233ba39ef40186a47d96a7dcfbca82bb45","ref":"refs/heads/main","pushedAt":"2024-08-14T19:55:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #11 from kevintfrench/main\n\nCreate Invoice Line Items Transaction Counts.sql","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2466718326\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GMILCS/Polaris-TSQL/issues/11\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GMILCS/Polaris-TSQL/pull/11/hovercard\" href=\"https://github.com/GMILCS/Polaris-TSQL/pull/11\">GMILCS#11</a> from kevintfrench/main"}},{"before":"94709822d0d74c6d4dde727c65e9902b0ad90a6a","after":"c112b7b83910c1b6ab25de764671f9daf5e9734c","ref":"refs/heads/main","pushedAt":"2024-08-14T19:54:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create Invoice Line Items Transaction Counts.sql","shortMessageHtmlLink":"Create Invoice Line Items Transaction Counts.sql"}},{"before":"f161260a693c0c1715257d836d025d7a443687d6","after":"94709822d0d74c6d4dde727c65e9902b0ad90a6a","ref":"refs/heads/main","pushedAt":"2024-08-14T19:51:33.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #10 from kevintfrench/main\n\nCreate FindTool No longer used record sets.sql","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2466496531\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GMILCS/Polaris-TSQL/issues/10\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GMILCS/Polaris-TSQL/pull/10/hovercard\" href=\"https://github.com/GMILCS/Polaris-TSQL/pull/10\">GMILCS#10</a> from kevintfrench/main"}},{"before":"0cd5dc8cd7eeace6551567e00894329148d015dc","after":"f161260a693c0c1715257d836d025d7a443687d6","ref":"refs/heads/main","pushedAt":"2024-08-14T18:02:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create FindTool No longer used record sets.sql","shortMessageHtmlLink":"Create FindTool No longer used record sets.sql"}},{"before":"d316bd22a3eaffe86266efc93df69a19dbb7fb51","after":"0cd5dc8cd7eeace6551567e00894329148d015dc","ref":"refs/heads/main","pushedAt":"2024-08-02T13:30:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Update FindTool_retrieve_patrons_with_incomplete_phone.sql","shortMessageHtmlLink":"Update FindTool_retrieve_patrons_with_incomplete_phone.sql"}},{"before":"445d3439bbc94b1a8a3ccf4a6cfd0e5911962253","after":"d316bd22a3eaffe86266efc93df69a19dbb7fb51","ref":"refs/heads/main","pushedAt":"2024-07-31T15:46:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #8 from kevintfrench/main\n\nUpdate Polaris-TSQL","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2440371409\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GMILCS/Polaris-TSQL/issues/8\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GMILCS/Polaris-TSQL/pull/8/hovercard\" href=\"https://github.com/GMILCS/Polaris-TSQL/pull/8\">GMILCS#8</a> from kevintfrench/main"}},{"before":"47ee9c1f0676991da59587879e869c862b95b9f1","after":"445d3439bbc94b1a8a3ccf4a6cfd0e5911962253","ref":"refs/heads/main","pushedAt":"2024-07-31T15:44:27.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge branch 'GMILCS:main' into main","shortMessageHtmlLink":"Merge branch 'GMILCS:main' into main"}},{"before":"27176786cc9c9ddd34f8b77b4e0cd801a0d22d02","after":"47ee9c1f0676991da59587879e869c862b95b9f1","ref":"refs/heads/main","pushedAt":"2024-07-31T15:44:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create Holds_Data_with_Final_Statuses.sql","shortMessageHtmlLink":"Create Holds_Data_with_Final_Statuses.sql"}},{"before":"3fe023a04910fd79e07984365ac7bf3fae320582","after":"27176786cc9c9ddd34f8b77b4e0cd801a0d22d02","ref":"refs/heads/main","pushedAt":"2024-07-30T14:11:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create unclaimed_holds_with_patron_info.sql","shortMessageHtmlLink":"Create unclaimed_holds_with_patron_info.sql"}},{"before":"7c62c3c156b166d30c10d6427e97e5e634cad190","after":"3fe023a04910fd79e07984365ac7bf3fae320582","ref":"refs/heads/main","pushedAt":"2024-05-08T13:27:42.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #6 from kevintfrench/main\n\nAdding SQL","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2285601927\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GMILCS/Polaris-TSQL/issues/6\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GMILCS/Polaris-TSQL/pull/6/hovercard\" href=\"https://github.com/GMILCS/Polaris-TSQL/pull/6\">GMILCS#6</a> from kevintfrench/main"}},{"before":"0b4fbdf2a257d9131ea3c5de724b2088ddd8d36f","after":"7c62c3c156b166d30c10d6427e97e5e634cad190","ref":"refs/heads/main","pushedAt":"2024-04-24T13:41:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create FindTool_retrieve_patrons_with_incomplete_phone.sql","shortMessageHtmlLink":"Create FindTool_retrieve_patrons_with_incomplete_phone.sql"}},{"before":"8805fe36c99a8a7394a8c2873975c37ec4d7370e","after":"0b4fbdf2a257d9131ea3c5de724b2088ddd8d36f","ref":"refs/heads/main","pushedAt":"2024-04-24T13:40:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Create low_circulating_items.sql","shortMessageHtmlLink":"Create low_circulating_items.sql"}},{"before":"5e121564f899d541615a470c342a7ebc5ee48f8d","after":"8805fe36c99a8a7394a8c2873975c37ec4d7370e","ref":"refs/heads/main","pushedAt":"2024-04-24T13:37:06.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge branch 'GMILCS:main' into main","shortMessageHtmlLink":"Merge branch 'GMILCS:main' into main"}},{"before":"7c49d58bd6a1a02273f615ca787a14b52bcdad42","after":"5e121564f899d541615a470c342a7ebc5ee48f8d","ref":"refs/heads/main","pushedAt":"2024-04-20T01:27:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"add exec","shortMessageHtmlLink":"add exec"}},{"before":"b2d3b1c11524f769e073358a8fa8ccd0f42150cc","after":"7c49d58bd6a1a02273f615ca787a14b52bcdad42","ref":"refs/heads/main","pushedAt":"2024-03-19T20:42:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add Find Dormant Polaris Users","shortMessageHtmlLink":"Add Find Dormant Polaris Users"}},{"before":"1ab5069986e4bb7dd9de6fc815efd91a9f9484cd","after":"b2d3b1c11524f769e073358a8fa8ccd0f42150cc","ref":"refs/heads/main","pushedAt":"2024-03-19T20:40:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add Pull Email List for Patrons Based on Circ Activity","shortMessageHtmlLink":"Add Pull Email List for Patrons Based on Circ Activity"}},{"before":"3e94a917762ea55b8ca5636e13bd17aade2daffc","after":"1ab5069986e4bb7dd9de6fc815efd91a9f9484cd","ref":"refs/heads/main","pushedAt":"2024-03-19T20:37:50.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add Item Records in Smaller Collections","shortMessageHtmlLink":"Add Item Records in Smaller Collections"}},{"before":"ba73558afa616bf6d6f541720a8588beb6f34c46","after":"3e94a917762ea55b8ca5636e13bd17aade2daffc","ref":"refs/heads/main","pushedAt":"2024-03-19T20:35:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add Items replaced","shortMessageHtmlLink":"Add Items replaced"}},{"before":"276868c10fd990b233edbdeaf1e08d4fa94d8f0a","after":"ba73558afa616bf6d6f541720a8588beb6f34c46","ref":"refs/heads/main","pushedAt":"2024-03-19T20:31:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"add circulation count by patron statistical class","shortMessageHtmlLink":"add circulation count by patron statistical class"}},{"before":"91be166f4779d6b2c2699446ef8ce56ebc32e014","after":"276868c10fd990b233edbdeaf1e08d4fa94d8f0a","ref":"refs/heads/main","pushedAt":"2024-03-19T20:16:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"add hold counts","shortMessageHtmlLink":"add hold counts"}},{"before":"98ca3c8421fa5de9681aeb81c524f3c9a7aa931b","after":"91be166f4779d6b2c2699446ef8ce56ebc32e014","ref":"refs/heads/main","pushedAt":"2024-03-19T19:50:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #4 from kevintfrench/main\n\nadd withdrawn","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1928952069\" data-permission-text=\"Title is private\" data-url=\"https://github.com/GMILCS/Polaris-TSQL/issues/4\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/GMILCS/Polaris-TSQL/pull/4/hovercard\" href=\"https://github.com/GMILCS/Polaris-TSQL/pull/4\">GMILCS#4</a> from kevintfrench/main"}},{"before":"f19d30b5b3e0f308d9941cee3cd8f27d069e8ba4","after":"98ca3c8421fa5de9681aeb81c524f3c9a7aa931b","ref":"refs/heads/main","pushedAt":"2023-10-05T19:45:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"add withdrawn","shortMessageHtmlLink":"add withdrawn"}},{"before":"fb457dea224e2a89fa43556dc7fafb49bfc111c8","after":"f19d30b5b3e0f308d9941cee3cd8f27d069e8ba4","ref":"refs/heads/main","pushedAt":"2023-08-28T14:19:43.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add bib find","shortMessageHtmlLink":"Add bib find"}},{"before":"10a885db2ca25cc6424a5c7644a12c62467d35a3","after":"fb457dea224e2a89fa43556dc7fafb49bfc111c8","ref":"refs/heads/main","pushedAt":"2023-08-06T18:58:17.000Z","pushType":"pr_merge","commitsCount":94,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Merge pull request #1 from GMILCS/main\n\ncatch up","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1838305382\" data-permission-text=\"Title is private\" data-url=\"https://github.com/kevintfrench/Polaris_TSQL/issues/1\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/kevintfrench/Polaris_TSQL/pull/1/hovercard\" href=\"https://github.com/kevintfrench/Polaris_TSQL/pull/1\">#1</a> from GMILCS/main"}},{"before":"a41837fa5982757ea2d33bec267529d47baa5a33","after":"10a885db2ca25cc6424a5c7644a12c62467d35a3","ref":"refs/heads/main","pushedAt":"2023-06-12T15:42:05.042Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"f81f8c5c4624c64bc87d74ef6ed452703c6fdb1c","after":"a41837fa5982757ea2d33bec267529d47baa5a33","ref":"refs/heads/main","pushedAt":"2023-04-12T13:55:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"kevintfrench","name":"Kevin French","path":"/kevintfrench","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1636819?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0yNlQxNzowMzozMi4wMDAwMDBazwAAAASkf3Ko","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNC0xMlQxMzo1NToyNC4wMDAwMDBazwAAAAMXMuA1"}},"title":"Activity · kevintfrench/Polaris_TSQL"}