Announcement Jamie Kantor · Nov 5, 2020

Hello, there!

Just a "last call" for anyone who wanted a free certification exam attempt at InterSystems Virtual Summit 2020. Today is the last day that we will accept requests. If you'd like a free attempt and haven't yet requested one, please do it today.

Thanks, and thanks for joining us at Virtual Summit 2020. 

Friendly regards, 

Jamie Kantor, Certification Manager 

1
0 258
Discussion Benjamin De Boe · Nov 9, 2020

Hi,

InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community.

5
0 402
Question Daniel Aguilar · Nov 4, 2020

Good Morning,

I have this question for a long time. When I make an insert by SQL from an external application in the fields of type %String, if they are empty, it writes the character $c(0) in the global.

Is there a way so that if an Insert is received in a field of type% String with null value instead of the $ c (0) it leaves it empty?:

I have the class defined like this:

Class User.MiClase Extends (% Persistent,% XML.Adaptor)

and the property like this:

Property myProperty As% String;

I have tried creating a trigger or setting default values but it doesn't work.

7
0 1257
Discussion Dmitry Maslennikov · Nov 9, 2020

Let's imagine you have to implement a method with a definition

/// Set value to %session.Data
ClassMethod setValue(params...) As %Status
{
}

How it should work

do ..setValue("key1", "val")

is equal to

set %session.Data("key1") = "val"

and 

do ..setValue("key1", "key2", "key3", "key4", "val")

is equal to 

set %session.Data("key1", "key2", "key3", "key4") = "val"

so, quite simple, any amount of arguments, while the latest one is a value, and any previous is an index, should accept at least 2 arguments.

How would you implement this method?

15
0 353
Question Eduardo Raupp · Nov 9, 2020

Hello there,

I have a simple question related to the default locale after healthshare installation.

Will it be the default one already selected in the O.S.? 

I mean, because locally I have it in english, but I have seen it in spanish (by default) in some other machines and the only reason I could understand it is because of the O.S. default language.

Is my assumption right?

Regards,

1
0 242
Question Brian Schoen · Nov 6, 2020

I am trying to match on config items that have the same Vendor name in them for custom alerting.

Example:

FromVendornameSiteADT

ToVendornameORM

Where Vendorname could be several systems that have multiple interfaces.

How can I find all config items (interface names) with the same Vendor name, without explicitly naming them?

I was trying to use $Piece to segment out the CamelCase pieces (as the name I want is always the 2nd Capitalized section), but could not find a way to integrate match regex logic (e.g. [A-Z]) inside $Piece or other String extract functions.

9
0 445
Announcement Jamie Kantor · Nov 6, 2020

Hello, everyone, 

Now that Virtual Summit 2020 is over, we'd like to remind everyone that we would still love to hear your input on Certification topics via a very brief survey - less than 8 minutes. You can even indicate if you would like to be a Subject Matter Expert for us in the future and what kinds of incentives you'd like to receive to do so. 

Please let us know your thoughts: 

https://www.surveymonkey.com/r/2ZVHNPS

Thanks, 

Jamie Kantor, Certification Manager

0
0 155
Question Kranthi kiran · Nov 6, 2020

Hi Cache team, I am in the need of listing all the user defined schemas that are present my Cache db and also the user defined tables and views and Columns of those tables and views through Queries. So that I can write some JDBC code to run the queries and fetch the above metadata. Any help is appreciated.

Thanks in Advance,

Kranthi kiran.

2
0 2946
Question Julian Matthews · Nov 5, 2020

Hey everyone.

I have noticed that my backup mirror is warning that the MirrorDatabaseLatencyTime is having a bad time (time in ms is 3000, and warnvalue is 3000). While I look into what may be causing this latency between the two servers, I was considering if reducing the size of the journal files would improve this value in any way.

My assumption is that reducing the file size would mean that the frequency of the journal files being created would be increased, but the reduced size would mean that the transfer and application of each file would be reduced.

Has anyone had experience in this area?

2
0 906
Question neel Je · Nov 4, 2020

I am trying to use IRIS Native API in .NET code I see following code snippet here https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

  IRISReference valueRef = new IRISReference(""); // set inital value to null string
  iris.ClassMethodString("%SomeClass","SomeMethod",valueRef);
  String myString = valueRef.value;               // get the method result

But IRISReference is not available as a type.

 What reference (dlls) do I need to add for that? I have InterSystems.Data.IRISClient.dll , what else do I need? what am I missing here?

3
0 304
Question alex chang · Nov 4, 2020

Hi

My Ensemble platform worked well before. 

Since yesterday , I found out lot of slow request ,I opened trace for one message. 

as above shown. 

It take about 8s from HisEmrRouter to ADTRoutingRule.

 In my opinion, HisEmrRouter And ADTRoutingRule is Simple Rule,  should't do IO operation. should be pure compute. 

Why does it take so long to process the routing?

What Can I do to avoid it spend too much time to routing?

Tks

10
1 555
Question Nael Nasereldeen · Apr 16, 2018

Hi,

I need to read a UTF8 encoded text file and translate the content to 8-bit.

Using %File class and $ZCVT(TXT,"I","UTF8") works , but I see that if the content is larger than max string  (32000) and we cut the content

To max string chunks, we can get a <translate> error if we cut it in the "wrong" point..

Is there a better way to do this task?

My code looks like this:

    S file=##class(%File).%New(.LocalFileName)
    D file.Open("R")
    While 'file.
10
0 2257
Question Yuri Marx · Nov 3, 2020

I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:

Class dc.Test.TestService Extends Ens.BusinessService
{

 

Parameter ADAPTER = "EnsLib.HTTP.InboundAdapter";

 

Method OnProcessInput(pInput As %GlobalBinaryStreampOutput As %RegisteredObjectAs %Status
{
    Set file=##class(%Stream.FileBinary).%New()
    Set file.Filename="/tmp/automl.png"
    Do file.
3
2 353
Announcement Anastasia Dyubaylo · Oct 7, 2020

Free certification exam attempt for all attendees of Virtual Summit 2020!

InterSystems is proud to offer free InterSystems Certification exam attempts to all attendees of InterSystems Virtual Summit 2020. The one free exam attempt will be made available to all registered attendees and can be used at any time until December 31, 2020.

 

This is our standard online exam service with online proctoring that is normally priced at $150 per attempt. 

3
1 574
Announcement Janine Perkins · Nov 4, 2020

Get your hands on our technology with On-Demand Experience Labs available now through November 6th. Each lab is paired with an office hour session scheduled for this week. Learn more about how you can get hands-on with our technology. 

Join the office hours to get answers your questions about the labs, talk about how the technology fits into your environment, and discuss implementation. Sign up for the Office Hours/On-Demand Experience Labs today. The labs have gotten great reviews so far!

0
0 194