{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":464821645,"defaultBranch":"main","name":"NQL","ownerLogin":"TryGhost","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2022-03-01T09:14:20.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2178663?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1716780549.0","currentOid":""},"activityList":{"items":[{"before":"35cc4630082ebe5a1a83b7d4addc10f4617836a4","after":"2430c78933951d7d0ff213ee4774a352c74bf914","ref":"refs/heads/renovate/major-lerna-monorepo","pushedAt":"2024-05-27T03:28:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update dependency lerna to v8","shortMessageHtmlLink":"Update dependency lerna to v8"}},{"before":"a76803941547ddef92fae1d07281d15d22bc15c8","after":"4b6e08593d6600364809700acd5897e28274fdb2","ref":"refs/heads/renovate/date-fns-3.x","pushedAt":"2024-05-27T03:28:31.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update dependency date-fns to v3","shortMessageHtmlLink":"Update dependency date-fns to v3"}},{"before":"c6e709b1dfd145758c2715bd49e164406516a183","after":"9e15edf7a824fe0defce5530af20d32fe284c2fd","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-27T03:28:16.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"0fefd542d0efe0373dc1f7344ad1c7a5064af63c","after":"f4c78d1b2235fcbfad60ac1e0d77e91d396d2ed7","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-27T03:27:53.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"f145c6ea4bf361c5e4729567c43ac9b284108ceb","after":null,"ref":"refs/heads/renovate/lock-file-maintenance","pushedAt":"2024-05-27T03:27:07.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"}},{"before":"532d83ff7ba34b8aad64198c790976d4e2a864ed","after":"f145c6ea4bf361c5e4729567c43ac9b284108ceb","ref":"refs/heads/main","pushedAt":"2024-05-27T03:27:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Lock file maintenance","shortMessageHtmlLink":"Lock file maintenance"}},{"before":null,"after":"f145c6ea4bf361c5e4729567c43ac9b284108ceb","ref":"refs/heads/renovate/lock-file-maintenance","pushedAt":"2024-05-27T00:04:02.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Lock file maintenance","shortMessageHtmlLink":"Lock file maintenance"}},{"before":"9ac3c7898424e4aa4be23cb33dd2fc0ddb147ebc","after":"b0baa1bc52948d9dd129735129cdd05bfe60f472","ref":"refs/heads/renovate/sqlite3-5.x","pushedAt":"2024-05-23T12:40:06.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update dependency sqlite3 to v5.1.7","shortMessageHtmlLink":"Update dependency sqlite3 to v5.1.7"}},{"before":"bce27162d6219bd40e7af16d36ea7e9be6c2c622","after":"c6e709b1dfd145758c2715bd49e164406516a183","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-15T21:41:07.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"0b41bb3280bf30f9534d6fdd5682ce7a1a2e1c46","after":"bce27162d6219bd40e7af16d36ea7e9be6c2c622","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-13T13:53:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"3ad8e3416f6766199986e2005c3391014d9c0aa3","after":"0fefd542d0efe0373dc1f7344ad1c7a5064af63c","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-13T13:53:28.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"392b46b5ecaa178d9603d5765471d6b5e90d3180","after":"0b41bb3280bf30f9534d6fdd5682ce7a1a2e1c46","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-13T13:52:40.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"f15b46b7cfad4964cbe929370d0f6a57d31c4064","after":"3ad8e3416f6766199986e2005c3391014d9c0aa3","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-13T13:52:22.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"36a9e21a6163be5060700a9dad0685e3c36fb24c","after":"532d83ff7ba34b8aad64198c790976d4e2a864ed","ref":"refs/heads/main","pushedAt":"2024-05-13T13:52:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"},"commit":{"message":"Published new versions\n\n - @tryghost/nql@0.12.3","shortMessageHtmlLink":"Published new versions"}},{"before":"01376d87f15c268b3a6e1a62ae3b046999377759","after":null,"ref":"refs/heads/patch-combine-ne-filters","pushedAt":"2024-05-13T13:51:32.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"}},{"before":"05d6f24d2fb66f545ac51f939d3857b395bf8805","after":"36a9e21a6163be5060700a9dad0685e3c36fb24c","ref":"refs/heads/main","pushedAt":"2024-05-13T13:51:31.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"},"commit":{"message":"Added handling for nested statements when combining ne filters (#79)\n\nref https://linear.app/tryghost/issue/CFR-27\r\n- the combineNeFilters performance improvement will now work with nested operators\r\n\r\nSome Ghost serializers wrap the filter strings, so we need to be able to handle nested statements in order for the performance improvement to be useful, specifically with {{#get}} helpers fetching posts.","shortMessageHtmlLink":"Added handling for nested statements when combining ne filters (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2292887406\" data-permission-text=\"Title is private\" data-url=\"https://github.com/TryGhost/NQL/issues/79\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/TryGhost/NQL/pull/79/hovercard\" href=\"https://github.com/TryGhost/NQL/pull/79\">#79</a>)"}},{"before":null,"after":"01376d87f15c268b3a6e1a62ae3b046999377759","ref":"refs/heads/patch-combine-ne-filters","pushedAt":"2024-05-13T13:49:11.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"},"commit":{"message":"Added handling for nested statements when combining ne filters\n\nref https://linear.app/tryghost/issue/CFR-27\n- the combineNeFilters performance improvement will now work with nested operators\n\nSome Ghost serializers wrap the filter strings, so we need to be able to handle nested statements in order for the performance improvement to be useful, specifically with {{#get}} helpers fetching posts.","shortMessageHtmlLink":"Added handling for nested statements when combining ne filters"}},{"before":"3a228f5210d188f7a84e6064d91a77ca787684fd","after":"35cc4630082ebe5a1a83b7d4addc10f4617836a4","ref":"refs/heads/renovate/major-lerna-monorepo","pushedAt":"2024-05-13T09:23:04.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update dependency lerna to v8","shortMessageHtmlLink":"Update dependency lerna to v8"}},{"before":"f702ebce9c8d96ebfc4ae0c17f51a4f672f0e883","after":"3a228f5210d188f7a84e6064d91a77ca787684fd","ref":"refs/heads/renovate/major-lerna-monorepo","pushedAt":"2024-05-13T04:45:25.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update dependency lerna to v8","shortMessageHtmlLink":"Update dependency lerna to v8"}},{"before":"bf73855e4c37fa647c64188f61256d8e55449bb8","after":"392b46b5ecaa178d9603d5765471d6b5e90d3180","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-13T04:45:07.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"e537baf1848b1d5a87520297868b84523ca6d5c7","after":"f15b46b7cfad4964cbe929370d0f6a57d31c4064","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-13T04:44:48.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"05d6f24d2fb66f545ac51f939d3857b395bf8805","after":null,"ref":"refs/heads/renovate/lock-file-maintenance","pushedAt":"2024-05-13T04:44:15.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"}},{"before":"c4d1c8105b197c4fa6b92a3dd3b9ad75469da3cf","after":"05d6f24d2fb66f545ac51f939d3857b395bf8805","ref":"refs/heads/main","pushedAt":"2024-05-13T04:44:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Lock file maintenance","shortMessageHtmlLink":"Lock file maintenance"}},{"before":null,"after":"05d6f24d2fb66f545ac51f939d3857b395bf8805","ref":"refs/heads/renovate/lock-file-maintenance","pushedAt":"2024-05-13T00:23:54.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Lock file maintenance","shortMessageHtmlLink":"Lock file maintenance"}},{"before":"ef2ad27530ee3713e942c0b1e0f5073525332da9","after":"bf73855e4c37fa647c64188f61256d8e55449bb8","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-09T18:40:49.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"267b4ed4d2087a93006f859e638cd29efc7e8fac","after":"e537baf1848b1d5a87520297868b84523ca6d5c7","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-09T18:40:26.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"70b4abe6f3c9e5a67ad9c4c249b131db9e9a2c56","after":"ef2ad27530ee3713e942c0b1e0f5073525332da9","ref":"refs/heads/renovate/major-test-and-linting-packages","pushedAt":"2024-05-09T18:39:23.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"008f76fd1f8a4aeeb9683a643afc581052fb7eb6","after":"c4d1c8105b197c4fa6b92a3dd3b9ad75469da3cf","ref":"refs/heads/main","pushedAt":"2024-05-09T18:39:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"},"commit":{"message":"Published new versions\n\n - @tryghost/mongo-utils@0.6.2\n - @tryghost/nql@0.12.2","shortMessageHtmlLink":"Published new versions"}},{"before":"fe36c46b2352baa2d33f2406e02905dc8e6a94e0","after":"267b4ed4d2087a93006f859e638cd29efc7e8fac","ref":"refs/heads/renovate/test-and-linting-packages","pushedAt":"2024-05-09T18:38:59.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"renovate[bot]","name":null,"path":"/apps/renovate","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/2740?s=80&v=4"},"commit":{"message":"Update Test & linting packages","shortMessageHtmlLink":"Update Test &amp; linting packages"}},{"before":"63dc143e2f342287aa4976ebd13d927289d4e636","after":"008f76fd1f8a4aeeb9683a643afc581052fb7eb6","ref":"refs/heads/main","pushedAt":"2024-05-09T18:38:05.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"9larsons","name":"Steve Larson","path":"/9larsons","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/21961100?s=80&v=4"},"commit":{"message":"Improved performance for multiple negation filters (#78)\n\nref https://linear.app/tryghost/issue/CFR-27\r\n-NQL will now automatically combine multiple not equal ($ne) filters of the same type\r\n-added JSDoc\r\n\r\nThis is a performance improvement as (NOT 1) AND (NOT 2) is logically equal to NOT (1 OR 2), except the latter is *much* more performant in the resulting SQL query as you only get one subquery instaed of one for each filter.","shortMessageHtmlLink":"Improved performance for multiple negation filters (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2285922482\" data-permission-text=\"Title is private\" data-url=\"https://github.com/TryGhost/NQL/issues/78\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/TryGhost/NQL/pull/78/hovercard\" href=\"https://github.com/TryGhost/NQL/pull/78\">#78</a>)"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEVHZZNAA","startCursor":null,"endCursor":null}},"title":"Activity · TryGhost/NQL"}