[COMPASS-6929] Consulta não ordenada corretamente Created: 15/Jun/23  Updated: 07/Jul/23  Resolved: 07/Jul/23

Status: Closed
Project: Compass
Component/s: Query
Affects Version/s: 1.36.4
Fix Version/s: No version

Type: Bug Priority: Major - P3
Reporter: Fernando Patrick Rodrigues Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

windows


Attachments: File Keywords.json     PNG File image-2023-06-15-20-41-44-278.png     PNG File image-2023-06-15-20-49-52-197.png    
Documentation Changes: Not Needed

 Description   

Descrição do problema

Ao tentar ordenar uma consulta na coleção diretamente pelo mongodb compass, a lista de resultado traz os itens não ordenados corretamente, pesquisando possíveis soluções para o problema encontrei este link abaixo:

https://medium.com/@nirmal.seneviratne/fixing-a-mongodb-sorting-error-27d6fcdf5806

O autor explora duas possibilidades
1ª aumentar disponibilidade de memória RAM
2ª criação de índices para classificação 

Não obitive sucesso em nenhuma das duas abordagens, tanto diretamente em uma imagem docker como também no ambiente atlas cloud, sem sucesso. (ambos apresentam mesmo resultado)

Vide imagem abaixo:

Dados para reproduzir o problema:

Filter => {LanguageType : "Formula", "Properties.CultureInfo" : "english-UNITEDSTATES" }

Sort => { Name : 1 }

Em anexo: Keywords.json

sobre a versão do mongodb compass:

 



 Comments   
Comment by PM Bot [ 07/Jul/23 ]

There hasn't been any recent activity on this ticket, so we're resolving it. Thanks for reaching out! Please feel free to reopen this ticket if you're still experiencing the issue, and add a comment if you're able to provide more information.

Comment by PM Bot [ 29/Jun/23 ]

Hi fernando.prodrigues@totvs.com.br! COMPASS-6929 is awaiting your response.

If this is still an issue for you, please open Jira to review the latest status and provide your feedback. Thanks!

Comment by Basit Chonka [ 21/Jun/23 ]

Hi fernando.prodrigues@totvs.com.br

Thanks for reaching out. It seems that your query is missing `collation` option, which can be specified in the query bar next to sort. If you add `{locale: 'en'}` collation option to your query it sorts the data correctly. 

For more information on collation, check this link

Thanks.

 

Comment by PM Bot [ 15/Jun/23 ]

Hello fernando.prodrigues@totvs.com.br, thank you for reaching out to us! The team will review your issue and get back to you soon as soon as possible.

Please review your issue to ensure you've included your environment details and have attached relevant logs (with any sensitive data redacted), so that we're best able to provide you a timely and thorough response. Thanks again!

Generated at Wed Feb 07 22:44:47 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.