Developer Community for InterSystems IRIS, Caché, Ensemble, HealthShare, InterSystems Business Intelligence and Text Analytics
Most votesArticlesAnnouncementsQuestionsNo answerNo accepted answerAll

We at George James Software are pleased to announce that our acclaimed code debugger and editor Serenji is now available as a Visual Studio Code extension.

As well as supporting the latest InterSystems IRIS platform Serenji also works with earlier platforms, including versions lacking the server-side Atelier API support required by other VS Code extensions.

Serenji connects you directly to the code in your namespaces, resulting in an experience more familiar to existing Studio users. No need to export and import classes and routines.

We believe Serenji is the first extension to bring VS Code's powerful debugging features to ObjectScript developers.

Continue Reading
John Murray's picture
Post by John Murray 1 April 2019
Last comment 29 min 40 sec ago
+ 4   2 6
11

comments
388

views

+ 4

rating

Hi All,

I have two tables LB_TestSet and LB_Transfer

LB_Transfer has a list if TestSet row IDs, so i am doing the following join

SELECT 
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSet 
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' AND  '2019-05-10'

 

Without the date filter the query returns data, but if i add the date filter no data is returned

I also tried using %INTERNAL, %EXTERNAL TO_DATE('2009-01-01','YYYY-MM-DD')

if i filter by RowID for example the filters work.(this is to make sure that the where clause is working)

Only the date filter fails.

Any Suggestions

Continue Reading
Rizmaan Marikar's picture
Post by Rizmaan Marikar 6 days ago
Last answer 1 hour 58 min ago
0   0 3
2

answers
0

comments

85

views

0

rating

Hi Community!

How do you create SSL Configuration for InterSystems IRIS programmatically? E.g. for installation or deployment case?

E.g. if I need to create a very simple "default" SSL client configuration to let HTPPS Get requests to an arbitrary server?

Continue Reading
Evgeny Shvarov's picture
Post by Evgeny Shvarov 5 May 2019
Last answer 16 hours 49 min ago Last comment 11 hours 9 min ago
0   0 4
3

answers
2

comments
98

views

0

rating

Hi,

recentley we started to work with Atelier & VSTS in our organization .

we are looking for a way to use the VSTS as Our Version/Source control system .

I have read the article about "Continuous Delivery of your InterSystems solution using GitLab" & now trying to find a way to use a similar metodology with the VSTS that we have in our organization.

It Apeares that it is possible to Create a Git Repository in the VSTS but i'm not sure how are we to use it from the atelier.

The main questions are

Continue Reading
Stas Rabkin's picture
Post by Stas Rabkin 1 days ago
Last answer 14 hours 48 min ago
0   0 3
1

answers
0

comments

72

views

0

rating

We have a business service that extends Ens.BusinessService and uses  EnsLib.File.InboundAdapter.

This service polls for json files in a folder.

Method signature is like this:

Method OnProcessInput(pInput As %FileCharacterStream, pOutput As %RegisteredObject) As %Status

And inside that method it tries to read the content like this:

Continue Reading
Jack Smith's picture
Post by Jack Smith 1 days ago
Last answer 1 days ago Last comment 15 hours 43 min ago
0   0 3
1

answers
6

comments
87

views

0

rating

Hi all,

I wonder how to sync my server code to my local code using Visual Studio Code.

Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.

I thing i shouls opening the ObjectScript: Explorer and select the code directaly, and right click -> Import and compile current file (Ctrl + F7)

If I use this command, the ouptut window shows

Continue Reading
Francisco López's picture
Post by Francisco López 19 hours 8 min ago
Last answer 18 hours 7 min ago
0   0 2
2

answers
0

comments

24

views

0

rating

Hi everyone,

Im new  in cache, i came from Java and im missing some features that i couldn't find in the documentation,  I hope you can help me with this questions.

Just a brief introducction: 

- Im in a project with old cache version, so saddly i can't use Eclipse + Atelier, so im using Studio.

- Currently im in a project with persistent classes, we want to turn apart the globals and focus on tables. 

The questions:

Is there any way to make something like hibernate for cache %Persistent classes? For example, if i want to get all the records for a table in Java+Hibernate+Criteria i'll do something like this:

myListOfObjects = myPersistentClass.list(); // Equivalent to SELECT *

In cache i have to  create a %SQL.Statement, put the query inside and get the recordSet, iterate it and then get a list of %Persistent objects, for every object i want to use it.

Continue Reading
WHAT THE's picture
Post by WHAT THE 19 hours 52 min ago
0   0 1
0

answers

0

comments

30

views

0

rating

Hi everybody,

