Let's say I have this property:

Property FavoriteColors As List Of %String;

I heed to convert it to JSON using SQL or at least without object access (so direct global access).

What's the fastest way to do that?

I thought about JSON_ARRAY and JSON_ARRAYAGG sql functions but they don't do that.

Friends , can anyone help in how to kill instances of a business process? We have searched the documentation and looked in the Production, We am not seeing how to perform this task.

I've mapped multiple tables (UNION on mapped SQL classes) into a view, using CREATE VIEW.

Through ODBC, in Entity Framework, I am querying against that view and offering paging. The paging is implemented using IQueryable.Skip and IQueryable.Take.

Skip seems to have unexpected results, I believe due to incorrect SQL generated by the Entity Framework provider, though perhaps I've done something incorrectly. The generated SQL looks similar to this (with some bits replaced or altered for security reasons), the basic structure is unaltered.

I'm writing a SOAP client in Ensemble (2017.2.2) that is required to pass empty elements to the SOAP server in the form <xsi:type="ns:ResponsibleUser"/> where ResponsibleUser is a class that itself has no properties. I initially thought I'd found the answer with the XMLIGNORENULL parameter of XML enabled classes but this didn't make any difference for SOAP requests, only working when I wrote the XML to a file.

Hi Community!

Here is the digest of the most popular videos on InterSystems Data Platforms we published in 2018 on Developer Community YouTube Channel!

And!

Please check the most popular videos by Watch Time. See the details below.

I would like to know if there is a built in function that checks a value in the rule editor to see if it is numeric.

Hi all,

Does anyone knows if there is a limit per second adding messages to an Ensemble queue? I have a Business Service working and sending async requests to a Business Process, but I can't reach no more than 60-70 messages queued per second.

I've done several tests and same behavior seems to happen with all our productions. So I was wondering if there is a parameter anywhere to maximize the number of requests that can be send to a queue per second.

Greetings Developer Community member!

Here is an annual summary of the best questions about InterSystems Data Platforms 2018!

Here are 3 top popular questions, criteria is the number of views:

First place: Send JSON Via HTTP request, by rochdi badis 2384 views

Second place: How to save a PNG image in Cache, from a base64 data string, by Nael Nasereldeen 1010

Third place: Angular 4 (2-5), Cache Authentication, Cache2017.1, REST, by Anne Kantola 896

I connected from InterSystems Cache to devices connected via RS232 (commonly known as COM-port).

Can the same be done with devices connected via RS422/RS485 interfaces?

There are situations where we want to provide immediate feed back to inbound Web Service that a particular business operation is not running (status <> "running"). We don't even want to queue up the message. We just want the webservice to respond with an error stating the business operation is down.

I am just curious if someone has used this service to send Alert emails through AWS / Ensemble

I have verified 2 email ids - One to send. One to receive

Have also configured an access key for the email smtp server and added the credential to ensemble

but I get this error

ERROR #6033: Error response to SMTP MAIL FROM: 530 Authentication required.

email-smtp.us-east-1.amazonaws.com

25

So my first opinion is the authentication is not happening via the credentials settings. It needs to be passed in a different way

Hi everybody,

I am looking for a way to detimerine if a certain namespace is ensemble enabled. I´ve seen such a solution somewhere in the past but can´t find it anymore. Is there a simplistic api around for that?

My second question is in context of log some information to the console log file with a certain error level. Also, I´ve seen this in the past and can´t find it agian. I guess there was some kind of simple api to use for this.

Thank you for your help.

best regards,

sebastian

We are currently using Ensemble on AIX. We are on 2015.2.2. If I install Field Test on a windows desktop, is it possible that I can import the Cache.dat from my AIX server, so I can do some Proof of Concept development?

Thanks

Scott

Hello,

I have some beginner questions as I am working through the InterSystems Cache learning path:

- Where I work, we us Cache, but we often learning about and train on MUMPS. No one really talks about or mentions MUMPS here, but my understanding is that ObjectScript is basically MUMPS plus whatever new things InterSystems put on top of it. Is that a fair assessment?