Hello community! I have to work with queries using all kinds of methods like embedded sql and class queries. But my favorite is dynamic sql, simply because of how easy it is to manipulate them at runtime. The downside to writing a lot of these is the maintenance of the code and interacting with the output in a meaningful way. In an effort to have as much dynamism as possible so that we're not rewriting code constantly, and so that we have as little code possible (while still making sense and getting the job done), I made a function that takes in any dynamic query and outputs a dynamic object.

Hi Everyone!

Please watch the new video on InterSystems Developers YouTube, recorded by @Sourabh Sethi  in a new format called "Coding Talks":

A SOLID Design in InterSystems ObjectScript

Hello,

I have a large Data Lookup Table (> 150,000 records). It is too large to be opened from Ensemble --> Configure --> Data Lookup Tables to be deleted.

Is there another way that I can delete this table?

Thank you.

Hello,

I've got similar question as I have mentioned here once. Itś about enviroment variables and getting their values into manifest.

Now a know, that I must use this method $system.Util.GetEnviron("")  but still if I try to use it it doesn't work. I need to set variable in bash.sh file and then get that value into manifest. If I try this in terminal it works only for system variables as you can see, but it shoul normally works for user variables to or not?

I've tried this this syntax several times and it was working until I've reinstall my Ensemble instantion:

<Var Name="SYSPath" Valu

Hello,

I've got a csp page that has successfully set up a websocket connection to a Cache class. When the websocket object's close function is triggered at the browser I was expecting one of the class' methods to fire at the server. The onclose method is triggered at the browser but nothing at the server. Is a method supposed to fire at the server?

Thanks,

Dan

Cache for Windows (x86-64) 2015.1.4 (Build 803_6) Tue May 15 2018 12:08:36 EDT

As a developer, you have probably spent at least some time writing repetetive code. You may have even found yourself wishing you could generate the code programmatically. If this sounds familiar, this article is for you!

We'll start with an example. Note: the following examples use the %DynamicObject interface, which requires Caché 2016.2 or later. If you are unfamiliar with this class, check out the documentation here: Using JSON in Caché. It's really cool!

##Example

You have a %Persistent class that you use to store data. Now, suppose that you are ingesting some data in JSON format, using th

Hi all,
I hope this is the right forum to ask this type of question, but I'm running out of ideas.
For reasons beyond my control, we run a version of Intersystems Caché (2013.1) that is not supported by Atelier. As such, I use Caché Studio to do my development.
The issue I have is, I don't run Windows or MAC, but Linux (Ubuntu 18.04 in my case). I've successfully managed to get Studio working using Wine and pretty much everything is usable. 
There is just *one* issue which neither me or my peers can solve. If you hover over a line in the code editor, a tooltip reading 'First record' appears. This

Hello everyone, it took some time but I'm finally getting things done again. Phew! But for now, allow me to introduce a tool that I've been using frequently.

I call it Forgery.

This description has been taken from my GitHub repository, also available on OpenExchange:

Forgery is a server-side utility that allows executing simulated HTTP request by forging calls to REST applications. This makes Forgery ideal for using together with test suites that need to call the API via HTTP but could face issues with license usage and its grace period.

This works just like having a command-line agent that ex

Hi Developers!

We are ready to present you a new release of InterSystems Open Exchange. What's new?

• Applications rating;
• Open Exchange profile  <-> InterSystems Developers profile linkage.

See the details below.

Opportunities exists for keen Caché developers to join our established software house in Redditch.

The Company

M-Tech Computers Ltd (www.amo.co.uk) is a successful independent software & IT Services company based in Redditch. M-Tech sells and supports AMO, a comprehensive multi-channel ERP solution including e-Commerce websites.

AMO is an integrated suite of software which covers all aspects of running a business including Sales from multiple channels (web sites, eBay, Amazon etc.) Accounts, Stock Control, Warehousing, Marketing, Purchasing and integrates with a variety of 3rd party payments gat

Hi,

I'm trying to send a file to other system using "Enslib.FTP.PassthroughOperation" and use below settings for connection and retry,

Connection Settings
StayConnected : -1 
ConnectTimeout : 30

Additional Settings
RetryInterval : 15 
FailureTimeout : 240

As per my analysis, if the connection is failed, it retries 16 times (FailureTimeout/RetryInterval). Initially, I assumed that ConnectTimeout also involves with RetryInterval and the total number of retry would be 6 times (FailureTimeout/(RetryInterval+ConnectTimeout)).

Still, it is not clear to me whether Ensemble considers "ConnectTimeout" during re

Hi Everyone!

You're very welcome to watch the new video on InterSystems Developers YouTube, recorded by @Evgeny Shvarov in the new format called "Coding Talks":

GitHub Flow with InterSystems IRIS: Edit with VSCode, Test with Docker, Commit, Push, Pull Request

Hi Community!

How can I know the port of management portal e.g. from terminal?

The one which looks like

localhost:port/csp/sys/exp/%25CSP.Portal.Home.zen 

in browser?

Available at:

https://hub.docker.com/r/yape/yape/

