{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":269580407,"defaultBranch":"master","name":"likecoin-chain-tx-indexer","ownerLogin":"likecoin","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2020-06-05T09:00:42.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/6298090?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1678144028.072119","currentOid":""},"activityList":{"items":[{"before":"0ab412c912478e33629af925464e76516f23fe3b","after":"395ade192c3ed7fb2ecc028089443d003db0be2e","ref":"refs/heads/master","pushedAt":"2024-07-15T03:27:30.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"💩 Mitigate uint64 price cannot be indexed issue","shortMessageHtmlLink":"💩 Mitigate uint64 price cannot be indexed issue"}},{"before":"64bd61c85fc0e4fa8883fd3b9a86aa5c416fd0f6","after":"0ab412c912478e33629af925464e76516f23fe3b","ref":"refs/heads/master","pushedAt":"2024-04-23T13:40:47.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⬆️ Upgrade likecoin-chain to 4.2.0","shortMessageHtmlLink":"⬆️ Upgrade likecoin-chain to 4.2.0"}},{"before":"1d0593af6c6acebecba9f375a0748bf30fbb3bd1","after":"64bd61c85fc0e4fa8883fd3b9a86aa5c416fd0f6","ref":"refs/heads/master","pushedAt":"2023-12-07T12:02:03.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⬆️ Upgrade to likecoin v4.1.1","shortMessageHtmlLink":"⬆️ Upgrade to likecoin v4.1.1"}},{"before":"f96d38fb233df53d580cd3341e128c487f3fd32c","after":"1d0593af6c6acebecba9f375a0748bf30fbb3bd1","ref":"refs/heads/master","pushedAt":"2023-09-04T16:13:52.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ Add iscn record count api","shortMessageHtmlLink":"✨ Add iscn record count api"}},{"before":"996f46430b15c1cdf46467cd74f32a0cdce4806e","after":"f96d38fb233df53d580cd3341e128c487f3fd32c","ref":"refs/heads/master","pushedAt":"2023-09-04T14:42:44.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🎨 Simplify select distinct + union all to union","shortMessageHtmlLink":"🎨 Simplify select distinct + union all to union"}},{"before":"cf58499eeb8815d27aacda6472cf5c42ba302324","after":"996f46430b15c1cdf46467cd74f32a0cdce4806e","ref":"refs/heads/master","pushedAt":"2023-09-04T13:28:31.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🎨 Skip second part of nft event union if involver is not set","shortMessageHtmlLink":"🎨 Skip second part of nft event union if involver is not set"}},{"before":"f90687b84b851ba072adbca30d73749792369686","after":"cf58499eeb8815d27aacda6472cf5c42ba302324","ref":"refs/heads/master","pushedAt":"2023-08-23T18:20:50.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"[TAS-209] ✨ Support querying recent creator counts (#125)\n\n* ✨ Support querying recent creators counts\r\n\r\n* 👔 Return all-time results\r\n\r\n* 🎨 Add `interval`, `after` and `before` params","shortMessageHtmlLink":"[TAS-209] ✨ Support querying recent creator counts (#125)"}},{"before":"2b7086282757e3dffa935e507ed671a1d6d923b3","after":"f90687b84b851ba072adbca30d73749792369686","ref":"refs/heads/master","pushedAt":"2023-08-18T06:38:18.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⚡️ Use `DISTINCT ON` to filter unused CTE data rows (#124)","shortMessageHtmlLink":"⚡️ Use DISTINCT ON to filter unused CTE data rows (#124)"}},{"before":"545964bd153bda8fcc8612b3b974db78ae8a8a67","after":"2b7086282757e3dffa935e507ed671a1d6d923b3","ref":"refs/heads/master","pushedAt":"2023-08-07T10:42:01.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"WeiJun0827","name":"Wei-Jun Hung","path":"/WeiJun0827","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33746295?s=80&v=4"},"commit":{"message":"✨ Add `/statistics/iscn/owner-count`","shortMessageHtmlLink":"✨ Add /statistics/iscn/owner-count"}},{"before":"69e9f27056abf79fb1797dd16f559bedf9f35352","after":"545964bd153bda8fcc8612b3b974db78ae8a8a67","ref":"refs/heads/master","pushedAt":"2023-08-03T05:17:38.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🐛 [/class] Add back last owned NFT id (#122)","shortMessageHtmlLink":"🐛 [/class] Add back last owned NFT id (#122)"}},{"before":"a026723fb13be69c7a431946f7160b4bd68c2965","after":"69e9f27056abf79fb1797dd16f559bedf9f35352","ref":"refs/heads/master","pushedAt":"2023-07-25T08:29:51.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⚡️ Replace subquery with join clause for better performance (#121)","shortMessageHtmlLink":"⚡️ Replace subquery with join clause for better performance (#121)"}},{"before":"6026e8ea3c22d6a7fd935364b2286615437f1598","after":"a026723fb13be69c7a431946f7160b4bd68c2965","ref":"refs/heads/master","pushedAt":"2023-07-20T13:08:56.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ Return `owner` field for `/ranking` (#120)","shortMessageHtmlLink":"✨ Return owner field for /ranking (#120)"}},{"before":"9daa96bcfed61107ac5b68c038f9e21b6f044904","after":"6026e8ea3c22d6a7fd935364b2286615437f1598","ref":"refs/heads/master","pushedAt":"2023-07-20T12:55:06.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ Add `nft_owned_count` and `nft_last_owned_at` fields for `/class` (#119)","shortMessageHtmlLink":"✨ Add nft_owned_count and nft_last_owned_at fields for /class (#…"}},{"before":"5999394a1913d15a51251f0efbd6aa19e6c52dff","after":"9daa96bcfed61107ac5b68c038f9e21b6f044904","ref":"refs/heads/master","pushedAt":"2023-07-14T08:11:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🐛 Add missing NFT filter","shortMessageHtmlLink":"🐛 Add missing NFT filter"}},{"before":"6bbedad01a4267b18f50413d10d2a513cb55eb76","after":"5999394a1913d15a51251f0efbd6aa19e6c52dff","ref":"refs/heads/master","pushedAt":"2023-07-13T11:50:43.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ Support query by NFT owner for `/class` (#117)\n\n* ✨ Support query by NFT owner for `/class`\r\n\r\n* ⚡️ Don't `JOIN nft` when data is not needed","shortMessageHtmlLink":"✨ Support query by NFT owner for /class (#117)"}},{"before":"b375309482cea7fc931fbf0950d2d8dc51b151ef","after":"6bbedad01a4267b18f50413d10d2a513cb55eb76","ref":"refs/heads/master","pushedAt":"2023-07-12T08:38:41.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✅ Add test","shortMessageHtmlLink":"✅ Add test"}},{"before":"a881400df9041bf77068de44e01137034286631d","after":"b375309482cea7fc931fbf0950d2d8dc51b151ef","ref":"refs/heads/master","pushedAt":"2023-06-16T08:56:05.891Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ NFT income support `is_royalty` (#114)\n\n* ✅ Improve account role of test\r\n\r\n* ✨ NFT income support `is_royalty`\r\n\r\n* 🐛 Update classId and nftId when iterating multiple purchase messages\r\n\r\n* 🎨 Extract `class_id` and `nft_id` from message itself but not external","shortMessageHtmlLink":"✨ NFT income support is_royalty (#114)"}},{"before":"5e9601df0906505d88454b5b4e3d80f27f75200c","after":"a881400df9041bf77068de44e01137034286631d","ref":"refs/heads/master","pushedAt":"2023-06-14T11:04:56.953Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🏗️ Revamp NFT income parsing logic to support batch purchase","shortMessageHtmlLink":"🏗️ Revamp NFT income parsing logic to support batch purchase"}},{"before":"28a85300f69d6f59ad4337f4fdd50abcfeb14f46","after":"5e9601df0906505d88454b5b4e3d80f27f75200c","ref":"refs/heads/master","pushedAt":"2023-06-05T11:47:21.606Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🔥 Remove amino endpoints","shortMessageHtmlLink":"🔥 Remove amino endpoints"}},{"before":"9a6104660ab77dcae38251931feb27027d204d06","after":"28a85300f69d6f59ad4337f4fdd50abcfeb14f46","ref":"refs/heads/master","pushedAt":"2023-06-05T06:38:20.163Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🎨 Improve testcase to include multiple ISCN versions","shortMessageHtmlLink":"🎨 Improve testcase to include multiple ISCN versions"}},{"before":"4c3e741ef49e5d7a905efee39af3a164e911c3ee","after":"9a6104660ab77dcae38251931feb27027d204d06","ref":"refs/heads/master","pushedAt":"2023-06-02T16:35:39.602Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ `/owner` supports `exclude_iscn_owner` qs (#110)","shortMessageHtmlLink":"✨ /owner supports exclude_iscn_owner qs (#110)"}},{"before":"6ff27ed2b1ee00395d716d9694a47d67899844b5","after":"4c3e741ef49e5d7a905efee39af3a164e911c3ee","ref":"refs/heads/master","pushedAt":"2023-06-01T07:56:47.336Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"✨ Remove `/income/details` and revamp `/income` API (#107)\n\n* 🔥 Remove `GET /income/details` API\r\n\r\n* ✨ Revamp `GET /income` API\r\n\r\n* 🎨 Support `address` and `iscn_ownership` qs\r\n\r\n* 🎨 Improve pagination key logic\r\n\r\n* 🎨 Rename field names and qs enums\r\n\r\n* ✨ Add `sales` and `total_sales` response fields\r\n\r\n* 🗃️ Drop `nft_income` table since duplicated data\r\n\r\n* 🎨 Include self-purchase by default and simplify table join\r\n\r\n* 🎨 Remove redundant income from authz msg\r\n\r\n* ♻️ Format response assignment code\r\n\r\n* 🐛 Fix qs field name inconsistency\r\n\r\n* 🔥 Remove unused code\r\n\r\n* 🎨 Format operation order","shortMessageHtmlLink":"✨ Remove /income/details and revamp /income API (#107)"}},{"before":"f68c8bcf59c254ebd594c6fdabc21bbc1a1de15a","after":"6ff27ed2b1ee00395d716d9694a47d67899844b5","ref":"refs/heads/master","pushedAt":"2023-05-31T08:33:31.915Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⚡️ Optimize ranking query performance","shortMessageHtmlLink":"⚡️ Optimize ranking query performance"}},{"before":"64525901870f2bf71eedd8893cd4f619e56d9531","after":"4a58bd25818b4aaeba178bfebc4804a781a6f4c3","ref":"refs/heads/develop","pushedAt":"2023-05-23T04:17:28.307Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🔥 Remove amino endpoints","shortMessageHtmlLink":"🔥 Remove amino endpoints"}},{"before":"b415b7d2d751b6dce48cc3725c6459d05de49549","after":"64525901870f2bf71eedd8893cd4f619e56d9531","ref":"refs/heads/develop","pushedAt":"2023-05-23T04:09:58.165Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🔥 Remove amino endpoints","shortMessageHtmlLink":"🔥 Remove amino endpoints"}},{"before":"8544fd9ab5a76d1a81660c61c952a8d66bdd6405","after":"b415b7d2d751b6dce48cc3725c6459d05de49549","ref":"refs/heads/develop","pushedAt":"2023-05-23T03:45:53.927Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🔥 Remove amino endpoints","shortMessageHtmlLink":"🔥 Remove amino endpoints"}},{"before":"4993d8a1e3b2296d3811750e0de06c1d8b4893ac","after":"8544fd9ab5a76d1a81660c61c952a8d66bdd6405","ref":"refs/heads/develop","pushedAt":"2023-05-23T03:45:01.508Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"🔥 Remove amino endpoints","shortMessageHtmlLink":"🔥 Remove amino endpoints"}},{"before":"40385e5068b68df4b492655120e4d053db058a2f","after":"4993d8a1e3b2296d3811750e0de06c1d8b4893ac","ref":"refs/heads/develop","pushedAt":"2023-05-23T03:39:54.570Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⬆️ Upgrade likecoin chain to v4.0.0-rc1","shortMessageHtmlLink":"⬆️ Upgrade likecoin chain to v4.0.0-rc1"}},{"before":"45200f57f7fc31edde91ef1fb0de83f668b8d3fc","after":"40385e5068b68df4b492655120e4d053db058a2f","ref":"refs/heads/develop","pushedAt":"2023-05-23T03:34:05.466Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⬆️ Upgrade likecoin chain to v4.0.0-rc1","shortMessageHtmlLink":"⬆️ Upgrade likecoin chain to v4.0.0-rc1"}},{"before":"ec9fb8717e662dacf71d0a661490db2b05fbc846","after":"45200f57f7fc31edde91ef1fb0de83f668b8d3fc","ref":"refs/heads/develop","pushedAt":"2023-05-23T03:31:51.721Z","pushType":"push","commitsCount":246,"pusher":{"login":"williamchong","name":"William Chong","path":"/williamchong","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6198816?s=80&v=4"},"commit":{"message":"⬆️ Upgrade likecoin chain to v4.0.0-rc1","shortMessageHtmlLink":"⬆️ Upgrade likecoin chain to v4.0.0-rc1"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEf0gDGAA","startCursor":null,"endCursor":null}},"title":"Activity · likecoin/likecoin-chain-tx-indexer"}