v1.24.0 Release July 2024

What's Changed

• SuperFluid Release fix test actual matching View by @mohammadranjbarz in #1497
• remove word_similarity temporary by @CarlosQ96 in #1498
• Release Improve User Score fetching by @CarlosQ96 in #1500
• Revert "remove word_similarity temporary" by @aminlatifi in #1501
• Fix Actual Matching Cap by @CarlosQ96 in #1508
• Release 2024-04-29 superfluid and qf improvements by @mohammadranjbarz in #1513
• Update SF min USD value for donation received notification by @RamRamez in #1514
• Archived qf round summary page & link on the main qf page #3748 by @RamRamez in #1509
• Add logs and refactor the bootstrap code to help investigate latency … problem by @mohammadranjbarz in #1516
• Feat: add sponsors & banner images upload by @Meriem-BM in #1510
• Trigger ortto activity when user saves their profile info for the first time by @RamRamez in #1520
• Allow to set the matching pool token & amount to be something other than usd by @RamRamez in #1517
• add allocatedFundUSDPreferred and allocatedFundUSD to qfRound by @RamRamez in #1522
• Create migration to change conection idle time by @mohammadranjbarz in #1518
• Release Hotfixes for QF Round by @CarlosQ96 in #1521
• Hotfix db improvements by @CarlosQ96 in #1523
• Fix/db-replica-production by @aminlatifi in #1524
• Fix/db replica production by @aminlatifi in #1525
• Hotfix staging fix latency by @CarlosQ96 in #1528
• Hotfix latency issues for prod by @CarlosQ96 in #1529
• Add log for draft donation service by @mohammadranjbarz in #1537
• Fix/master test by @aminlatifi in #1541
• Master to staging by @aminlatifi in #1543
• Fix/word similarity - staging by @aminlatifi in #1546
• Change count of draft donation query by @mohammadranjbarz in #1547
• remove refresh_project_summary_from totals and add user cache by @CarlosQ96 in #1539
• Remove users field from project if it's not needed by @RamRamez in #1549
• Add recurring donation join to donations() endpoint by @mohammadranjbarz in #1554
• feat: add getRecurringDonationStats resolver by @Meriem-BM in #1479
• Make sure ortto is merging by user id, not email by @RamRamez in #1530
• Surround all refresh materialized views in try..catch.. scope to make sure the failure of that doesnt have any side effect on our application by @mohammadranjbarz in #1563
• fix merge by field by @RamRamez in #1565
• fix: add telegram to ProjectSocialMediaType enum by @Meriem-BM in #1567
• Fix: adding projectIds textArea to QF Round edit page by @Meriem-BM in #1505
• Remove Admin Column that was Deprecated by @RamRamez in #1553
• Fix/word_similarity - master by @aminlatifi in #1545
• add indexes to project_summary_view by @CarlosQ96 in #1568
• add indexes to project_summary_view (#1568) by @CarlosQ96 in #1569
• fix: change output types to float by @Meriem-BM in #1572
• Add streamed mini donations to qf round by @mohammadranjbarz in #1557
• improve projectBySlug query by @RamRamez in #1570
• Ignore small differences of amounts when matching draft donation for … by @mohammadranjbarz in #1573
• make verificationFormStatus field public by @RamRamez in #1575
• Reduce test runnning time by @Meriem-BM in #1574
• Release Integrate QF with super fluid streamed donations by @mohammadranjbarz in #1555
• add migration and columns for totals in project entity by @CarlosQ96 in #1571
• add word similarity to search by @RamRamez in #1581
• Add methods for adding matching to totals usd received by @CarlosQ96 in #1582
• Add base chain by @mohammadranjbarz in #1579
• optimize projectById by @RamRamez in #1584
• Hotfix performance improvements by @CarlosQ96 in #1587
• Add coingeckoId to BASE_SEPOLIA by @Meriem-BM in #1592
• optimize qfRounds query by @RamRamez in #1591
• Search functionality hot-fix by @RamRamez in #1593
• Db read only by @Rolazo in #1595
• sync all donations totals by @CarlosQ96 in #1594
• 4201 add sponser's donations manually by @mohammadranjbarz in #1588
• Release upgrades + Base integration by @CarlosQ96 in #1586
• fix: 1125 issue with unlinking project from qf round by @Meriem-BM in #1597
• fix: add pagination for QF Round listed projects by @Meriem-BM in #1601
• Drop donation summary view by @RamRamez in #1603
• 651 run migration files as js file by @ae2079 in #1604
• Revert "651 run migration files as js file (#1604)" by @RamRamez in #1606
• Fix issue in db migration scripts by @ae2079 in #1608
• add caching to QF rounds and mainCategories query by @RamRamez in #1612
• Allow refresh concurrently of materialized views by @CarlosQ96 in #1611
• fix: issue while listing recurring donations by @Meriem-BM in #1622
• fix: filter unique donors based on passport score and knownAsSybilAdd… by @Meriem-BM in #1613
• Improve log messages by @ae2079 in #1623
• Get giv price from coingecko instead of subgraph by @mohammadranjbarz in #1621
• fix: retrieve correct USD value of donations for an archived QF round by @Meriem-BM in #1624
• changed projectTabs adminUserId to true but still not updating in Database by @lovelgeorge99 in #1605
• optimize updateProjectStatistics by @RamRamez in #1625
• Fix Project Estimated Matching View by @RamRamez in #1630
• merge getQfRoundUniqueDonors and getQfRoundTotalDonations by @RamRamez in #1633
• optimize refreshProjectEstimatedMatchingView by @RamRamez in #1632
• Zkevm integration by @mohammadranjbarz in #1635
• remove insertDonationsFromQfRoundHistory from syncDonationStatusWitBlockchainNetwork by @RamRamez in #1636
• Optimize check project verification by @RamRamez in #1637
• Release zkevm integration by @mohammadranjbarz in #1647
• fix: get unique_donors based on user wallet address not added to sybi… by @Meriem-BM in #1643
• remove knownAsSybilAddress from user by @RamRamez in #1651
• wrong query cache in some functions by @RamRamez in #1652
• use networkId instead of optimism-only flag by @ae2079 in #1653
• fatal errors by @ae2079 in #1640
• fix: findArchivedQfRounds query by @Meriem-BM in #1660
• add cache to findActiveQfRound by @RamRamez in #1644
• remove updateTotalDonationsOfProject and sumDonationValueUsd by @RamRamez in #1648
• do email verification on project verification form through Ortto by @RamRamez in #1649
• User Story - Rejected project owner reason by @RamRamez in #1654
• Replace ortto External Embedded Webform for Onboarding guide by @RamRamez in #1657
• Fix some test cases about stable coin donations by @mohammadranjbarz in #1665
• Bump follow-redirects from 1.15.5 to 1.15.6 by @dependabot in #1414
• Bump @solana/web3.js from 1.87.6 to 1.87.7 by @dependabot in #1492
• Bump express from 4.18.2 to 4.19.2 by @dependabot in #1430
• Bump braces from 3.0.2 to 3.0.3 by @dependabot in #1629
• Bump undici from 5.28.3 to 5.28.4 by @dependabot in #1454
• fix: issue with adminJs authentication when user has hash as null by @Meriem-BM in #1666
• get donation to giveth with donation box analytics by @ae2079 in #1661
• Added on final step for verification project data by @kkatusic in #1658
• fix: issue while listing recurring donations by @Meriem-BM in #1668
• "Last Update" on project card is not correct by @RamRamez in #1667
• Remove old donation and add new ones by @ae2079 in #1674
• fix archived_round totals by @CarlosQ96 in #1675
• Release fix archived round totals by @CarlosQ96 in #1676
• hotfix Change subgraph of superfluid adapter for optimism mainnet by @mohammadranjbarz in #1679
• USD value not showing by @RamRamez in #1680
• Fix usdc decimals for recurring donations by @mohammadranjbarz in #1682
• Endaoment integration by @mohammadranjbarz in #1663
• Feature new qf scoring model by @CarlosQ96 in #1634
• Fix: convert timestamp retrieved from RPC provider to milliseconds by @Meriem-BM in #1684
• fix USD value not showing by @RamRamez in #1683
• fix: convert minimumUserAnalysisScore to Float on qfRound entity by @Meriem-BM in #1692
• Merge master to staging by @ae2079 in #1696
• Return hardcoded 70 as user MBD score Temporary by @Meriem-BM in #1699
• feat: add github on project socialmedia enum by @Reshzera in #1694
• Rename qfRound minimumUserAnalysisScore field by @Meriem-BM in #1701
• Resolve conflicts by @ae2079 in #1703
• fix daily CPU spikes by @RamRamez in #1705
• Comment migrations related to endaoment by @mohammadranjbarz in #1706

New Contributors

• @Rolazo made their first contribution in #1595
• @lovelgeorge99 made their first contribution in #1605
• @kkatusic made their first contribution in #1658
• @Reshzera made their first contribution in #1694

Full Changelog: v1.23.3...v1.24.0