Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA | vasudevpathak(*) |
| Priority | Major |
| Complexity | Unknown |
| Component | MongoJS |
| Version | 19.0 |
db.createCollection("employees", { "collation" : { "locale" : "en_US", "caseLevel" : true, "caseFirst" : "lower", "strength" : 1, "numericOrdering" : false, "alternate" : "non-ignorable", "maxVariable" : "punct", "backwards" : false } })
db.employees.insert({ "_id" : 1, "name" : "Dev" }) db.employees.insert({ "_id" : 2, "name" : "Eliot", "reportsTo" : "Dev" }) db.employees.insert({ "_id" : 3, "name" : "Ron", "reportsTo" : "Eliot" }) db.employees.insert({ "_id" : 4, "name" : "Andrew", "reportsTo" : "Eliot" }) db.employees.insert({ "_id" : 5, "name" : "Asya", "reportsTo" : "Ron" }) db.employees.insert({ "_id" : 6, "name" : "Dan", "reportsTo" : "Andrew" })
db.employees.find( { "name": "Ron" } ).collation( { locale: "en_US", strength: 1 } )
|
|
14 KB
|
|
135 KB
|
|
81 KB
|
|
178 KB
- Integrate MongoDB 3.4 JavaScript files with MongoJS.
- Update the SHOW COLLECTIONS, SHOW VIEWS, and SHOW INDEXES commands to return COLLATION_OPTION.
- Enhance the following dialogs to include the Collation tab:
Create Collection / Alter Collection / Collection Properties dialog
Create View / View Properties dialog
Create Index / Index Properties dialog
- The Collation tab contains all the parameters for the Collation document. When a locale is selected, populate the default parameters for the selected locale.
https://docs.mongodb.com/manual/reference/collation-locales-defaults/#collation-default-parameters
- When doing Script Object for a Collection, View, or Index object, include collation clause if it is defined for the object.
- In ER Modeler, enhance the following dialogs to include the Collation tab:
Collection Properties dialog and Collection Viewer
View Properties dialog and View Viewer
Index Properties dialog
- When saving an ER Model in .xed, include collation data.
Verified in ADS-19-dev-8.
Please refer: verify14885.png
Verified in ADS-19-dev-8.
Please refer: verify14885.png
Reverified in ADS-19-alpha-22.
Please refer: reverify14885.png
Reverified in ADS-19-alpha-22.
Please refer: reverify14885.png
Issue #14885 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 19.0.0-dev-8 |
| No time estimate |
- Integrate MongoDB 3.4 JavaScript files with MongoJS.
- Update the SHOW COLLECTIONS, SHOW VIEWS, and SHOW INDEXES commands to return COLLATION_OPTION.
- Enhance the following dialogs to include the Collation tab:
Create Collection / Alter Collection / Collection Properties dialog
Create View / View Properties dialog
Create Index / Index Properties dialog
- The Collation tab contains all the parameters for the Collation document. When a locale is selected, populate the default parameters for the selected locale.
https://docs.mongodb.com/manual/reference/collation-locales-defaults/#collation-default-parameters
- When doing Script Object for a Collection, View, or Index object, include collation clause if it is defined for the object.
- In ER Modeler, enhance the following dialogs to include the Collation tab:
Collection Properties dialog and Collection Viewer
View Properties dialog and View Viewer
Index Properties dialog
- When saving an ER Model in .xed, include collation data.