QF - Improve sorting for QF rounds

[laurenluz]

We should improve the sorting on QF rounds to accomodate QF rounds. So on the QF page, it would be great to sort by:

• "$ Raised this QF round" - this sorts the projects according to the total funding they raised in the current QF round

is that title too long? @MohammadPCh

[divine-comedian]

This needs to implemented on the back-end first and then we can update the front-end

[laurenluz]

Should add:

• Sort by amount donated in this QF round

@CarlosQ96 - can you work on the backend this week?

[CarlosQ96]

Ill leave a pr for this tomorrow. Working on Joining the view

[MoeNick]

Can you update us on this issue @CarlosQ96 ?

[CarlosQ96]

Hey added the filters and added some tests. However it's getting conflict in database results when executing due to many tables we query at the same time.

Trying to avoid a big rewrite. But seems limitation of the db framework. Spent many hours on it today, will try a few more things tomorrow and update this issue properly.

[MoeNick]

@mohammadranjbarz and @CarlosQ96 may meet about it.

[laurenluz]

@CarlosQ96 - you're working on this this week, right? would be nice to have before the Optimism round starts (which might be as early as Oct 4)

[CarlosQ96]

Yeah i should be done between today and friday, working on a new table that has the current round sums and data.

[maryjaf]

Should this issue be implemented for optimism round ? @laurenluz @CarlosQ96

[CarlosQ96]

Giveth/impact-graph#1137

[laurenluz]

Should this issue be implemented for optimism round ? @laurenluz @CarlosQ96

@maryjaf - yes please! let's test it :)

[maryjaf]

It hasn't been merged, I'll test it with high priority when it will be ready for testing

[maryjaf]

The projects that haven't been received donation in a round isn't shown by this new sorting, plz check @CarlosQ96

[CarlosQ96]

Ok Found the bug ill push hotfix

[CarlosQ96]

pushed hotfix , issue corrected.

[maryjaf]

It seems sth is wrong , by setting "Amount Raised in QF" the projects with 0 amount raised are shown in the first position
Private Zenhub Image
@CarlosQ96

[CarlosQ96]

@laurenluz @maryjaf Fixed order!

[maryjaf]

It seems sth is wrong , by setting "Amount Raised in QF" the projects with 0 amount raised are shown in the first position

Thanks @CarlosQ96 This problem has been resolve