The documentation says that the MDX extended function %TIMERANGE returns a member.

However it seems like it produces a set of time members from the description ("a range of members").  Perhaps behind the scenes it is making a calculated member?  I am able to plug the return "value" from %TIMERANGE into the SUM function, which takes a set as an argument, and I get a correct answer.  So SUM((%TIMERANGE(...)) works, however COUNT(%TIMERANGE(...)) does not work and returns a cryptic error:

Should we be able to use %TIMERANGE as a set argument to any mdx function that takes a set argument?

In the MDX Query Tool I can't seem to get the NOW relative syntax to work correctly.  If I just use ".&[NOW]" it works, but something like ".&[NOW-1]" or ".&[NOW-1d]" (for dates extracted using DayMonthYear) it throws an error.

So this works:

But if I change .&[NOW] to .&[NOW-1] I get this cryptic error message.

Also, can you use member functions off of NOW?  For example can you do something like: [TransactionDateFilter].[H1].[Date].&[NOW].PREVMEMBER ???

Hello,

I am trying to find out if it is possible to invoke a Business Operation from a class method without using a Business Service.

I have the following code but was wondering if it can be done without using a Service.

s tService = ##class(Ens.Director).CreateBusinessService("Business Service Name",.service)
d service.SendRequestSync("targetBusinessOperation",request,.response)

I tried creating an instance of Ens.BusinessOperation and then call SendRequestSync but that didn't seem to work.

Any better ideas anyone? 

Thanks in advance.

Utsavi

We are looking to hire a DevOps engineer with expertise in Intersystems Technologies like Ensemble and/or IRIS as essential.

Main responsibility of the Role will be to implement Version Control and automated CI/CD pipeline for code build and deployment via tools and automation scripts for the current Intersystems platforms within the organisation.

If interested please email your resume to utsavi.gajjar@mater.org.au

I have an SQL text index defined like this

Index TextIndex On (Text) As %iFind.Index.Basic(IGNOREPUNCTUATION = 1, INDEXOPTION = 0, LANGUAGE = "en", LOWER = 1);

If I run a query like this:

SELECT
Text
FROM Post
WHERE %ID %FIND search_index("TextIndex",'ABC')

I get 20 results with posts containing the term ABC.

But each post can contain the term ABC several times.

Is there a way to get a total count of ABC term?

Is there a way to get a count of ABC term in each Post?

Hi Community,

The Mockable.io (https://www.mockable.io/) is an online service to deploy REST API or SOAP services in seconds. This is useful to test the consumption of an API or SOAP service in your production or objectscript class without having to implement a real service, including https option.

It's very simple procedure, see:

1. Access to https://www.mockable.io/;
2. Click Try Now button;
3. Can you import a swagger file or create an new service;
4. Will be created a domain to you group your mock APIs;
5. Click +REST MOCK;
6. Many options will be available to you, see the sample to return a "Hello

Under the previous python binding method (Cache) it was possible to pass in parameters, execute a class query,  and fetch the result sets. I have been unable to find a way to do this via PYODBC or the Native API (perhaps I am just missing something).

My work around is to create a SQLquery string and execute it through a cursor. I would much prefer to simply execute the debugged and more secure class queries that already exist and and have been precompiled. 

Any pointers would be greatly appreciated

Thanks,

Sinon

Hello,

We would like some advice

We have developed a REST Operation

The code is:

Class Operaciones.REST.miSCS.miSCS Extends EnsLib.REST.Operation
{

Parameter INVOCATION = "Queue";

/// 📤 Subir la imagen del usuario
Method SubirImagen(pRequest As Mensajes.Request.miSCS.SubirImagen, pResponse As Mensajes.Response.miSCS.SubirImagen) As %Library.Status
{
    set httpRequest = ##class(%Net.HttpRequest).%New()
    set tResponse = ##class(%Net.HttpResponse).%New()
    //set httpRequest.ContentType = "application/json"
    set httpRequest.ContentType = "multipart/form-data"

    
    set

Hi, I would like to use another framework in Studio, like React or Angular.

Is it possible?

Hello to all,

I'm trying to post some form data from a form I made in React to the backend of cache fetching a REST-service.
Receiving and processing a JSON-object is no problem but how can I handle Form Data?

The frontend is sending the form as form data and also includes one or more files.

What is the easiest way to process this data in my REST.Broker- class?

Best regards,

Simon

 We are using Native .NET API from IRISProviderCore21 package, inside .NET Core app, and having issue when trying to call function that takes instance of the class as parameter. The server is IRIS 2020.1.0.217.1

 In a nutshell, the code looks like this:

            // Create instance of the parameter class, proxy object

            var paramObject = iris.ClassMethodObject("MyParameterClass", "%New") as IRISObject;

           paramObject.Set("property", "value");

           var irisResult = iris.FunctionObject("MyFunction", "MyRoutine", paramObject);

  at last line, we are getting exception 
 
 'Unsupp

We have a custom FTP Service , and custom FTP adapter . Customization is just to find a duplicate file and for giving specific dynamic file spec pattern.
While running and polling for files, we are getting this error. Could you please help ? What's the issue and how to resolve it ?
ERROR <Ens>ErrFTPListFailed: FTP: Failed List for <FileName> (msg='Cache error in 'readResponse': <READ>zreadResponse+4^%Net.FtpSession.1',code=426)    

I searched to see if there was a previous question on this, but I didn't quite find anything.  Please link if you think this has been answered before (I have a feeling it has): what are the barriers to source control using Cache 2018 and Studio?  

I'm trying to figure out how to create a local repository but I can't access the folder structure in the USER namespace for my local instance. If I could, it would be as simple as navigating there in Git Bash and doing a 'git init' and then I can push changes to a remote repo for control.

Hi Developers,

We want to sum up the results of 2020 and meet 2021 together with you!

This was a very unusual, strange, dangerous, online year. A year full of politics, courage, diseases and deaths, new life-changing technologies, and innovations.    

This was a unique year for the Developer Community too – for the first time we had a 100% virtual global summit, we introduced series of online contests and we are doing regular online meetups – this is all new and all this is already a part of our life.

This year we introduced the Japanese and the Portuguese Communities in addition to the English and the Spanish ones, and we are waiting for the Chinese community to join!

We have a webserver which is using a port different to 443 for HTTPS communication. I can connect from the terminal session but not via the EnsLib.HTTP.OutboundAdapter. 

the example used in Terminal:

 
set httprequest=##class(%Net.HttpRequest).%New()
set httprequest.Server="appserver"
set httprequest.Port="4999"
set httprequest.Https=1
set httprequest.SSLConfiguration="app server"
do httprequest.SetHeader("Custom","cust")
set httprequest.ContentType="application/json"
do httprequest.EntityBody.CopyFrom(jsonfile)
do httprequest.Post("/FHIR/Bundle")

And this is my method using the

How to convert date and time into CCYYMMDDHHMMSS format??

For example the date and time format is 12/10/2019 21:41

Hi All,

In earlier cache version, I can see full data values in SQL management portal.

But IRIS restricted the view only to 100 chars.

"If the data in a field is longer than 100 characters, the first 100 characters of the data are displayed followed by an ellipsis (...) indicating additional data." - From Documentation.

Is there a way to change this behavior ? I would like to see all the values in the particular SQL field.

Thanks in advance,

Archunan K

Hi Community! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in December 2020.

Hi,

I am trying to delete a HL7 standard schema i created by mistake however when i select delete in Studio i get the following:

The xml is as below:

<?xml version="1.0"?><Category name="WYT.2.4" std="1">...

i then remove the std so it becomes:

<?xml version="1.0"?><Category name="WYT.2.4">...

Then i get the error:

I have also tried exporting and importing the schema with the std part removed but still get an error.

We have IRIS 2020.1.

Any ideas?

Thanks,

Graham

A simple question: View Global Data  page shows globals always in ascending subscript order. Very often I need to see latest page, is there any trick for this?

Update: I mean to see last subscripts in Management Portal, not using the code

I have a transformation that the incoming schema is an XML file and I will need to write multiple HL7 transactions.  Is there anyway to do this? 

Hi

We receive an HL7 order message into our integration engine containing OBX segments. I would like to create a PDF file and take the values from all instances of OBX-5 in the  message and write them to that PDF file, which I would then like to embed into an outgoing message to another system.

Any help appreciated.

Thanks

Frances

Hi Developers!

I'm pleased to announce that we made a New Year Eve release on Open Exchange!

What's inside?

• Expanded download stats;
• Enhanced landing page;
• Bug fix with downloads count.

See the details bellow.

Hey Developers,

The InterSystems Analytics Contest is over. Thank you all for participating in our exciting coding marathon!

And now it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Hi Community,

Learn how to use validation tools in InterSystems IRIS to assess and validate the behavior of a production:

⏯ Validating Your InterSystems Productions

There are couple of options to do this.

1. You can extend your class &JSON.Adaptor, it will do it for you with inbuilt logicaldtodisplay methods

2. Create another request class and do your transformations

3. Before calling the json convert to stream methods, transform the object's field with a ZDT.

---------------------------------------------------------------------------------------------------------------------------------------

I have an extremely simple example where there is a class with 3 properties

Class NV.Operations.FileOutbound.Data.P1 Extends (%Persistent, %Populate)
{
Property ClaimId A