Hi Folks,

I created a persistent class as below 

Class myclass.DataBase Extends %Persistent
{

Property ID As %String;

Property Skill As list Of myclass.SerialTablelist;
}

and Created another Serial class as 

Class myclass.SerialTablelist Extends %SerialObject
{

Property PSkill As %String;

Property OSkill As %String;
}

Now I will save the id as below

do rs.Prepare("Insert into myclass.DataBase(ID)VALUES(?)")
do rs.Execute(ID)

I am facing issue with the AS LIST OF 

Could any one guide me how to save the Skill (PSkill ,OSkill ) using resultset (I am able to )

I am having a scenario where I need to check difference between current date and a past date should be less than 31 in Routing Rule. Can anybody help me how to code that?

Hi All,

We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out.

If I am not wrong, Tableau is the suggested alternative to DeepSee .

Hi,

I'm a java developer,have  integration package for springboot?(maven or gradle)

How to deal with it EnsLib.EDI.XML Restrictions on the return length of the. Document class

Hello CCR Users,

This is a last call for feedback on a few Angular pages in beta before we release them to all CCR Users later this month. 

These pages will be released from beta:

• Create CCR
• Clone CCR
• Merge CCRs
• Group Details
• Standard Changes
• Peer Review Docs

Group, Standard Changes and Peer Review Docs are lower traffic pages, so we especially appreciate feedback on those.

Any issues or feedback can be reported here or in your regular support channels. Non beta users can toggle their beta status here in the CCR app.

Thanks!

I have an SDA feed from an Edge server that eventually is fed into HSHI / Analytics. This edge server is loading up patient demographics (in the Patient object), which feeds the HSAA.Patient table in HSHI / Analytics.  

However, we have other edge servers also feeding into the same HSHI database, and these other edge servers have better demographic information.  

HSHI appears to use the most recent demographic information from all edges.  What's the best way to de-prioritize patient demographic information from this particular edge (or this particular Facility) when feeding it into HSHI?

Hi all - we just released the first episode of Season 2 for our Data Points podcast by Learning Services. This episode features a conversation with @Bob Kuszewski about Embedded Python. If you're a Python developer, or if you're simply interested in the functionality, check it out! For more information, head over to https://datapoints.intersystems.com.

Hi guys,

I've two Ensemble instances running in a 2016 server but only one of them showing in startup programs.

the ensemble cubes doesn't showup in the programs list from the Start button as well so how can I add the cube so I can access it's facilities (Studio, MP,...etc)

Thanks

I'm using cache  win10-x64  version 2017.2.1.801

I want to uniquely identify the installation of cache, and from that create a meaningful unique folder names to store files. 

so to generate \192-168-1-100\KEVDEV\testfolder \ and \192-168-1-5\LIVE\testfolder\

so in this case, I could- use the IPaddress and thesecond part of $SYSTEM (cache instance name) - at least this way, I can instantly see where it came from with little risk of overwriting between cache instance.

I'm required to do a transformation around patient physical addresses.  If (for whatever reason) a patient has multiple addresses, I want to move the home address to the first iteration of PID:11 and remove all other iterations.  I've accomplished the first bit using DTL, but for patients who have multiple addresses they are left with empty trailing iterations.  Here is an example I mocked up:

How can I remove those trailing iterations?

This is part of the DTL I've written to do my transformation:

<foreach property='target.{PID:PatientAddress()}' key='i' >
<if condition='source.

Spring Boot is the most used Java framework to create REST API and microservices. It can be used to deploy web or executable web or desktop self-contained apps, where the application and another dependencies are packaged toghether. Springboot allows you do to a lot of functions, see:

Note: to learn about SpringBoot see official site - https://spring.

