All time
InterSystems Developer Community is a community of 25,406 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi all,

We faced a problem where we would like to map a $lb object to its corresponding data model structure in order to later on export it as JSON.

So imagin that we have something like this that actually maps to a persistent table with its structure. 

$lb("",,,,,"",,,"BOOLEAN","0",2,2,"1",,"bla",$lb(,,"bla","20050502123400"),"",1,"bla",,0)

Is there a way to transform this $lb (without the need of openig the object itself) to a JSON object with the proper table fields as properties?

Many thanks

0 9
0 554

Our client getting sometimes this error and we need to change port number on JavaGateway process to continue,

Failed to start the Gateway server: ERROR #5023: Remote Gateway Error: Communication failure on port: 5000
> ERROR #5001: External Language Server: invalid ping response

Can you tell as why it is happenning? intersystems runtime is under linux.

0 6
0 556

Hi Developers,

We're super excited to share with you the new awesome functionality of the Online Analytics Dashboard for every Community member 🔥

From now on, you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

      11 1
      0 542

      Does anyone have experience with CircleCI or really any automation tool using %UnitTest?

      I have built my app and ran my unit test in a Docker container automated by CircleCI. However, after many of the tests failed I see:

      How do you halt out of the IRIS session and return an exit code to the shell?

      I have a script in my repo that I pass into IRIS after CircleCI does the code checkout

      iris session IRIS < inFile

      0 8
      0 554
      Question
      · Mar 4, 2017
      Calculated Fields

      1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

      2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

      Thanks!

      0 3
      0 559

      Hi -

      I'm wondering if anyone has coded up a means to create an extension for a %Persistent class from a base class to a sub-class without making a ton of assumptions about the Global structure. I'm trying to create a new "extension" record that would have the same ID as the Base Class

      Class BaseRecord Extends %Persistent

      and

      Class SubRecord Extends BaseRecord

      where I would have an instance of a "BaseRecord" and I want to turn it into a "SubRecord" instance and have all of the existing references to the BaseRecord survive.

      0 7
      0 554

      "SELECT %SYSTEM.SQL_TableExists('table name') "could work as expected under SQL shell,

      but for "CALL %SYSTEM.SQL_TableExists('table name')" does not work (not any error reported, it just show nothing).

      Is there any reason why CALL could not be applied to a stored procedure?

      Thanks.

      0 7
      0 554

      I am trying to use Atelier against a 2016.1.1 server:

      Cache for UNIX (Apple Mac OS X for x86-64) 2016.1.1 (Build 108U) Wed Jul 6 2016 16:06:38 EDT [HealthShare Modules:Core:15.01.2136 + Linkage Engine:15.0.2136 + Patient Index:15.0.2136 + Clinical Viewer:15.01.2136 + Active Analytics:15.0.2136]

      I'm having trouble creating a connection and I realize I need to create the /api/atelier web application manually. I must not be setting it up correctly because I'm still having trouble connecting. I get an error when I test the connection that says:

      0 3
      0 558

      Hi

      I have been experimenting with the creation of a set of REST services for an app. The basic GET operation is set to create a %ZEN.proxyObject instance, and then set an instance of a Persistant class as a property, which gives me all of the values I want to return. However, it also gives me some values that I don't want to return over REST (because they are both private, and large registered objects which will bog down performance)

      2 3
      0 558

      Here’s a special thread where you can tell a bit about yourself — because connecting and learning more about each other is what makes this community great 💬✨

      We had a similar discussion on our old Global Masters platform — you might remember! We’re excited to bring that networking opportunity back to the community.

      8 31
      1 529

      Today, we take a moment to shine the spotlight on one of the true pillars of the InterSystems Developer Community, @Alberto Fuentes. His commitment, expertise, and enthusiasm have left an indelible mark on the Developer Community, and we couldn’t be more grateful. Alberto has been a part of the InterSystems ecosystem for over 15 years, starting his journey with InterSystems technology back in 2008. Since then, he has worn many hats, from integrating Ensemble at his previous job to officially joining InterSystems in 2011 and now holding the position of Sales Engineer. Over the years, he’s witnessed—and contributed to—some of the most significant milestones in the company’s history.

      🤩 Let’s dive into his remarkable journey!

      23 11
      0 340
      Question
      · Feb 1, 2023
      NEED NUMBER ROWS IN SQL SELECT

      Hi guys,

      I'm trying find a way to create a row with the number of each row.

      For example:

      In the SQL above, i want a way to create a collum with the number of corresponding row, in this case:

      1

      2

      3

      In SQl SERVER i can use FOR, RANK or ROM_NUMBER to do this, but, i can't find a way to do the same in cache SQL.

      Can someone help me?

      Thank you.

      0 4
      0 556