{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":18150828,"defaultBranch":"main","name":"SqlRender","ownerLogin":"OHDSI","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2014-03-26T19:24:46.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/6570077?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1725461464.0","currentOid":""},"activityList":{"items":[{"before":"e0abc4cb2b1225e1dd779092a48ef6d5b63a947d","after":null,"ref":"refs/heads/dependabot/github_actions/dot-github/workflows/actions/download-artifact-4.1.7","pushedAt":"2024-09-04T14:51:04.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"}},{"before":"85500272ce40769017b7b52983e5ef305c0e7cbd","after":"020d26ca6a83de96675ba0256b0d2e443b6abfd9","ref":"refs/heads/main","pushedAt":"2024-09-04T14:50:56.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #375 from OHDSI/dependabot/github_actions/dot-github/workflows/actions/download-artifact-4.1.7\n\nBump actions/download-artifact from 2 to 4.1.7 in /.github/workflows","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2503878242\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/375\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/375/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/375\">#375</a> from OHDSI/dependabot/github_actions/dot-gith…"}},{"before":null,"after":"e0abc4cb2b1225e1dd779092a48ef6d5b63a947d","ref":"refs/heads/dependabot/github_actions/dot-github/workflows/actions/download-artifact-4.1.7","pushedAt":"2024-09-03T22:03:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"dependabot[bot]","name":null,"path":"/apps/dependabot","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/29110?s=80&v=4"},"commit":{"message":"Bump actions/download-artifact from 2 to 4.1.7 in /.github/workflows\n\nBumps [actions/download-artifact](https://github.com/actions/download-artifact) from 2 to 4.1.7.\n- [Release notes](https://github.com/actions/download-artifact/releases)\n- [Commits](https://github.com/actions/download-artifact/compare/v2...v4.1.7)\n\n---\nupdated-dependencies:\n- dependency-name: actions/download-artifact\n  dependency-type: direct:production\n...\n\nSigned-off-by: dependabot[bot] <support@github.com>","shortMessageHtmlLink":"Bump actions/download-artifact from 2 to 4.1.7 in /.github/workflows"}},{"before":"85500272ce40769017b7b52983e5ef305c0e7cbd","after":"5d8445a72b5c45a87c4064c6d177cdfabb389740","ref":"refs/heads/develop","pushedAt":"2024-08-23T06:28:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Fix CRAN badges","shortMessageHtmlLink":"Fix CRAN badges"}},{"before":"cfdec3a2e36e26bc2c1596486df451cff7d09763","after":"85500272ce40769017b7b52983e5ef305c0e7cbd","ref":"refs/heads/main","pushedAt":"2024-08-21T08:03:40.000Z","pushType":"push","commitsCount":12,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN-SUBMISSION (and date in DESCRIPTION)","shortMessageHtmlLink":"Updating CRAN-SUBMISSION (and date in DESCRIPTION)"}},{"before":"8f679ba9c53c0dbbc6cdb55c432e066e788d7c4d","after":"85500272ce40769017b7b52983e5ef305c0e7cbd","ref":"refs/heads/develop","pushedAt":"2024-08-21T08:03:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN-SUBMISSION (and date in DESCRIPTION)","shortMessageHtmlLink":"Updating CRAN-SUBMISSION (and date in DESCRIPTION)"}},{"before":"56457846451df2fb65c796e6485ccf45e4f3d80a","after":"8f679ba9c53c0dbbc6cdb55c432e066e788d7c4d","ref":"refs/heads/develop","pushedAt":"2024-08-09T14:26:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Regenerating documentation","shortMessageHtmlLink":"Regenerating documentation"}},{"before":"4b3cd018dbe0be1cbc0b3132522d016686e56b97","after":"56457846451df2fb65c796e6485ccf45e4f3d80a","ref":"refs/heads/develop","pushedAt":"2024-08-09T04:36:16.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #373 from OHDSI/snowflake-date-cast\n\nCAST(@a AS DATE) handling for Snowflake - fixes #372","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2456309310\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/373\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/373/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/373\">#373</a> from OHDSI/snowflake-date-cast"}},{"before":null,"after":"d935545dcf417c63549a0a44d8056ee1dcc86b9e","ref":"refs/heads/snowflake-date-cast","pushedAt":"2024-08-08T17:35:23.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"anthonysena","name":"Anthony Sena","path":"/anthonysena","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12902366?s=80&v=4"},"commit":{"message":"CAST(@a AS DATE) handling for Snowflake - fixes #372","shortMessageHtmlLink":"CAST(<a class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/A/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/A\">@A</a> AS DATE) handling for Snowflake - <span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #372.\">fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2456287250\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/372\" data-hovercard-type=\"issue\" data-hovercard-url=\"/OHDSI/SqlRender/issues/372/hovercard\" href=\"https://github.com/OHDSI/SqlRender/issues/372\">#372</a>"}},{"before":"5f407488d03f5eaaa8606b2b292e0f948960d73d","after":"4b3cd018dbe0be1cbc0b3132522d016686e56b97","ref":"refs/heads/develop","pushedAt":"2024-08-05T09:30:37.000Z","pushType":"pr_merge","commitsCount":4,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #371 from OHDSI/issue-370-databricks-date-cast\n\nAdd translation for DataBricks `CAST(@a AS DATE)`","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2443406253\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/371\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/371/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/371\">#371</a> from OHDSI/issue-370-databricks-date-cast"}},{"before":"b64ac1a7169f8323f09f1dd395df69f325d72c44","after":"b233ee4eb033c757eb8eada6c8b5755e46538b02","ref":"refs/heads/issue-370-databricks-date-cast","pushedAt":"2024-08-01T20:58:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anthonysena","name":"Anthony Sena","path":"/anthonysena","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12902366?s=80&v=4"},"commit":{"message":"Fix unit test","shortMessageHtmlLink":"Fix unit test"}},{"before":"4cc0740923744cfe1ad8462cdd67f6bb9681dcfe","after":"b64ac1a7169f8323f09f1dd395df69f325d72c44","ref":"refs/heads/issue-370-databricks-date-cast","pushedAt":"2024-08-01T20:52:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"anthonysena","name":"Anthony Sena","path":"/anthonysena","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12902366?s=80&v=4"},"commit":{"message":"Fix bug","shortMessageHtmlLink":"Fix bug"}},{"before":null,"after":"4cc0740923744cfe1ad8462cdd67f6bb9681dcfe","ref":"refs/heads/issue-370-databricks-date-cast","pushedAt":"2024-08-01T20:31:59.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"anthonysena","name":"Anthony Sena","path":"/anthonysena","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/12902366?s=80&v=4"},"commit":{"message":"Add DataBricks CAST for date translation","shortMessageHtmlLink":"Add DataBricks CAST for date translation"}},{"before":"3a6d8b3c4a6978659e1672ce91df254caff3f83f","after":"5f407488d03f5eaaa8606b2b292e0f948960d73d","ref":"refs/heads/develop","pushedAt":"2024-07-16T12:05:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Fixed DuckDb translation of `CAST(CONCATENATE(...) AS DATE)`. Fixes #369","shortMessageHtmlLink":"Fixed DuckDb translation of <code>CAST(CONCATENATE(...) AS DATE)</code>. <span class=\"issue-keyword tooltipped tooltipped-se\" aria-label=\"This commit closes issue #369.\">Fixes</span> <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2407654205\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/369\" data-hovercard-type=\"issue\" data-hovercard-url=\"/OHDSI/SqlRender/issues/369/hovercard\" href=\"https://github.com/OHDSI/SqlRender/issues/369\">#369</a>"}},{"before":"acdd6f36ad44227f13214ddcfe8f17f93583a9cb","after":"3a6d8b3c4a6978659e1672ce91df254caff3f83f","ref":"refs/heads/develop","pushedAt":"2024-06-20T04:48:54.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #368 from egillax/367-duckdb_to_years\n\nfix duckdb adding years + test","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2359677767\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/368\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/368/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/368\">#368</a> from egillax/367-duckdb_to_years"}},{"before":"cfdec3a2e36e26bc2c1596486df451cff7d09763","after":"acdd6f36ad44227f13214ddcfe8f17f93583a9cb","ref":"refs/heads/develop","pushedAt":"2024-06-04T12:26:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Changing Spark translation of `DATEADD()` from `DATE_ADD()` to `DATEADD()` as required by some but not all Databricks instances. Fixes #366","shortMessageHtmlLink":"Changing Spark translation of <code>DATEADD()</code> from <code>DATE_ADD()</code> to `DATEA…"}},{"before":"a1d4ab9944abb09e65ca679cac0aae4a1f78af82","after":"cfdec3a2e36e26bc2c1596486df451cff7d09763","ref":"refs/heads/main","pushedAt":"2024-05-30T09:05:08.000Z","pushType":"push","commitsCount":11,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN submission file","shortMessageHtmlLink":"Updating CRAN submission file"}},{"before":"735817818246eafdd25b294ecf3a1f5a0df4e135","after":"cfdec3a2e36e26bc2c1596486df451cff7d09763","ref":"refs/heads/develop","pushedAt":"2024-05-30T09:02:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN submission file","shortMessageHtmlLink":"Updating CRAN submission file"}},{"before":"a6d8d183c89445997ca70f59bc5401a9046263bf","after":"735817818246eafdd25b294ecf3a1f5a0df4e135","ref":"refs/heads/develop","pushedAt":"2024-05-30T06:16:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"New call to rhub","shortMessageHtmlLink":"New call to rhub"}},{"before":"a08e0520ac2519285bbda729f6e4d9114e986cba","after":"a6d8d183c89445997ca70f59bc5401a9046263bf","ref":"refs/heads/develop","pushedAt":"2024-05-30T04:53:26.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Regenerating documentation","shortMessageHtmlLink":"Regenerating documentation"}},{"before":"c66fe6fba165c3008c3792a7b70e5d2964c77c30","after":"a08e0520ac2519285bbda729f6e4d9114e986cba","ref":"refs/heads/develop","pushedAt":"2024-05-29T03:54:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Add CODECOV token to GA","shortMessageHtmlLink":"Add CODECOV token to GA"}},{"before":"31cc236b3c2e151047ba41fbf96927544eebd0ad","after":"c66fe6fba165c3008c3792a7b70e5d2964c77c30","ref":"refs/heads/develop","pushedAt":"2024-05-28T09:17:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Adding translation for bitwise AND operator","shortMessageHtmlLink":"Adding translation for bitwise AND operator"}},{"before":"0ff607b6cf50ccf5ece05241d18bd91f9a7ed253","after":"31cc236b3c2e151047ba41fbf96927544eebd0ad","ref":"refs/heads/develop","pushedAt":"2024-05-13T05:21:20.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #363 from TomWhite-MedStar/test_datetime_in_spark\n\nFix #362","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2291645875\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/363\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/363/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/363\">#363</a> from TomWhite-MedStar/test_datetime_in_spark"}},{"before":"6e13c6631df846301fda69e53638822b246dde29","after":"0ff607b6cf50ccf5ece05241d18bd91f9a7ed253","ref":"refs/heads/develop","pushedAt":"2024-05-08T14:38:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"More robust detection of string concatenation for BigQuery","shortMessageHtmlLink":"More robust detection of string concatenation for BigQuery"}},{"before":"a1d4ab9944abb09e65ca679cac0aae4a1f78af82","after":"6e13c6631df846301fda69e53638822b246dde29","ref":"refs/heads/develop","pushedAt":"2024-04-10T06:28:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Fixed for ALTER TABLE ALTER COLUMN for Postgres and SQLite","shortMessageHtmlLink":"Fixed for ALTER TABLE ALTER COLUMN for Postgres and SQLite"}},{"before":"bd72fb4b5016874fed034f3254971840e01b9211","after":"a1d4ab9944abb09e65ca679cac0aae4a1f78af82","ref":"refs/heads/main","pushedAt":"2024-03-21T07:50:09.000Z","pushType":"push","commitsCount":25,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN submission file","shortMessageHtmlLink":"Updating CRAN submission file"}},{"before":"fe7352032696ecf2cc34a58f719a5681202b3f3d","after":"a1d4ab9944abb09e65ca679cac0aae4a1f78af82","ref":"refs/heads/develop","pushedAt":"2024-03-21T07:49:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating CRAN submission file","shortMessageHtmlLink":"Updating CRAN submission file"}},{"before":"5cba4de9dedadae64d39106fed98e2488980844f","after":"fe7352032696ecf2cc34a58f719a5681202b3f3d","ref":"refs/heads/develop","pushedAt":"2024-03-20T13:10:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating POM version","shortMessageHtmlLink":"Updating POM version"}},{"before":"2cf1d911bbc2e89f407d8b6fb5845019c7379a3c","after":"5cba4de9dedadae64d39106fed98e2488980844f","ref":"refs/heads/develop","pushedAt":"2024-03-20T12:32:16.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Updating copyright year. Increasing version number. Regenerating documentation","shortMessageHtmlLink":"Updating copyright year. Increasing version number. Regenerating docu…"}},{"before":"1fe7c2202408cf7c8a704bb32f64debe49e38532","after":"2cf1d911bbc2e89f407d8b6fb5845019c7379a3c","ref":"refs/heads/develop","pushedAt":"2024-03-19T14:25:20.000Z","pushType":"pr_merge","commitsCount":11,"pusher":{"login":"schuemie","name":"Martijn Schuemie","path":"/schuemie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6713328?s=80&v=4"},"commit":{"message":"Merge pull request #347 from TomWhite-MedStar/Feature_345_datetime_calculation_in_spark\n\nAdded datediff() and dateadd() for hours/minutes/seconds for Spark, Oracle, PostGres, RedShift","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1922156904\" data-permission-text=\"Title is private\" data-url=\"https://github.com/OHDSI/SqlRender/issues/347\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/OHDSI/SqlRender/pull/347/hovercard\" href=\"https://github.com/OHDSI/SqlRender/pull/347\">#347</a> from TomWhite-MedStar/Feature_345_datetime_ca…"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAErNet2wA","startCursor":null,"endCursor":null}},"title":"Activity · OHDSI/SqlRender"}