after importing an XML schema from xsd into Ensemble I´d like to add it to my Studio-Project but can´t find the imported schema in the namespace view. For example when working with custom hl7 schema, I could easyly add it to my project under namespace view schemaname.hl7. Is this also possible with xml schema? If so where can I find it on an component level?

kind regards,

sebastian

Continue Reading
Sebastian Thiele's picture
Post by Sebastian Thiele 3 days ago
Last answer 3 days ago Last comment 1 days ago
+ 1   1 1
1

answers
1

comments
49

views

+ 1

rating

Hello,

Need some technique to solve an issue about zen page table.

- "xyz" table exists in all my namespaces.

I have a simple Zen page  in "USER 1" namespace. It has a tablepane which pulls data from "xyz" table.

OnLoad of the page i want the  zenpage to pull the data from "USER 2" namespace with same "xyz" table name.

 

Zenpage has to be in  "USER 1" namespace

 

I tried to use the server side callback handler %OnAfterCreatePage()  and do a ZNSPACE "USER 2" but still it is not doing the job of pulling data from another namespace.

 

Any suggestions will be appreciated.

Thanks,

Jimmy Christian.

Continue Reading
Jimmy Christian's picture
Post by Jimmy Christian 6 days ago
Last answer 3 days ago Last comment 3 days ago
0   1 3
2

answers
8

comments
68

views

0

rating

Hi all. Today we are going to upload a ML model into IRIS Manager and test it.

Note: I have done the following on Ubuntu 18.04, Apache Zeppelin 0.8.0, Python 3.6.5.

Introduction

These days many available different tools for Data Mining enable you to develop predictive models and analyze the data you have with unprecedented ease. InterSystems IRIS Data Platform provide a stable foundation for your big data and fast data applications, providing interoperability with modern DataMining tools.Â

Continue Reading
Niyaz Khafizov's picture
Post by Niyaz Khafizov 27 July 2018
Last comment 3 days ago
+ 5   1 3
2

comments
414

views

+ 5

rating

Hi all,

I have a class that I want to serialize to JSon. So I'm using the object %ZEN.Auxiliary.jsonProvider)

set myClass = ##class(myapp.myclass).%New()

set myClass.property1 ="value 1"

set myClass.property2 = "value 2"

set myClass.property3 = "value 3"

do ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tStream,myClass ,,,1,"ed")

write tStream.Read()

By definition of myclass, all properties are serialized, that's fine. But I want not serialize the property3. I think is using a XML attribute in the property, or something about. But I didn't find anything about.

 

Anyone can help me?

 

Continue Reading
Francisco López's picture
Post by Francisco López 4 days ago
Last answer 3 days ago Last comment 3 days ago
0   0 2
2

answers
2

comments
67

views

0

rating

The last time that I created a playground for experimenting with machine learning using Apache Spark and an InterSystems data platform,  see Machine Learning with Spark and Caché, I installed and configured everything directly on my laptop: Caché, Python, Apache Spark, Java, some Hadoop libraries, to name a few. It required some effort, but eventually it worked. Paradise. But, I worried. Would I ever be able to reproduce all those steps? Maybe. Would it be possible for a random Windows or Java update to wreck the whole thing in an instant? Almost certainly.

Continue Reading
David.E Nelson's picture
Post by David.E Nelson 26 April 2019
Last comment 3 days ago
+ 8   4 5
3

comments
136

views

+ 8

rating

here is my trigger:

CREATE TRIGGER "SQLUser".SYM_ON_U_FOR_SYM_CHNNL_125123 AFTER 
UPDATE
   ON "SQLUser"."sym_channel" REFERENCING OLD ROW AS OLD NEW ROW AS NEW FOR EACH ROW 
   DECLARE @var_row_data VARCHAR(16336);
WHEN
   (
      1 = 1 
      and 1 = 1
   )
   -- I will use OLD/NEW alias here set @var_row_data = ''; LANGUAGE sql insert into mytable (id, data) values(1, @var_row_data);

here is error message

Continue Reading
w s's picture
Post by w s 1 May 2019
Last answer 4 days ago
0   0 2
1

answers
0

comments

41

views

0

rating

I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show the percentage  (100*number of rows for that member/all rows) .It should not matter what dimension is being viewed. Ex

There are a total of 100 rows in the source class.

For dimension columnA which returns value in  ColumnA column in source class, 10 rows contain "A" the rest contain "null". When viewed on the analyzer, with columnA as a row and PercentOfAll as a measure, the cells values should be:

"A"       10%

"null"  90%

 I can achieve this using an expression that would be specific to columnA dimension Ex columnA. CurrentMember/columnA.[All columnA].%All

But I do not want to have to define meausure for each and every dimension. I just want to have a measure that will be used for all dimensions. ExÂ

