cozy / cozy-drive

Cozy Drive Web App for Cozy Cloud
GNU Affero General Public License v3.0
169 stars 64 forks source link

[VO-749] fix: Recent view query was malformed #3181

Closed paultranvan closed 2 months ago

paultranvan commented 2 months ago

After 6e1041f2c21c6dbc0802464af3c57f30ffedb4a9, the recent view was broken, because it introduced the dir_id sort before the updated_at sort, which is problematic, as the dir_id is meaningless for the user. Thus, we fix this by using a (type, updated_at) sort.

Furthermore, we now use a partial index for better performances.

### ✨ Features

*

### 🐛 Bug Fixes

* Recent view was not displaying in correct order

### 🔧 Tech

*
bundlemon[bot] commented 2 months ago

BundleMon

Files updated (3) Status | Path | Size | Limits :------------: | ------------ | :------------: | :------------: :white_check_mark: | app/drive.(hash).js
| 173.57KB (-12B -0.01%) | 300KB :white_check_mark: | public/drive.(hash).js
| 1.56MB (-12B 0%) | 1.7MB :white_check_mark: | intents/drive.(hash).js
| 105.59KB (-14B -0.01%) | 190KB
Unchanged files (15) Status | Path | Size | Limits :------------: | ------------ | :------------: | :------------: :white_check_mark: | vendors/drive.(hash).js
| 1.78MB | 2MB :white_check_mark: | public/pdf.worker.entry.(hash).worker.js
| 345.35KB | 350KB :white_check_mark: | services/qualificationMigration/drive.js
| 279.42KB | 500KB :white_check_mark: | services/dacc/drive.js
| 260.44KB | 500KB :white_check_mark: | public/cozy-client-js.js
| 159.28KB | 160KB :white_check_mark: | public/drive.(hash).min.css
| 69.72KB | 100KB :white_check_mark: | app-drive.(hash).min.css
| 37.85KB | 56KB :white_check_mark: | intents-drive.(hash).min.css
| 33.01KB | 40KB :white_check_mark: | onlyOffice/slide.pptx
| 24.83KB | 25KB :white_check_mark: | onlyOffice/text.docx
| 5.85KB | 6KB :white_check_mark: | onlyOffice/spreadsheet.xlsx
| 5.02KB | 6KB :white_check_mark: | manifest.webapp
| 1.87KB | 2KB :white_check_mark: | index.html
| 595B | 1KB :white_check_mark: | intents/index.html
| 506B | 1KB :white_check_mark: | manifest.json
| 185B | 1KB

Total files change -37B 0%

Groups updated (3) Status | Path | Size | Limits :------------: | ------------ | :------------: | :------------: :white_check_mark: | app/**
| 173.57KB (-12B -0.01%) | - :white_check_mark: | public/**
| 2.13MB (-12B 0%) | - :white_check_mark: | intents/**
| 106.08KB (-14B -0.01%) | -
Unchanged groups (4) Status | Path | Size | Limits :------------: | ------------ | :------------: | :------------: :white_check_mark: | vendors/**
| 1.78MB | - :white_check_mark: | services/**
| 539.86KB | - :white_check_mark: | onlyOffice/**
| 35.7KB | - :white_check_mark: | img/**
| 3.41KB | -

Final result: :white_check_mark:

View report in BundleMon website ➡️


Current branch size history | Target branch size history