Hi,

I'm writing to an ODBC connection to a SQLserver database, and I seem to be sending the wrong data type to a date colum?

Hi Community!

Here is a digest of the Developer Community postings in January 2019.

Most viewed

VSCode extension for InterSystems ObjectScript update 319

Free IRIS Community Edition in AWS 265

InterSystems IRIS 2019.1 preview 203

Seeking field testers for an upcoming VSCode extension from George James Software 185

How to start development 173

Caché and Ensemble 2018.1.1 available 162

n00b questions 145

Save the Date — InterSystems Benelux Symposium 2019 145

IRIS Quarterly Container only releases and Studio 141

Collaboration with Git in Atelier 140

The One Query Performance Trick You NEED to Know? Tune Table! 132

Explore Text Data with InterSystems iKnow Entity Browser 126

Should you trust Codd or your objects? 112

SQL Performance Resources 106

Perforce Example of Shared Development with Atelier 105

Top 5 takeaways from 2018 95

On a csp page, when you return %Boolean from a cache script into a javascript script, you're getting a string, not a boolean 89

Iterate over dynamic object 52

Using PMML models in your Business Processes 51

Hi, please can you help me. I cant understand a thing on how to resolve this. I can run the query perfectly fine on SQL but when I run it in studio, it gives an error.

When I open a BPL, or DTL class in Atelier it attempts to open a graphical editor using Internet explorer.

Even though I have IE 11 installed it is somehow "stuck" in IE 7 emulation mode when invoked from Atelier (Eclipse).

So I get an error message, and cannot use the graphical editor. This has been true in the Marketplace Atelier 1.3 and also Beta.

I'm running Atelier IDE Beta 1.3.141, on Eclipse Javascript 2018-12-R.

Two questions:

Why cannot the editor work with IE7 anyway?

How can I get Atelier to invoke IE with the right options?

Hello,

I am trying to copy an xml file generated on an Apache server into the Jenkins workspace post-build. I was thinking to use a 'send files over ssh' post-build script, but have not done this before and do not know how to refer to the file location on Apache server vs on Jenkins.

For example, if I want to copy from Apache's location of: "classes/UnitTest/Results.xml" into Jenkin's workspace: "/ReportFiles/Results.xml",

How does the script differentiate between whether the location address refers to the Apache server or Jenkins workspace?

Today in docs I found this example using NULL:

 WRITE $LISTVALID($LB(NULL)),!

simplified

zzdump $LB(NULL)

and NULL can be case-insensitive:

zzdump $LB(null)

seems the same as just:

zzdump $LB()

But if null variable is defined then list would contain value from variable. Case sensitive in that situation.

Does anyone have any Idea what is this? Is NULL used anywhere besides as a list element?

The preview release of InterSystems HealthShare Health Connect 2019.1 is now available!

Kits and container images are available via WRC's preview download site.

Let Say I have
Class Carrier Extends %Persistent

Property Employee As Array of Class Employees

Class Employees Extends %SerialObject

Property Name As %String

Property Address As Array of Class AddressDetail

Class AddressDetail Extends %SerialObject

Property Street1 As %String

Property Street2 As %String

I can get value for Employee Name as Employee_Name.

But I want to Get Value of Address Street1 and Street2 of Class AddressDetail using SQL Query
How can I get that?

Hi All,

Actually I am trying to implement a RESt API where in I will get ZIPCODE as request and I need to call external API which will take ZIPCODE as input and give State and City in response.

But the problem is the request is in XML Format and also response is in XML format.

Example :

Hello, we have a couple of BPL processes. This works with a limited amount of messages but we run into issues when we process thousands of messages in a session. One BPL calls a Validation BPL process with async='False' and there is a response defined. The timeout is two seconds and that seems to be plenty of time for the validation process. I expected the calling process to wait for a response but that is not happening.

The preview release of InterSystems IRIS for Health 2019.1 is now available - try it out!

Kits and container images are available via WRC's preview download site.

Hi.

We have created an Ensemble production that receives HL7 information via TCP Adapters, but the requirement from the vendor is that we submit an ACK message with the MSH segment mist have a date and time populated with seconds.

We are utilising the standard class for the Service Adapter (EnsLib.HL7.Service.TCPService).

HL7 Version 2.5 no modifications currently.

The messages received via the service is correctly received in ddMMyyyyhhmmss but our ACK back is only ddMMyyyyhhmm.

I need to automate the handling of usernames passwords, serverNames etc for use in the sending and receiving of emails, logging into SFTP servers etc etc for use within COS code
To manage external passwords we could use LastPass or any other proprietary password loggers, but I need to be able to call them as part of the automation (COS code) and occasionally visually look them up to "remind" the staff of their passwords.

any suggestions as to the best class data constructs to handle this scenario. Should the whole table be encrypted, only the passwords etc.

I have an in-memory list of items and I want to check which items match my pattern string.

Pattern string is a comma-separated list of items and special symbols like '*' and maybe '?'.

There's something similar in $system.OBJ.Compile, it accepts patterns: "*.data.*,Sample.*" - and it would compile 'Sample' package and all 'data' packages.

For example:

set list=$lb("abc", "c", "aaa", "bbb")
set result = ..match(list, "a*,*b")
zw result
result=$lb("abc","aaa","bbb")