#ObjectScript

Post a job Follow
14 Followers · 1.6K Posts

InterSystems ObjectScript is a scripting language to operate with data using any data model of InterSystems Data Platform (Objects, Relational, Key-Value, Document, Globals) and to develop business logic for serverside applications on InterSystems Data Platform.

Documentation.

Post a job Follow
Question Jo Ellen Laansma · May 13, 2020

SQL Server - How to write column with empty string instead of NULL

I have a class that writes to an external SQL Server database.  When the field is empty, it does not write the column and the column has the value NULL.  In some cases, I want the column to be the value of the empty string instead of NULL.

Class myRequestClass Extends Ens.Request
{

    Property MessageType As %String

}

The message that is passed to this class shows:

    <MessageType></MessageType>

Which writes the field as NULL with:

    tSQL = "insert into myTable (MessageType) values (?)"

    set tSC = ..Adapter.ExecuteUpdate(.tNumberOfRowsUpdated,tSQL,myRequestClass

#Caché #HealthShare #JDBC #ObjectScript #SQL
5
0 16808
Question Arto Alatalo · Apr 15, 2020

%CacheSQLStorage: data location as variable

If two globals have same structure, how to reuse one CacheSQLStorage-based class to read both locations?

Thanks!

Update:

Let's say we have two globals:

^a(1)="dataa1"
^a(2)="dataa2"

and

^b(1)="datab1"
^b(2)="datab2"

i.e. the structure difference is global name only.

I would like to have two classes TableA and TableB both are inherited from TableAB, and TableAB taking global name as a parameter.

#Caché #Mapping #ObjectScript
14
0 786
Question Yone Moreno · May 11, 2020

Could Ensemble generate a CADES sign?

Hello,

 

We would like to know if Ensemble could generate a CADES sign from a string and a certificate.

 

We have read:

https://cedocs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GXM…

 

So we have seen that we could create a class, to sign a document, and store the sign inside that new class. We have also seen that there are some different algorithms to choose from, like sha1.

 

In addition we have also consulted the CADES sign definition:

https://tools.ietf.org/html/rfc5126

 

The use case is to avoid being dependant of an external web service, and be able to generate it.

#Caché #ObjectScript
1
0 228
Question Paul Beckett · Jun 16, 2016

Applying string functions ($replace, $zconvert etc) to a %Library.GlobalCharacterStream

Hi,

I have a bit of code that does a find and replace on a "template" and inserts additional content. For example it replaces the @DATA@ with an html table:

<html>

   <body>

      <div id="data">@DATA@</div>

   </body>

</html>

Currently doing this with the $replace function:

Set text=$replace(text, "@DATA@", data)

The problem is the "data" is now too big for a %String (yes even with large strings) so will switch to use a stream instead. 

Is there an equivalent to $replace that works on a stream? If not, how would I best implement this sort of find/replace functionality in cache object script?

#Caché #ObjectScript
5
0 1850
Question Russell Carpio · May 7, 2020

%Net.SSH.Session

We are getting CoClass not available [80040111] when using %Net.SSH.Session.  Does anyone know if there is a security setting that would disable this object?

Any help would be greatly appreciated.

#Caché #ObjectScript
3
0 378
Question Stuart Byrne · Mar 10, 2020

Reducing the end variable in a FOR loop once executed

Dear All,

I'm looping through a list with characters (Parenthesis, square brackets etc) and I wish to remove these from the list.

The for loop and IF logic are effectively removing these items from a list.

However the variable I use for the maximum number of loops carries on beyond the number of items of the list after removal.

In the output value for these I get the integer of the for loop instead of a  null for the empty list fields.

I can see in the documentation that the end variable is not editable once the loop is started.

#Caché #ObjectScript
12
0 830
Article Evgeny Shvarov · May 11, 2016 1m read

The simplest snippet to read from file in InterSystems IRIS

Hi!

I believe the simplest is (to work with csv delimited by ";"):


set file = ##class(%File).%New( "data.csv" )
    set sc = file.Open( "R" ) 
    if $$$ISERR(sc) quit    ; or do smth

    while 'file.AtEnd {
        set str=file.ReadLine() 
        for i=1:1:$length( str, ";" ) {
            set id=$piece( str, ";" ,i ) 
            write !, id  // or do smth
        }
    }
    do file.Close()

