Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to find duplicates for a large text field in Caché Objects?

Question
Evgeny Shvarov · Nov 6, 2017

How to find duplicates for a large text field in Caché Objects?

Hi, folks!

Suppose you have a Caché class with %String property which contains relatively large text (from 10 to 2000 symbols).

The class:

Class Test.Duplicates Extends %Persistent 

{

Property Text As %String (MAXLEN = 2000);

}

And you have thousands of entries.

What are the best options to find entries which are duplicates on this property?

#Indexing #Object Data Model #ObjectScript #Caché

Source URL:https://community.intersystems.com/post/how-find-duplicates-large-text-field-cach%C3%A9-objects