{"action":"created","issue":{"url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/453","repository_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet","labels_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/453/labels{/name}","comments_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/453/comments","events_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/453/events","html_url":"https://github.com/Azure/azure-documentdb-dotnet/issues/453","id":305912560,"number":453,"title":"Case insensitive \"OrderBy\"","user":{"login":"Darktaelb","id":23211927,"avatar_url":"https://avatars2.githubusercontent.com/u/23211927?v=4","gravatar_id":"","url":"https://api.github.com/users/Darktaelb","html_url":"https://github.com/Darktaelb","followers_url":"https://api.github.com/users/Darktaelb/followers","following_url":"https://api.github.com/users/Darktaelb/following{/other_user}","gists_url":"https://api.github.com/users/Darktaelb/gists{/gist_id}","starred_url":"https://api.github.com/users/Darktaelb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Darktaelb/subscriptions","organizations_url":"https://api.github.com/users/Darktaelb/orgs","repos_url":"https://api.github.com/users/Darktaelb/repos","events_url":"https://api.github.com/users/Darktaelb/events{/privacy}","received_events_url":"https://api.github.com/users/Darktaelb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"bchong95","id":4381236,"avatar_url":"https://avatars3.githubusercontent.com/u/4381236?v=4","gravatar_id":"","url":"https://api.github.com/users/bchong95","html_url":"https://github.com/bchong95","followers_url":"https://api.github.com/users/bchong95/followers","following_url":"https://api.github.com/users/bchong95/following{/other_user}","gists_url":"https://api.github.com/users/bchong95/gists{/gist_id}","starred_url":"https://api.github.com/users/bchong95/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bchong95/subscriptions","organizations_url":"https://api.github.com/users/bchong95/orgs","repos_url":"https://api.github.com/users/bchong95/repos","events_url":"https://api.github.com/users/bchong95/events{/privacy}","received_events_url":"https://api.github.com/users/bchong95/received_events","type":"User","site_admin":false},"assignees":[{"login":"bchong95","id":4381236,"avatar_url":"https://avatars3.githubusercontent.com/u/4381236?v=4","gravatar_id":"","url":"https://api.github.com/users/bchong95","html_url":"https://github.com/bchong95","followers_url":"https://api.github.com/users/bchong95/followers","following_url":"https://api.github.com/users/bchong95/following{/other_user}","gists_url":"https://api.github.com/users/bchong95/gists{/gist_id}","starred_url":"https://api.github.com/users/bchong95/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bchong95/subscriptions","organizations_url":"https://api.github.com/users/bchong95/orgs","repos_url":"https://api.github.com/users/bchong95/repos","events_url":"https://api.github.com/users/bchong95/events{/privacy}","received_events_url":"https://api.github.com/users/bchong95/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-03-16T12:38:30Z","updated_at":"2018-03-23T21:52:42Z","closed_at":null,"author_association":"NONE","body":"Hello!\r\n\r\nI'm working with **DocumentDB** using **.Net Core lib**. I'd tried to do case insensitive ordering using **LINQ** or **stored procedures.**.. But nothing worked fine.\r\n\r\nI'll be very grateful if somebody help me with questions:\r\n1. How to make _case insensitive_ sorting at database-side **without using extra fields with lower case**?\r\n\r\n2. Maybe also someone knows a way of realizing this feature using _case insensitive_ **indexes**?\r\n\r\nThank you for your attention."},"comment":{"url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/comments/375808256","html_url":"https://github.com/Azure/azure-documentdb-dotnet/issues/453#issuecomment-375808256","issue_url":"https://api.github.com/repos/Azure/azure-documentdb-dotnet/issues/453","id":375808256,"user":{"login":"kirankumarkolli","id":6880899,"avatar_url":"https://avatars2.githubusercontent.com/u/6880899?v=4","gravatar_id":"","url":"https://api.github.com/users/kirankumarkolli","html_url":"https://github.com/kirankumarkolli","followers_url":"https://api.github.com/users/kirankumarkolli/followers","following_url":"https://api.github.com/users/kirankumarkolli/following{/other_user}","gists_url":"https://api.github.com/users/kirankumarkolli/gists{/gist_id}","starred_url":"https://api.github.com/users/kirankumarkolli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kirankumarkolli/subscriptions","organizations_url":"https://api.github.com/users/kirankumarkolli/orgs","repos_url":"https://api.github.com/users/kirankumarkolli/repos","events_url":"https://api.github.com/users/kirankumarkolli/events{/privacy}","received_events_url":"https://api.github.com/users/kirankumarkolli/received_events","type":"User","site_admin":false},"created_at":"2018-03-23T21:52:41Z","updated_at":"2018-03-23T21:52:41Z","author_association":"CONTRIBUTOR","body":"@bchong95 please look into this."}}
{"actor":{"display_login":"kirankumarkolli"}}