[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: |
|
| Documentation Changes: | Not Needed |
| Description |
Descrição do problemaAo 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: O autor explora duas possibilidades 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! 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! |