Possible options:

different variants of error handling with sc code.

Embrace while loop into try/catch block.

And what's yours?

#Caché #InterSystems IRIS #Code Snippet #CSV #ObjectScript
16
0 7289
InterSystems Official Raj Singh · Apr 12, 2020

InterSystems joins the open source ObjectScript for VS Code effort

I’m excited to announce that InterSystems will be joining the open source community for InterSystems ObjectScript extension to Visual Studio Code. Early this year I posted that we were on a journey to redefine the future of our IDE strategy, and what came out of that is Visual Studio Code is the IDE that can support that future.

#Developer Community Official #InterSystems Official #.NET #Development Environment #Java #Node.js #ObjectScript #Studio #VSCode
3
6 1891
Question alex chang · Apr 20, 2020

How to customize message view?

Due to bussiness requirements.I want to add some bussiness field on intersystem message view ui .

eg:

1. add new action page to display bussiness detail

2. add new function to do more  Fine-grained things.

3. add new database field in message table.

finally, I hope get more detail of messae view due to customize it.

Tks.

#Ensemble #ObjectScript
2
0 257
Announcement Dmitry Maslennikov · Mar 4, 2019

CachéQuality for VSCode now available

Hope most of you already familiar with project CachéQuality from @Daniel.Tamajon. For those who don’t know about it, it is a static syntax analyzer for your code written for InterSystems products. It may help you to find and solve many different types of issues in your code, and even possible bugs before clients will find it in production. So, with help of CachéQuality you will be able to deliver a better product. You can find the complete list of rules used to check ObjectScript code here.

It was already available in Studio. And now it is also available in VSCode.

#Open Exchange #Development Environment #ObjectScript #VSCode
41
1 2313
Article Jose-Tomas Salvador · Dec 20, 2018 2m read

Just for Fun. John Conway's Game of Life

Some weeks ago, I was reading a book by Stephen Hawking and Leonard Mlodinow, The Grand Design. At a certain point, trying to define why do we exist? , why do we use the models we use in physics?, ...those kind of things you know... they pointed at the Game of Life example invented by the mathematician John Coward in 1970... Basically he wanted to show that a system with really basic fundamental laws (Physics) could evolve and "live" to become a more complex system (Chemistry) in which "something" (humans) could work out its own model and complex rules to explain its reality… the rules for this deterministic model that he exposed were so basic that I thought it could be funny to implement them in ObjectScript when I had some spare time... there are others implementations in JavaScript and other languages... but not in ObjectScript... and that had to be corrected!!… so here you are!

#Caché #InterSystems IRIS #ObjectScript #Terminal
Open Exchange
10
2 977
Announcement Anastasia Dyubaylo · Apr 6, 2020

Webinar: Introduction to VSCode-ObjectScript

Hi Community!

We are glad to invite every developer who uses ObjectSript and VSCode plugin to the upcoming "Introduction to VSCode-ObjectScript" webinar on April 14, 2020 at 11:00 EDT. 

Speaker: @Dmitry Maslennikov, InterSystems Developers Advocate, CTO at CaretDev.

You will learn how convenient the development process can be already right now and what we are going to do next to make it even better.

Please check the agenda below.

#InterSystems IRIS #Events #ObjectScript #VSCode #Webinar
11
1 1246
Question Jordan Everett · Apr 15, 2020

Declaring a variable in a class that a routine will recognize

Hello all,

I'm new to the Intersystems development world and I've been trying to figure out how to make a REST API using ObjectScript. I found a tutorial that I've been following that has been great and I'm trying to translate what I've learned to live data.

My question is "Is there a way I can set a variable inside of a class so when I call a routine that variable will be recognized?" I'm capable of setting the variable in a terminal session and then calling the routine and everything will be work great! I will get the data I want returned.

#InterSystems IRIS #API #ObjectScript #REST API
2
0 376
Question Michael Derr · Apr 6, 2020

Confirming file size after SFTP PutStream

Hello!

 

