go to post Evgeny Shvarov · Nov 13, 2017 Hi, Kevin!I can advise trying Caché Class Explorer which exposes packages, classes, methods with code and interactively points to classes documentation on a given server and can be used to solve your task in my opinion.Pinging @Nikita.Savchenko to provide more information.
go to post Evgeny Shvarov · Nov 10, 2017 Hi, Romero!Look at this project which does search for Documentation with iKnow and iFind by @Константин Ерёмин. Demo. Github.It uses iKnow for autocomplete functionality in a search box.
go to post Evgeny Shvarov · Nov 9, 2017 Hi, Vitaly!Thanks for your input! This is very interesting and totally different approach to solve the task which I like every time about InterSystems technology that problems can be solved with different approaches and you never know how many options even exist )
go to post Evgeny Shvarov · Nov 9, 2017 Hi!Here is the remastered version of Meetup live stream recording.
go to post Evgeny Shvarov · Nov 7, 2017 So, the final recipe looks like following:For Insert and Update calculate the hash e.g. with MD5 and put it in Hash property. Index it with not unique index.Find duplicates with SQL query on Hash where group by for hash shows more than one occurrence.Loop through all the values with same hash just and check Text property values to be sure that they are duplicates but not hash collisions.Thanks, Alex, Dmitry, Robert!
go to post Evgeny Shvarov · Nov 7, 2017 True, but it can find also similar, but not identical, right?
go to post Evgeny Shvarov · Nov 7, 2017 Thank you, Mike! Indeed the results are odd sometimes. We'll investigate the case.
go to post Evgeny Shvarov · Nov 6, 2017 Thanks, @Alexey Maslov! What is the preferred algorithm to use hashes in this case?And what about collisions? Should I care about that too?
go to post Evgeny Shvarov · Nov 6, 2017 Thanks, Eduard. But I'm looking for duplicates, not for similar records. How can %SIMILARITY help here?
go to post Evgeny Shvarov · Nov 6, 2017 Thanks, Dmitry. Yes, the focus is - best performance.But what about the index declaration? There is a limitation of 511 symbols in an index, right?Should I put that in an index declaration or it will solve it for me automatically if I index an entry with value >511 symbols?
go to post Evgeny Shvarov · Nov 6, 2017 I also want to share Atelier playlist on the InterSystems Developers YouTube Channel which contains several "How to with Atelier" videos. Stay tuned!
go to post Evgeny Shvarov · Nov 1, 2017 Hi, Lin!You are creating this calculated dimensions as shared members. In this case, they are stored in some ^DeepSee.* global.One of the options to avoid calculated dimensions' storage in the global and further deployment difficulties you can use calculated members with Shared Storage option turned off.You can alter this option if you create calculated dimension in a named and saved pivot.In this case, the calculated measure definition will be placed directly in the MDX query of this pivot thus you don't need to deploy it, cause it will live with the pivot.
go to post Evgeny Shvarov · Oct 31, 2017 Hi, Ron!Just checked it - all works fine. What is the error you are having?