(I wasn't able to find this in the docs or the Community, so feel free to point me to a reference that I missed)

How can I determine the effective User and Group that will be used when an InterSystems IRIS process is doing file I/O on the file system for UNIX?  Bonus points if you can tell me how to do it from within InterSystems IRIS as well as from the host OS.

Thanks!

I'm trying to write a method that runs an OS command with $zf(-100,"/ASYNC") and then waits for it to finish before returning, but I can't figure out how to check if the child process (in $zchild) is still running. $System.Process.State($zchild) always returns "RUN" even once the child process is gone. Is there some better way to check this, short of running another OS-specific command and processing the output (which is just really annoying and unelegant)?

Finding errors in your code or examining unexpected behavior is the main purpose of Debugging
I will try to refresh the traditional tools away from the helpers you have in Studio, VScode, Serenji, ....
to the basics which have been there before your preferred EDI used it in the background.

Hey Community, 

New video is already on InterSystems Developers YouTube:

⏯ Git & GitLab for Shared Development Environments

Maybe someday you will need to use Adaptive Analytics but there is little information about this, so I decided to write an article on how to start developing a dashboard on Tableau using the Atscale cube.

PC preparation

You need a driver to connect. I use Cloudera Hive. You can download the driver from the official site:
https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-1.html
Registration is required, and you can do it right there for free. You also need to know your OS and bit depth in order to choose the right version for download.
Installation is simple, no explanation required.

I have a client with cache instance that is growing by 10-30G/day. In order to determine what is consuming space I ran "DO ^%GSIZE" to generate a report. From the report the bulk of the space consumption is from a couple of globals which appear to be built in globals not user defined. I would like to find documentation that details the function of these globals to help me understand how and why space is being consumed at such a rapid pace.

Hi Community,

I have json equivalent persistent object in pjsonObj variable. Final JSON example below.

{
     "Document": {
                    "FileExtension": "pdf",
                    "FileContent": "JVBERi0xLjUNCiW1tbW1DQo...(very large bsae64 string)"
                }
}

Here FileContent field in json will contain converted base64 string of very large pdf(10pages). I need to submit this json as a payload to REST endpoint.

below code is working fine. 

set tSC=##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.newobj,pjsonObj,,,1,"aelqtw")
$$$LOGINFO("json"_

Hi, I am trying to work with visual studio with the extensions offered by InterSystems, but I can't find any option to work locally, is there any way to do it?

Hi Everyone!

I have a question about how teams are using Atelier, in my experience, using a single-server/multi-developer environment is becoming problematic for us, especially when using GitHub to source control our code, let me explain...

Hi everyone, i cant understand what is wrong in my query: 

ALTER TABLE MyNamespace.MyTable ALTER COLUMN CurrentColumnName RENAME NewColumnName

I just want to rename column name using sql.

I could not find any life example using this syntax.

SQLCODE for this query is -25:

-25 Input encountered after end of query

Quote from documentation:

• Rename the column using the syntax ALTER TABLE tablename ALTER COLUMN oldname RENAME newname. Renaming a column changes the SQL field name. It does not change the corresponding persistent class property name.

The InterSystems IRIS IntegratedML feature is used to get predictions and probabilities using the AutoML technique. The AutoML is a Machine Learning technology used to select the better Machine Learning algorithm/model to predict status, numbers and general results based in the past data (data used to train the AutoML model). You don't need a Data Scientist, because the AutoML it will test the most common Machine Learning algorithms and select the better algorithm to you, based in the data features analysed. See more here, in this article.

If your REST API need return a file to the client download, this is the source code that you could write (P.S.: extracted from the question https://community.intersystems.com/post/download-file-rest and its responses):

Hi Community,

Please welcome @José Pereira as our new Moderator in the Developer Community Team! 🎉

Let's greet José with big applause and take a closer look at his bio!

Hi,

I am using VSCode together with IRIS 2021.1.
When using Shift+Alt+F to reformat a class file, it pops up with the below message. When I select install formatter, it routes me to the extensions page, where it shows the extensions as being installed. Any advice will be appreciated.

This article is a follow-up to the previous one on how to migrate from popular databases (like PostgreSQL and MySQL) to IRIS.
We will use the same procedures utilized to migrate from PostgreSQL. However, you will see that it is even easier since the data types in MySQL are very similar to IRIS. That is why we will not need to create transformation rules in the columns.

Get the sample data to the migration process

In GitHub it is possible to download a docker-compose project to build and run 2 databases:

• Source Database: MySQL database Docker instance with a sample database.

In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality.

It is recommended to go through LOAD DATA documentation first. 

After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table

Below is the basic command when table is already created and source file does not contain header row. 

LOAD DATA FROM FILE 'C://TEMP/mydata.txt' 
INTO MyTable

The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns.

Loading from File Source: Header

Hello everyone! Don't miss the Developer Community Post Digest for January 2022.