Hey Community,

We are really looking for your feedback on a new offering - InterSystems FHIR Transformation Service. 
It went live on AWS Marketplace where you can try it for free!

We launched a related challenge on GM where you can get points for giving it a try and a "thank you" prize to everyone who leaves feedback in comments to this post.  

After calling an API with

Do request.Get("/api/address/listing")

Set data = {}.%FromJSON(request.HttpResponse.Data)

I get this error: 

<THROW>%FromJSON+37^%Library.DynamicAbstractObject.1 *%Exception.General Premature end of data 12 Line 1 Offset 0

any clue what might be causing this?

I have a report that requires a different header block for the first page and another for subsequent pages.

Is there a way to direct a header page to another header page  based on what the current page number is?

Hey Developers,

See how API management can simplify healthcare application development with FHIR:

⏯ FHIR API Management @ Virtual Summit 2020

I want to achieve the same function as the management portal under the Utilities menu。

I wrote a studio.sourcecontrol menu tool. I want to use chrome to open the CSP page. Now I can open it to CSP, but the IP address is the intranet IP of the cloud server. How can I get the IP of the current studio connection?

Set Action=3
Set CompName = $p(InternalName,".CLS")
//Do ##class(%Studio.General).GetWebServerPort(.IP,.Server,.urlprefix,.ipport)
Set url= ##class(csp.csp.download).%GetParameter("CSPURL")
Set IP = $p($zu(54,13,$zu(54,0)),",")    // Intranet IP  。 I want to get the connection IP of the c

Hello I am in My 2nd year of Engineering, and want to learn Python Programing Language, Please suggest to me the best books and best online resources that will help me to learn the python language.

I work on an ERP system and am trying to set up a dashboard according to a customer request. It's a pivot table with a few controls and filters, nothing too difficult, but I'm having some issues with drill down.

We've got item sales data. Quantity sold, sales dollars, cost, gross profit as both dollars and a percentage. It's starting out with one row per item. From there, we can drill down to see which salesmen have sold that item and get all of those numbers for each salesman. After that, we can drill down to that salesman's customer accounts and see which of their customers have been buying

 the start date must always
be the first day of the effective salary month.
 

Hi,

I have two questions:

• Does "everything" that's available on Caché it's available on IRIS too?
• Does everything available on IRIS Windows version it's available on IRIS Linux version?

And now, you can help us!

Take a 5-minute survey and tell us what YOU want to see in our learning resource names!

Hi! I am working on a project where I use record map to transform a flat file and split it into two output text file and in the future will need to split four output files.

I only want to use one  target business operations instead of multiple. Is there a way to set the output file and the target folder path in my business process class?

Any advice on how I can achieve this or is this possible? Thanks!

Hi All,

I came across this video https://www.youtube.com/watch?v=fElr8STTnEI  which Generate DTL based on input and output messages. I am not able to find this in my IRIS kit. Is this not included in 2020 version?

Apologies if this isn't the correct forum but here goes..

I'm accessing an Intersystems database from MS SQL Server using Intersystems ODBC driver and using OPENQUERY statement to read metadata of tables using

SELECT * FROM OPENQUERY([<linked server name>], 'SELECT * FROM INFORMATION_SCHEMA.COLUMNS')

but I get an error message saying INFORMATION_SCHEMA.COLUMNS cannot be found.

Intersystems SQL documentation does reference this table so is there some other way to access this table or is it maybe a permissions issue?

Hello Again,

InterSystems Certification is still looking for people to beta test the HealthShare Patient Index Technical Specialist Certification exam. We have extended the deadline of the beta test to July 31st, 2021. For details, see the original announcement.

Thank you!

I'm trying to produce Kafka Message to Topic using Java Objects. I have build Business operation and  Jar file and trying to execute. I'm getting following exception 

Terminating Job 8316 / 'IrisKafkaProducer' with Status = ERROR #5046: Error executing java command 'init() returned: "ERROR #5034: Invalid status code structure ("java.sql.SQLException: [InterSystems IRIS JDBC] Communication link failure: Access Denied")"'. Java may not be installed correctly on your system., %QuitTask=

Getting following trace at Audit Database

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan.  My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect.  If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for.  To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be us

Hi,

While adding button in Zen Form I am getting below error:

"ERROR #6353: Unexpected attributes for element button (7,66): onselect"

Looking Forward

Thanks

Good afternoon I am making a method of a class that I want to return a list of objects of another class that I have defined, example:

ClassMethod myMethod() As list of MyPackage.MyClass
{
}

But it gives me a syntax error, I try this and it works:

ClassMethod myMethod() As %ListOfObjects
{
}