This may seem a bit strange, but I'd like to make a business operation which would put a file via SFTP and then confirm that the filesize on the remote server is consistent with expectations.  I am thinking either of a custom copy or extension of the adapter (right now it is using EnsLib.FTP.OutboundAdapter) that overwrites method PutStream, or a version of the FTP.PassThroughOperation with a customized method OnMessage that does the check after the PutStream completes OK-- but I am uncertain of how exactly to modify either method to make the check.

#Ensemble #Business Operation #FTP #ObjectScript
7
0 1233
Question aqwsxcde · Apr 4, 2020

How to use subclasses (type cast)

Hello community,

I recently started to work with Ensemble. I defined a subclass of EnsLib.HL7.Message.  In my production I receive HL7v2 messages and transport them using the Message Router to a business operation. The operation class has an OnMessage method with parameter

pObject As MySubclassOfEnsLibHL7Message.

I expected that specifying the parameter type, on receiving the message an implicit type cast would be performed. However, $CLASSNAME reveals that my messages are still of type EnsLib.HL7.Message. How can I convert my messages in ObjectScript (without DTLs or something the like)?

#Ensemble #Object Data Model #ObjectScript
7
0 923
Article Robert Cemper · Apr 4, 2020 3m read

Websocket Client IRIS internal

IRIS 2010.1 brought us a new feature: %Net.WebSocket.Client

As a continuation of my series of WS Clients I just couldn't resist to try it.
Well, this is the result and it was rather simple in the end.

  • After I succeeded in my personal fight against Windows Firewall ;-)

You basically need to prepare 3 classes:

  • Credentials for User, PW, SSL

  • an Event Listener

  • the Client (Could be a .MAC routine as well)

The example uses the WSS.EchoServer (a derivate from former SAMPLES in Caché).
The default assumption is to have Client and Server on the same system & namespace.

#InterSystems IRIS #ObjectScript
Open Exchange
0
0 811
Announcement Evgeny Shvarov · Mar 22, 2020

Voting in InterSystems IRIS Online Programming Contest!

Hi Community!

The registration phase for InterSystems Online Programming Contest ends today and we will start the voting week!

Now we have 20 applications - so you have a set of applications to choose from!

How to vote?

This is easy: you will have one vote, and your vote goes either in Experts nomination or in Community nomination.

#InterSystems IRIS #Open Exchange #Contest #Docker #ObjectScript
7
1 495
Article Gevorg Arutiunian · Aug 31, 2018 1m read

Change all passwords in a system

This code snippet changes all passwords in a system to a specified string. The two literal strings at the beginning of the snippet can be adjusted to edit the system or password string. The class method "test" runs the code:


Class eduardlebedyuk.changePasswords Extends %RegisteredObject
{
	ClassMethod test()
	{
        set ns = $namespace
	    zn "%SYS"
	    set NewPass = "NewPassString"
	    set rs=##Class(%ResultSet).%New("Security.Users:List")
	    set st = rs.Execute()
	    while rs.Next() { set st=$SYSTEM.Security.ChangePassword(rs.
#Caché #Code Snippet #InterSystems IRIS #ObjectScript #Caché
7
0 887
Discussion Maks Atygaev · Mar 28, 2020

Why Declarative ObjectScript is not a framework/tool but a matter message

DISCLAIMER: I am not an InterSystems engineer or a professional ObjectScript developer.

I just want to share my opinion about some things I am really miss in ObjectScript.

I really appreciate everyone who support my project (Declarative ObjectScript) in contest

but the post is not about "why you should support me" on contest.

I faced with ObjectScript in the university while was working on my diploma (in 2013).

Very good mentor @Evgeny Shvarov helped me to get started with ObjectScript development.

#Caché #InterSystems IRIS #ObjectScript
2
0 296
Article Fabio Goncalves · Apr 18, 2017 9m read

Tracking Data Changes - Audit Log - 1 of 2

Introduction

The common requirement in many applications is logging of data changes in a database - which data has changed, who changed them and when (audit logging). There are many articles about this question and there are different approaches on how to do that in Caché.

I'm sharing a mechanism that can help you implement your framework to track and record data changes. This mechanism creates a trigger through an "objectgenarator" method once your persistent class inherits from the "Audit Abstract Class" (Sample.AuditBase). Since your persistent class inherits Sample.

#Caché #Best Practices #Object Data Model #ObjectScript
9
2 2676