1

I am working on realm Database in one of my projects. I want to implement COLLATE function(SQL) in one of my realm queries. Is there any way I can add that.

My Realm Query:

ArrayList<FolderTable> = (ArrayList<FolderTable>) realm.copyFromRealm(realm.where(FolderTable.class).equalTo("folderType", "ICD10").and().equalTo("isFolderDeleted", "false").sort("folderName").findAll());

Reference SQL query: 

select _id, folderName from folderTable where folderType="ICD10" and  isFolderDeleted="false" order by folderName COLLATE NOCASE ASC
Mehta
  • 1,228
  • 1
  • 9
  • 27
  • sorting case insensitively is not supported in realm https://github.com/realm/realm-java/issues/2291 – Mehmet K Apr 24 '18 at 11:05
  • I just stored an additional field that had all accents removed and queried on top of that, see https://stackoverflow.com/a/4122200/2413303 – EpicPandaForce Apr 24 '18 at 12:37

0 Answers0