Announcement Evgeny Shvarov · Oct 1, 2017 Developer Community September 2017 Digest Hi, Community!This post is a digest of the Developer Community postings in September 2017.Most viewedDeclarativeCOS — Declarative Programming in Caché 503New Programming Language - Discussion 318InterSystems IRIS Data Platform 253? Where/How can we touch IRIS ? 207InterSystems Global Summit 2017 Key Notes Live Stream 199Filtering non-printable characters 188Double dot? 172Search InterSystems documentation using iKnow and iFind technologies 168SPOOL - the fogotten device 167InterSystems Cloud Manager and Containers at GS2017 XP-Lab 166Vue.js: getting started with a basic HTML/REST/JSON example 162Pro Tip: Controlling your SysTray Cube icon appearance 155Widgets Direct 141Horizontal Scalability with InterSystems IRIS 138UnitTest : A Mocking Framework for InterSystems objectscript classes. 13 #Digest #Developer Community Official 2 0 0 297
Question Evgeny Shvarov · Sep 30, 2017 $CASE or $SELECT Analog in Cache´SQL Hi, folks! Is there any way to use $CASE or $SELECT functionality in SQL SELECT query? E.g. something like this: SELECT product, $CASE(status,"New":field1,"Payed":field2) as data from sales To see either in data column either field1 or field2 values in regard of status value. #SQL #Caché 0 3 0 815
Question Evgeny Shvarov · Sep 27, 2017 How to Automatically Grant Access For SQL Tables Which Are Involved in Listing of a Widget Hi, folks! When you deploy DeepSee solutions you often do not want grant a User %All Role to work with a particular Dashboard. Consider a Dashboard 'Dash' with a few widgets where listings are being used. If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access, grant access to a Dashboard resource (if any) and ... grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets. #Dashboards #Access control #Security #SQL #InterSystems IRIS BI (DeepSee) 1 3 0 461
Announcement Evgeny Shvarov · Sep 25, 2017 September 2017 DC Release Hi, Community!I'm pleased to announce that we deployed a new release of Developer Community.With this release we introduce:1. New post type is introduced: AnnouncementChoose Announcement as a post type if you want to say about a new product or feature release, about some new services in your company, if it is event announcement or there is a new job position open in your company. #Release #Developer Community Official 2 10 0 388
Announcement Evgeny Shvarov · Sep 15, 2017 Join InterSystems Developer Meetup on 17th of October in UK, Birmingham! Hi, Community!We are pleased to invite you to the InterSystems UK Developer Community Meetup on 17th of October!The UK Developer Community Meetup is an informal meeting of developers, engineers, and devops to discuss successes and lessons learnt from those building and supporting solutions with InterSystems products. #Meetup #Developer Community Official 3 10 0 665
Announcement Evgeny Shvarov · Sep 11, 2017 InterSystems Global Summit 2017 Key Notes Live Stream Hi, Community! The Global Summit 2017 Key Notes session will start in two hours at 9-00AM (PT). Here is the link for live streaming. Join! #Global Summit 2017 #Global Summit 1 5 0 582
Question Evgeny Shvarov · Sep 4, 2017 What is The Best Backup Strategy For a Small-sized Database in Caché? Hi, folks! What could be the best backup/restore strategy for a small (less than 100MB) but very valuable database which is placed on AWS/DO virtual host? 1. Use AWS/DO backup/restore features? 2. External backup (as the most recommended)? 3. InterSystems backup? 4. Globals export to a zipped file? 5. cache.dat copy? #AWS #Backup #System Administration #Caché 0 2 0 658
Announcement Evgeny Shvarov · Sep 1, 2017 Developer Community August 2017 Digest Hi, Community!This post is a digest of the Developer Community postings in August 2017.Most viewedYour Workflow: Issue Tracking, Version Control etc. 243Runtime type detection 217Feeling the power of Caché 188AES Encryption 159from the roots to InterSystems 156Load JSON from a file 149Server-side way to disable logins for all users 149Grafana-based GUI for mgstat, a system monitoring tool for InterSystems Caché, Ensemble or HealthShare 148Caché and Ensemble 2017.1.x on OpenVMS - Recall 145PDFs and Reading them 144Winning in GIS competition 135Frontier: A different way of working with REST 118Handling images with Caché & JSON, and why 57 is a magic number 117 #Digest #Developer Community Official 1 0 0 287
Question Evgeny Shvarov · Aug 28, 2017 How to add a new line in email? Hi, folks! I'm sending emails with %Net.MailMessage. How can I add a new line for the email body? The code is: dim msg as %Net.MailMessage = ##class(%Net.MailMessage).%New() set msg.Charset="UTF-8" do msg.TextData.Write("Dear "_Username) do msg.TextData.Write("Line1") do msg.TextData.Write("Line2") And I'm getting in email: Dear UserLine1Line2 How can I get: Dear User Line1 Line2 #ObjectScript #Caché 0 8 1 1.7K
Announcement Evgeny Shvarov · Aug 23, 2017 Share Your InterSystems Solution on InterSystems Global Summit 2017 Hi, Community!For those developers who are attending Global Summit 2017 this year: you have an opportunity to share your solutions, framework, and experience with the rest GS attendees and Developer Community.On Monday 11th we would have Developer Community Sessions in Tech Exchange Open House (see the agenda). #Global Summit 2017 #Video #Developer Community Official #Global Summit 6 11 0 637
Announcement Evgeny Shvarov · Aug 21, 2017 Get The First Row Seat on Global Summit 2017 Key Notes! Hi, Community! For those who plan to attend Global Summit 2017: we introduced the new reward: the first-row seat reserved for you on the Key Notes session. #Global Summit 2017 #Global Masters #Global Summit 1 0 0 365
Announcement Evgeny Shvarov · Aug 20, 2017 The Second August 2017 DC Release: Group and Members Improvements Hi, Community!I'm pleased to announce that we introduced the second release on DC in August. #Release #Developer Community Official 3 1 0 302
Announcement Evgeny Shvarov · Aug 10, 2017 Tag Indexing is Introduced Hi, Community!I just have introduced new tag Indexing which relates to articles and questions on how to introduce, manage and increase performance with Indexing on Caché Objects. #Indexing #Object Data Model #DC Feedback 1 0 0 270
Announcement Evgeny Shvarov · Aug 8, 2017 August DC Release: Search Engine Improvements Hi, Community!I'm pleased to announce that we deployed a new release of Developer Community.This release comes with improved Search.The updated search feature introduces full-text scan, auto complete for the key words, filters on articles, questions, comments, members and works faster. #Release #Developer Community Official 3 0 0 312
Question Evgeny Shvarov · Aug 7, 2017 %Status vs Other Return Values in Caché ObjectScript Methods Hi, folks!There is an interesting discussion in the neighboring topic which raises a question for me: is there any reason to have %Status as a return value for COS method? #Object Data Model #ObjectScript #Caché 1 16 0 2.6K
Announcement Evgeny Shvarov · Aug 7, 2017 New tags introduced: Containerization, Docker, Microservices Hi, Community!Due to increasing number of new questions and articles regarding containerization, docker, microservices we've introduced certain tags. Subscribe and use it in your postings.If you have any ideas for new tags to be introduced, please add your ideas in comments. #DC Feedback 1 0 0 166
Announcement Evgeny Shvarov · Aug 2, 2017 InterSystems Developer Meetup: Who are the Presenters? Hi, Community! You know we would have a meetup in Boston on the 8th of July August with the following agenda: Time Topic Presenter 5-30pm Registration and welcome coffee #Events #Meetup #Other 2 6 0 414
Announcement Evgeny Shvarov · Aug 1, 2017 InterSystems Articles and Questions Digest, July 2017 Hi, Community!This post is a digest of the Developer Community postings in July 2017.Most viewedMonCaché - Caché as MongoDB 236Developer Community Meetup in Cambridge 197Need variable number of query parameters in dynamic query 190how to release memory for process? 180 #Digest #Developer Community Official 0 0 0 242
Question Evgeny Shvarov · Jul 31, 2017 How to programmatically obtain the URL for CSP application on a given server? Hi, folks!Suppose I have a CSP app, which provides some service.And the code of my App knows the name of the CSP App in form: /myappnameHow can I programmatically obtain the URL for CSP apps to send the full qualified link to the users(e.g. via email) of my app?E.g. https://productionserver.com/myappname #ObjectScript #CSP #Caché 1 6 0 454
Announcement Evgeny Shvarov · Jul 24, 2017 Come to the 1st InterSystems Community Meetup in Cambridge! Hi, Community! Recently we announced Developer Community Meetup in Cambridge, MA. Let me describe what is it. Meetup it's a one evening event where you can enjoy some sessions by presenters (today InterSystems engineers, tomorrow you can be a presenter) and chat with local developers and InterSystems developers, engineers and product managers (depends on who is in town) and discuss your problems, experience, and success with InterSystems technologies. #Events #Meetup #Other 1 0 0 275