All time

Anyone know if it's possible using cache objectscript (or something else maybe) to reference an object property using a variable? For example:

s obj={}

s obj.prop1="hello"

s var="prop1"

w obj.var <== which would result in a reference to obj.prop1 and write out "hello"

0 7
0 378
InterSystems Developer Community is a community of 23,523 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi There ,

We are trying to do a small POC trying to integrate NHS Careconnect with Ensemble/Healthconnect. Does anyone have implemented this before. It would be good that you provide some suggestions or any sample implementation. It would be good to get suggestions any interesting use cases

within NHS England for the POC.

0 2
0 383

Hi Everyone!

Enjoy a new video on InterSystems Developers YouTube Channel:

Sizing and Capacity Planning

https://www.youtube.com/embed/3dNBEzdB5W4
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 385

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.

I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])

0 3
0 382

When I open a class in VS Code and I want to save it I'm getting the following error : Non-JSON response to /api/atelier/v7/DEV/doc/API.Mollie.Execute.cls?ignoreConflict=0 request. Is the web server suppressing detailed errors?

Also I always get a popup when I open VS Code "The extension wants to sign in using InterSystems Server Credentials."

0 2
0 382

Example:

Method Execute (args...) As %Status {
...
 #dim statement as %SQL.Statement
 set statement = ##class(%SQL.Statement).%New(2)
 set statement.%Dialect = "CACHE"
 do statement.prepare(query)

 #dim rs as %SQL.StatementResult
 set rs = statement.execute(args...)

My questions are: 1) how do I get the size of args **2) how to get all values of **args **3) is it possible to modify the **args?

0 6
0 378

Hi guys,

Suppose I have a JSON string as below:

{"MessageID":"11111","save_date1":"2022-02-02 01:01:34","Sender_ID1":"esb","sent_date2":"1985-12-11 11:42:00"}

The two date variables are all formatted as ODBC date time, when I tried to import it to a %JSON.Adapter object, the date format was rejected as below

Error #9406:Unexpected format for value of field, save_date1, using class base mapping

Thus I'm trying to format all possible ODBC date time in the incoming JSON with Regular expression:

0 2
0 382

Hi Team,

I am working on data transformation ADT^A01 from ADT^A01 ,In both source and target MRG segment is not available. How can i create a new MRG segment in Target. Kindly share your ideas how to create a new segment in Data transformation.

Thanks in advance

0 2
0 382

Hello All,

I connected the Cache from Power BI using ODBC connection. And I can able to view the tables but I could't able to view the data records. getting some error when I shoot on the table name. I couldn't trace what I'm missing. Please help me.

Error Message: "Value cannot be null. Parameter name: exceptionType"

Thanks,

0 2
0 382
Announcement
· May 8, 2020
New Video: FHIR Update

Hi Community!

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

FHIR Update

https://www.youtube.com/embed/2rLokuiAjE8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 4
0 304

Hi Community!

Two more new videos are already on InterSystems Developers YouTube Channel:

1. Machine Learning - How it Works - Part 1

https://www.youtube.com/embed/47M8FWB5C5Y
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2. Machine Learning - How it Works - Part 2

1 0
1 384