When using edx_sga the GRADE_SUBMISSIONS button doesn't work. The console shows those errors.

Some sites with old organizations like Dummy and dummy are not filtered correctly. Now, organizations with the same name and different case cannot exist, which causes behavior like this one. It also applies to the course catalog and dashboard.

This also causes CourseCreators cannot to access some courses of the same organization, because the permission check the case of the organization

When a user has an org assigned, he already has permisions to creat course, but the help "Becoming a course creator" is not aware of it and keeps poping.

Description

This PR #665 was merged in mango.master, and limonero.master but it wasn't merged in release, and for that reason, we didn't take it in account in the nuez migration, and It is not in upstream.

Are we going to migrate that PR?

cc @santiagosuarezedunext

Hi team!

We are experiencing an issue when trying to click on the textbook live view button, we are being redirected to a different domain "openedx.edunext.co" instead of the site domain, we believe the textbook live view button is not tenant aware.

Thanks a lot for your help.

Describe the bug
Views like api/enrollment/v1/enrollments/ are not filtered correctly.

To Reproduce
Steps to reproduce the behavior:
0. Crea at least two organizations, each one associated to only one tenant, and enroll users to course belonging to those organizations.

1. Go to 'api/enrollment/v1/enrollments/'
2. See all enrollment without filters

Expected behavior
FIlter enrollments using the current site.

Additional context
This is the view I found, but there might be others

in android mobile apps (I have not tested iOS yet) the list of courses is including courses from other tenants.
here is the example from one mobile app:

the web application is only showing the right ones.

@felipemontoya fyi

On the branch testing_pr_9282 b4900fb
The pr was applied and conflicts with our code were resolved. It seems ok and it does not break, but I don't know, having in mind our microsite changes, if it has sense. The code runs.

Description

"Course enrollment admin is slow" was a report from SD after migration.

Talking with @Ian2012, he thinks the problem is in the ordering. By default, the query order with user_id is 97secs, and without order, it takes 70secs.

We need to find where that class is ordered and modify it to solve this. If the product review accepts this, I don't know if we can extract this from the custom features in edx-platform to some eox or if we need to maintain this.

Extra info: https://user-images.githubusercontent.com/35668326/221997715-8ffabc76-bef7-46fb-8d93-4ce1cfd5dbc8.png