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?
go to post Evgeny Shvarov · Oct 31, 2017 Thanks, Eduard!This is very helpful. May I ask, what are the caveats using basic authentication instead of CLP (Caché Login Page)?
go to post Evgeny Shvarov · Oct 31, 2017 This is really nice!And short, so very is suitable for macro.
go to post Evgeny Shvarov · Oct 30, 2017 Hi, Soufiane!I don't know the answer, but I can recommend these articles (Oauth 2.0 part 1, part 2, part 3) and these videos (one, two)
