Hi, Community! This post is a digest of the Developer Community postings in July 2017. **Most viewed** [MonCaché - Caché as MongoDB](https://community.intersystems.com/node/431751)  236 [Developer Community Meetup in Cambridge](https://community.intersystems.com/node/434436)  197 [Need variable number of query parameters in dynamic query](https://community.intersystems.com/node/434301)  190 [how to release memory for process?](https://community.intersystems.com/node/434331)  180 [Old/New Dynamic SQL Cheat Sheet](https://community.intersystems.com/node/434376)  172 [Atelier & Git? ](https://community.intersystems.com/node/433641)  169 [[Fixed in 2018.1.1 + quick fix] Anomaly in German sorting](https://community.intersystems.com/node/434626)  154 [Connecting to a web service](https://community.intersystems.com/node/434321)  148 [use punycode in caché](https://community.intersystems.com/node/434096)  141 [Estimation techniques in intersystems](https://community.intersystems.com/node/434011)  136   **Most voted** [MonCaché - Caché as MongoDB](https://community.intersystems.com/node/431751)  8 [Globals - Magic swords for storing data. Sparse arrays. Part 3.](https://community.intersystems.com/node/433311)  5 [Old/New Dynamic SQL Cheat Sheet](https://community.intersystems.com/node/434376)  5 [Indexing of non-atomic attributes](https://community.intersystems.com/node/433831)  4 [Atelier 1.1 Beta Updates – July 2017](https://community.intersystems.com/node/434056)  4 [Visualizing Ensemble Workflow task execution](https://community.intersystems.com/node/433991)  3 [use punycode in caché](https://community.intersystems.com/node/434096)  3 [Community Members' Analytics](https://community.intersystems.com/node/434561)  3 [[Fixed in 2018.1.1 + quick fix] Anomaly in German sorting](https://community.intersystems.com/node/434626)  3 [Get your Global Summit Registration with $200 or $300 off!](https://community.intersystems.com/node/433741)  2   **Most commented** [Need variable number of query parameters in dynamic query](https://community.intersystems.com/node/434301)  29 [how to release memory for process?](https://community.intersystems.com/node/434331)  24 [Check if class exists](https://community.intersystems.com/node/434566)  16 [Connecting to a web service](https://community.intersystems.com/node/434321)  11 [MonCaché - Caché as MongoDB](https://community.intersystems.com/node/431751)  10 [How to escape the single quote in the single quoted string](https://community.intersystems.com/node/433596)  10 [Is there a way to map a $lb() to its data model ?](https://community.intersystems.com/node/434126)  9 [Installation problems with Cache](https://community.intersystems.com/node/434616)  9 [How to detect if string data is number and integer in COS ?](https://community.intersystems.com/node/434801)  9 [DTL with subTransformation to get Message Details](https://community.intersystems.com/node/433726)  8   **Top 10 Authors to Follow** [Evgeny Shvarov](https://community.intersystems.com/user/11016), [Posts](https://community.intersystems.com/user/11016/posts),  452 [Maks Atygaev](https://community.intersystems.com/user/46206), [Posts](https://community.intersystems.com/user/46206/posts),  236 [Lexi Hayden](https://community.intersystems.com/user/36), [Posts](https://community.intersystems.com/user/36/posts),  172 [Robert Cemper](https://community.intersystems.com/user/69016), [Posts](https://community.intersystems.com/user/69016/posts),  154 [Benying Zou](https://community.intersystems.com/user/67381), [Posts](https://community.intersystems.com/user/67381/posts),  141 [Rob Tweed](https://community.intersystems.com/user/27171), [Posts](https://community.intersystems.com/user/27171/posts),  128 [Sergey Kamenev](https://community.intersystems.com/user/54892), [Posts](https://community.intersystems.com/user/54892/posts),  125 [Joyce Zhang](https://community.intersystems.com/user/10076), [Posts](https://community.intersystems.com/user/10076/posts),  121 [Anastasia Dyubaylo](https://community.intersystems.com/user/48851), [Posts](https://community.intersystems.com/user/48851/posts),  114 [RB Omo](https://community.intersystems.com/user/13856), [Posts](https://community.intersystems.com/user/13856/posts),  88   **Top 10 Experts to Follow** [Vitaliy Serdtsev](https://community.intersystems.com/user/12121), [Answers](https://community.intersystems.com/user/12121/answers),  +29 [Eduard Lebedyuk](https://community.intersystems.com/user/11041), [Answers](https://community.intersystems.com/user/11041/answers),  +19 [Sean Connelly](https://community.intersystems.com/user/55176), [Answers](https://community.intersystems.com/user/55176/answers),  +10 [John Murray](https://community.intersystems.com/user/14096), [Answers](https://community.intersystems.com/user/14096/answers),  +5 [Robert Cemper](https://community.intersystems.com/user/69016), [Answers](https://community.intersystems.com/user/69016/answers),  +5 [Dmitry Maslennikov](https://community.intersystems.com/user/11906), [Answers](https://community.intersystems.com/user/11906/answers),  +4 [Timothy Leavitt](https://community.intersystems.com/user/10056), [Answers](https://community.intersystems.com/user/10056/answers),  +3 [Danny Wijnschenk](https://community.intersystems.com/user/54251), [Answers](https://community.intersystems.com/user/54251/answers),  +3 [Rubens Silva](https://community.intersystems.com/user/59656), [Answers](https://community.intersystems.com/user/59656/answers),  +3 [Alexander Koblov](https://community.intersystems.com/user/9906), [Answers](https://community.intersystems.com/user/9906/answers),  +2   **By Tags**
Articles Questions
Announcements
Developer Community June 2017 Digest  
New Video: Many Data Sources - One Application  
Get your Global Summit Registration with $200 or $300 off!  
Video of the week: Upgrades - Minimizing Business Disruption  
Developer Video of the Week: Proactive Alerting - Advanced Approaches for Alerting Solutions  
Developer Community Meetup in Cambridge  
Community Members' Analytics  
Come to the 1st InterSystems Community Meetup in Cambridge!  
July 27, 2017 – Alert: Linux Defects Can Corrupt Mirror Copies of Journal Files  
Video of the week: LDAP - Beyond the Simple Schema  
 
Atelier
Atelier 1.1 Beta Updates – July 2017 Atelier & Git?
  Exporting project in Atelier
 
Caché
MonCaché - Caché as MongoDB How to Enable iKnow Functionality in InterSystems Caché
Globals - Magic swords for storing data. Sparse arrays. Part 3. Read in and process function keys
Indexing of non-atomic attributes AngularJS vs Cache
Installation/Upgrade on Windows Can Fail With "Visual C++ 2013 redistributables (x86) not found!" execute sql from the Caché Terminal command line , prompt error " *Execute,%SYSTEM.SQL"
use punycode in caché What is the size of Caché ObjectScript variable?
Old/New Dynamic SQL Cheat Sheet How to delete Caché global by its value in Caché ObjectScript?
[Fixed in 2018.1.1 + quick fix] Anomaly in German sorting How to escape the single quote in the single quoted string
What is APM? Implementing a Native Client for C#
JSON Web Tokens are now Supported by QEWD.js stored procedure %SYSTEM.SQL_TableExists
Introduction to QEWD Micro-Services select some rows from table return error
Creating a QEWD Micro-Service What does 'Unable to start the database read test' refer to?
  DTL with subTransformation to get Message Details
  How can I make my text behave in accordance with gravity?
  Protocol Buffers
  changed data in field ignored when saving changes
  How to Get the Source Code of a Class on Remote Server?
  How to encrypt column value in sql?
  SHA256 Signing with RSA PSS padding
  Cache SQL and multiple-event triggers
  How to create method by script?
  Utility to find differences between databases?
  dotenv: Read enviroment variables from a .dotenv or straight from your OS
  Relationships - iterate through all the Manys' side
  Is there a function for convert string to hex?
  Cannot call job for instance method?
  Need clarification on usage of globals and global memory
  Database Wildcards
  .Net Gateway Parallel Calls – Optimal Number?
  Changing class definition at compilation time
  Is there a way to map a $lb() to its data model ?
  The command to kill all globals given the namespace
  In a bit of a cache.dat pickle
  How can I determine if a query is an SQL or an MDX query
  How to specify the UrlMap for Rest call
  How to index a class
  How to configure the size for global buffer
  Reverse byte order of an 8-bit string from big-endian to little-endian
  How to Discover What's Inside the Global?
  Need variable number of query parameters in dynamic query
  Use a global stored in variable.
  Connecting to a web service
  how to release memory for process?
  Trigger a class compilation
  How to dynamically change the entry defined in SQL storage map
  ODBC to Cache with Dynamic Table Names
  Using WHERE clause on a sub-query populated column
  What is the most efficient way to store/retrieve the data into/from global
  Problem with setting a property
  Cursor placement
  $Case or $Select?
  how to redirect IO
  select sql error
  Check if class exists
  Using %CSP.REST to serve files
  Installation problems with Cache
  How to automatically populate a transient array property?
  [Fixed]Error with ECP
  Working with external SQL table in cache
  Crystal_Report with Cache
  Print html file on the Server Side, Using Cache technologies
  [Fixed]Call REST Service on CSP Gateway Server
  REST: How to pass query parameters
  Get STACK of another process
  Best way to determine if SMP is used with https
  How to detect if string data is number and integer in COS ?
  .xls format output printing with blank space between lines
  M Global Data export to XML with schema
  How to programmatically obtain the URL for CSP application on a given server?
  Streaming data from Cache
 
DeepSee
  Deepsee - Functions with Time
  Localization of DeepSee Pivots
  Is it possible to import a Cube from SQLServer (format .abf) in Cache?
 
Ensemble
file name passthrough and extending a class to override a method Available API for Creating a Business Service
Visualizing Ensemble Workflow task execution Creating a scheduled operation
  Is there any settings for do automatic logout in intersystem.
  Alerts via API / Web Services
  Change Management for Ensemble System Default Settings
  Estimation techniques in intersystems
  EmergencyId startup
  RuleSet with a Dynamic Target
  ClassMethod Transform Count Number of OBX's Under OBR
  Ens.FileInboundAdapter consuming files in sequence order
  Ensemble production change logging
  Purge for "IO Log Input Data"
  Discarding Received non HL7 data
  Using Macro Definitions in Installation Manifests
  SQL Inbound Adapter - Not returning all the records it should from a View in Micrsoft SQL Server
  Ens.StreamContainer
  Ensemble passthrough configuration
  Ensemble async passthrough configuration
  Business Processor: Unable to reference a property in the 'request' object
  Posting to a REST service
 
Global Summit
Global Summit 2017 - Early Bird Rate & Group Discounts Way, way out of my price range
Partner Pavilion @ Global Summit 2017  
 
HealthShare
  Dialog windows not drawing correctly in IE11
  Estimation techniques in intersystems
  See June 2017 digest