Continue Reading
Stella Tickler's picture
Post by Stella Tickler 5 days ago
Last answer 5 days ago
+ 1   0 1
1

answers
0

comments

31

views

+ 1

rating

I am building a cube based on a source class, which I  will call,  Family.Dad 

In the class definition for Family.Dad, there is a relationship, offspring  As Child  [ Cardinality = children, Inverse =  father]

In the class definition for Child, there is a relationship called father As Dad  [ Cardinality = parent, Inverse =  offspring]

In the actual data, a dad can have many children, but a child can only have 1 dad.

Using DeepSee, I am trying to analyze to answer questions such as how many dads have children called Joseph ( Ex dad.offspring.GetAt(x).Name) etc .Â

Continue Reading
Stella Tickler's picture
Post by Stella Tickler 13 April 2019
Last answer 14 April 2019 Last comment 5 days ago
0   0 1
1

answers
5

comments
62

views

0

rating

Is there a way to have a context property be available across 2 or 3 different business processes? For example if I am setting a value in a context property within one business process and want to use the same context property in a second business process, is this possible? Is this something that can be done with the "Context Superclass"?

Continue Reading
Julie Marulappa's picture
Post by Julie Marulappa 6 days ago
Last answer 5 days ago Last comment 5 days ago
0   0 4
2

answers
3

comments
68

views

0

rating

Hey Community!

The latest webinar, recorded by InterSystems Sales Engineers @Sergey Lukyanchikov and @Eduard Lebedyuk, is already on DC YouTube Channel! Please welcome:

"Machine Learning Toolkit (Python, ObjectScript, Interoperability, Analytics) for InterSystems IRIS" 

 

Continue Reading
Anastasia Dyubaylo's picture
Post by Anastasia Dyubaylo 7 days ago
Last comment 5 days ago
0   0 2
2

comments
92

views

0

rating

Hello guys,

I have been playing around with the deployment tools from Ensemble (mostly based on this article https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...) , but so far the one thing I still couldn't figure out is how to release the fact that I deleted files/components from my source production and that will get reflected in my target production.

Basically the target production has got A, B, C and D. Source has got A and B, because C and D aren't needed anymore. How do I generate a deployment XML with these information and once I release in the target production, Healthshare will get rid of C and D?

I couldn't find any info in the above documentation, so any tips would be more than welcome.

I have come across a few bugs in the deployment tool in the past and I hope this isn't another one or a lack of the functionality I need

Continue Reading
Murillo Braga's picture
Post by Murillo Braga 6 days ago
Last answer 5 days ago
0   0 2
1

answers
0

comments

50

views

0

rating

Hi!

 

When I try to send a hl7 message via TCP / IP with SSL certificate, I get the following error:

ERROR <Ens>ErrTCPTerminatedReadTimeoutExpired: Tiempo de espera de lectura TCP (600) superado mientras se esperaba el terminador SegTerminatorAscii=13, on |TCP|35000|6596, datos recibidos =''

 

 

I have increased the response time to 10 minutes but still, I do not get to receive the message.

As I said in the remote system the process of negotiating the SSL certificate takes about 10 minutes and after that the message appears. I think it's too long. Is there any way to see more traces of the SSL certificate negotiation process in Ensemble?

 

Framing = MLLP

Continue Reading
PILAR GUERRERO's picture
Post by PILAR GUERRERO 3 May 2019
Last comment 5 days ago
0   0 2
0

answers

2

comments
30

views

0

rating

In our table, we have a column cities,  which has a filter which displays the cities of a state depending on the state

For simplicity let's assume we have a page

Property State As %String =  "CA"

Our filter should run this query to show all cities of state ca

"SELECT Name FROM City WHERE State= "_%page.State

<tablePane>

Continue Reading
Neerav Verma's picture
Post by Neerav Verma 10 days ago
Last answer 7 days ago Last comment 5 days ago
0   0 3
2

answers
4

comments
68

views

0

rating

When I try to open a DTL in the tabbed editor I always get this error:

You are using Internet Explorer 7. This version is obsolete and is not compatible with diagram editors. Please update Internet Explorer to a recent version.

My actual Internet Explorer is version 11.

I'm running Eclipse Photon.

  Atelier IDE    1.3.141    com.intersystems.atelier.feature.group    InterSystems Corporation

The same error occurred with Atelier 1.2 on Eclipse Oxygen. I've never been able to get this to work.

It seems hard to believe that no one has solved this problem, but I never found any solution at Developer Community. 

 

Continue Reading
Bernard Badger's picture
Post by Bernard Badger 13 days ago
Last answer 6 days ago Last comment 12 days ago
+ 2   0 3
1

answers
1

comments
75

views

+ 2

rating