But I would like to keep the typing.

Is there a way?

Hi,

I have multiple processes in a production. How can I link process to multiple categories?

Thanks

Hi,

After cloning "http://github.com/intersystems/Samples-Integration-RedLights" sample code I imported sample production from /home/project/Samples-Integration-RedLights/data/EndStateProduction.xml file to my local system.

Now I am getting the error "ERROR #5021: Directory '\home\project\shared\Samples-Integration-RedLights\data\SampleFiles\' does not exist." in my service.  

While modifying the Directory path I am getting below error :

"A JavaScript exception was caught in function function SecurityError" : Blocked a frame with origin "http://localhost:52773" from accessing a cross-origi

Hi all,

We're encountering a problem using CacheSQLStorage where one of the subscripts of this mapped table contains the string "||", which causes issues as Caché uses "||" as a delimiter. Is it possible to assign a different delimiter?

I'm attaching the code of the class as an example.

Class MainCore.System.MDA.msort2x2x2 Extends %Persistent [ ProcedureBlock, StorageStrategy = MainStorage ]
{

Property Subscript1 As %String;

Property Subscript2 As %String;

Property Data As %String(MAXLEN = 32000);

Property ZREF As %String [ Calculated, SqlComputeCode = { S {*} = ##class(MainCore.System.U

Hi guys,

need some help here. How do i use sql to query tables from different database which reside in same server?

Hi,

I am testing some BI tools like Tableau, Power BI and Qlik with Caché using ODBC driver

Is there another way to connect them with Caché?

Hey Developers,

We're pleased to announce the next InterSystems online programming competition: 

🏆 InterSystems AI Programming Contest 🏆

Duration: June 28 - July 25, 2021

Total prize: $8,750 

Landing page: https://contest.intersystems.com

Hi Developers,

Writing a script for the application deployment can be very interesting to ensure rapid deployment without forgetting anything. config-api is a library to help developers to write configuration scripts based on a JSON document.

Implemented features :

• Set system settings.
• Set security settings.
• Enable services.
• Configure namespaces, databases, mapping.
• Export existing configuration.
• All features are exposed with a RESTful API.

This library is focused on IRIS configuration to help applications deployment. So, config-api doesn't import\compile code feature, considering it should

In a DTL to transform from HL7v2 to FHIR; select the code for the attending provider within a for each statement

<foreach property='source.AttendingClinicians()' key='st' >

<if condition='source.AttendingClinicians.(st).Code&apos;=""' >

<true>

<if condition='..In(source.AttendingClinicians.(st).IdentifierTypeCode ,"NPI","PNPI")' >

<true>

<trace value='source.AttendingClinicians.GetAt(st).Code' disabled='1' />

<assign value='source.AttendingClinicians.Code' property=' npicode' action='set' />

At compile get this error

Compilation started on 06/08/2021 21:30:03 with qualifiers 'k', usin

Hello fellow community members,

I would like to offer my services as an Intersystems Professional and am available to work on projects. 

I have more than a decade experience into  Intersystems stack of technologies including IRIS, Ensemble, Healthshare, Healthconnect, Cache Objectscript, Mumps, Zen, Analytics etc. with companies spread over US and UK  involved in multiple domains.

KEY SKILLS: 
Cloud Computing (AWS, MS Azure, GCP)
Intersystems Technology Stack (IRIS, Ensemble, Healthshare, Cache, Mumps, CSP,  ZEN, Analytics)
Databases (Modelling & Backend database design, SQL, PL/SQL 
SOAP & Res

Can the built-in $System.Encryption.TOTP() function be used in conjunction with Authenticator Apps (e.g. Google, Microsoft, and so on)?

Providing the same secret/key to a variety of authentication apps, they all return the same synchronized value. However, passing the same secret/key to $System.Encryption.TOTP() is generating a different value (with all instances executing at the same time for comparison).

All of the reference material I have found so far mentions RFC4226 or RFC6238 or both, including the Intersystems documentation. However, it appears that these other applications are adjus

Hey Community,

Here's a new CodeGolf challenge for you! Check the details in this post.

Task

You'll have to translate a string into a Pilot's alphabet (NATO phonetic alphabet).

Input:

If, you can read?

Output:

India Foxtrot, Yankee Oscar Uniform Charlie Alfa November Romeo Echo Alfa Delta ?

Note:

• The set of used punctuation is ,.!?
• Punctuation should be kept in your return string, but (original) spaces should not
• Xray should not have a dash within
• Every word and punctuation mark should be separated by a space ' '
• There should be no trailing whitespace
• Use this code to check the result length

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Best Practices for In-Platform AI