$ docker container run --rm -v "$(pwd)":/data yape/yape --version
yape 2.2.6

See the readme at:

https://github.com/murrayo/yape

Changes include:

• Reinstate config file, make some more changes to smarter x and y axis.
• Update line style choices in config file.
• Solve for yyyy dates and yy dates or bail out. Make date string consistent for windows title (drop decimal places), add short day to title. 
• Increase decimal precision for y axis less than 10, eg for windows sec/read is seconds not ms like linux
• Some minor fixes after update pyt

Greetings,

Can someone please show me via coding example(s) how to write an input prompt that will read in a function key, F7 for example, validate that the key pressed is F7 and then process it all via cache.

Hey everyone!

I had looked around a bit and couldn't find a native way to log queue counts in Ensemble/HealthShare so I wrote a quick task and persistent class to do it. Hope this saves someone a bit of time. Let me know your thoughts! Thanks! 

Bobby Hanna

I have this fact table

And the cube which is pretty much 1:1.

I have build an MDX:

SELECT NON EMPTY [Measures].[Error] ON 0,NON EMPTY [CheckTime].[H1].[Minute].Members ON 1 FROM [CHECKCUBE]

Which produced this chart in DeepSeeWeb (there's obviously more data, but you get an idea):

However, I want to add a Marker - if it equals 1 then I need some indication on the chart, so the graph should look like this:

Is there a way to do that in DeepSee or DeepSeeWeb?

Hi guys!

What is the IRIS analog for Ensemble.INC?

Hello,

as you can see in title my problem is with file ccontrol. I want to install whole Ensemble with Manifest if on machine wouldn't be any, or if I somehow find out instance of Ensemble I want to only use settings from included Manifest. I read that I can use file ccontrol to solve this task.

So can someone said me, how to work with ccontrol, is there some variable or function which returns me somethig? I have read some parts of documentation about ccontrol, but nothing help me so much, so you can give me link to part in documentation, where is this desribed.

My easy solution coud be, th

Hi, I am new to the forum (not new to Mumps, M, DTM, MSM, M-Technology, Cache etc.) and I work as an Operations Director for a Cache software house, is there somewhere I/we can advertise for Cache developer related jobs/vacancies that we have? Apologies if this is not the right approach, but don't see anything obvious and when searching for jobs just see Intersystems announcements for various positions.

Hello All,

I have a outbound Http adapter.

How do i see the HTTP Request which is going out using Message Viewer or Trace? I want to see the entire message with the Headers and Body.

Thanks,

Jimmy Christian

Greetings,

We need to communicate with a vendor through web services in a way that those web services pull the queued messages from Ensemble instead of Ensemble pushing messages to a web service. 

Is this possible? if yes, will we loose the messages sessions, status, and tracking information?

Your help is much appreciated. 

-Basem

Hi Community!

We've introduced Direct Messages on InterSystems Community.

What's that? 

Direct message(DM) is a Developer Community feature which lets you to send a direct message to InterSystems community member you want. 

How to send it?

Open member's page, and click "Send Direct Message". Like here:

Hi Everyone!

I have two widgets with line vs time graphs.

I need to make a common filter by date for both, but these widgets use different date dimensions.

How I can to do this?

Hi,

I have  a program that displays the current running processes to the screen. I need to have a program execute that display program and capture the results to a file. The display program does pause at the bottom of each page waiting for an 'enter' to go to the next page.

Note( the display program will not successfully compile on the current system but it does work)

Also - very, very new to Mumps. 

Thanks,

Bob

From inside Business Service (OnProcessInput method specifically) I want to determine if Ensemble tries to shut down the job.

Is it possible? How?

Hi all,

I have a question about the Private Global Blocks when viewing a process's details.  This number is growing while my process runs - is this due to variables, process-private-globals, or both?

Thanks

Laura

Hi Community!

New video is already on InterSystems Developers YouTube Channel:

Leverage Your Users for UI Design

Hello community,

I am trying to parse the below HttpResponse in Cache. Cannot get the Iterator to work. Is there a single loop which can parse both or single messages and grab the error?

{
error:[
{ txt1:'error msg1'},

{ txt2:'error msg2'},
]
}
 

{
error: {
txt1:[
'error msg1',

'error msg2'
]
}
 

Thanks,

Jimmy Christian

The steps are as follows：

1. create global

 For I=1:1:200 Set ^ABC(I)=""
 For I=1:1:200 Set ^XYZ(I)=""
 For I=1:1:100 Kill ^ABC(I)

2. create ZJRNFILT

ZJRNFILT(jid,dir,glo,type,restmode,addr,time)    /*Filter*/
  Set restmode=1                                  /*Return 1 for restore*/
  If glo["^ABC",type="K" Set restmode=0           /*except if a kill on ^ABC*/
  Quit
  ;

3. restore

s RestOref=##class(Journal.Restore).%New()
s RestOref.FirstFile="20190717.007"
s RestOref.LastFile="20190717.007"
s RestOref.JournalLog="journal.log"
s RestOref.Filter="^ZJRNFILT"
s Status=RestOref.Run()

but the result do not hav