Search

Clear filter
Article
Eduard Lebedyuk · Mar 4, 2021

Get a list of cached queries and their texts

Recently I wanted to get a list of all cached queries and their texts. Here's how to do that.
Announcement
Rustam Ibragimov · Aug 4, 2016

UDL highlighting in Atom text editor

We have recently created a syntax highlighting for COS for Atom text editor.
Question
Niccolò Predebon · Nov 19, 2019

Import data from a text file

Hi everyone. I'm new to cache, and i was looking for a command who reads a .txt file and store the informations in variables. I've found on the documentation the EnsLib.SQL.SNapshot
Announcement
Neerav Verma · Jun 1, 2019

Create Excel Files From SQL (Via Business Operation)

%New()Set tmpFile = ##class(%File).TempFilename("xls") If (IsActive) {s lutFileName ="Test"_..DateTime()Set tmpFile = ##class(%File).GetDirectory(tmpFile)_lutFileName_".xls"If (##
Article
Sergey Mikhailenko · Jan 23, 2018

Recommendations on installing the InterSystems Caché DBMS for production environment

They can only be used in a product system after serious testing. I will be happy if this code helps you do your job better or avoid making mistakes.
Article
Sergei Sarkisian · Jul 18, 2022

Angular. Container and presentational components (aka smart-dumb)

making server calls, contains business logic, tightly coupled to other components, knows too much about other component’s or services’ internals, then it become bigger, harder to test
Article
José Pereira · Nov 29, 2022

IS technologies supporting the Pregnancy Symptoms Tracker app

Using OpenAPI has many advantages, like the design-first approach, easy change tracking, easy documentation, strong model, a lot of tools for designing, mocking, testing and so on.
Question
Laura Cavanaugh · Jul 17, 2017

Need variable number of query parameters in dynamic query

SIZE ((10)) )) " "returnParams")=1^llctemp("returnParams",1)=$lb("2902700","2869840","2870820","") That's my test data.
Article
Lorenzo Scalese · Apr 15, 2021

Environment setup with config-api

I'll keep this repo up to date for testing purposes if there is any change.
Article
Sabit Issakhan · Aug 29, 2019

Convert Cyrillic to Latin

абвгдезийклмнопрстуфхыэАБВГДЕЗИЙКЛМНОПРСТУФХЫЭЖЦЧШЮЯжцчшюяьЬъЪ", "abvgdeziyklmnoprstufhyeABVGDEZIYKLMNOPRSTUFHYE婨味䍨卨奵奡穨瑳捨獨祵祡"),"щ","shch"),"Ш","Sh"),"O","UnicodeBig"),$c(0)) } Here's tests
Article
David Hockenbroch · Oct 14, 2024

What's the Catch?

In many cases, you will select to undo whatever you were testing in your try block when there is an error. It is a perfect case for using transactions.
Question
Paul Riker · Apr 24, 2018

Custom Purge Job

previously written a task that accomplishes a similar goal as what you have described here.It is not IntereSystems official, but does follow good Ensemble coding practices and has tested
Question
Yone Moreno · Oct 14, 2021

How could we use MTOM to send a zip with a csv inside?

💭🤔 Also, in other tests, we have written 3 additional ways, to try to solve it: set ..ContentType="application/octet-stream; name=nombre" Using the above line, we
Question
Evgeny Shvarov · Mar 8, 2019

How to enable IRIS Text Analytics programmatically?

IRIS Text Analytics/iKnow and Analytics/DeepSee are enabled on per-application basis.
Article
Oleh Dontsov · Apr 18, 2023

AI generated text detection using IntegratedML

For example, text generation models based on neural networks can produce texts that are almost indistinguishable from texts written by humans.ChatGPT is one such service.