I have a lookup table and record batch Table I would like to do a count on the records stored in that batch by counting the number of records in that batch that have a certain key on the responseKey column. This column keys are stored in the look up table for comparison. So I would like to do a join sql pivot that will use my keys stored in the lookup as columns and count as values

so far I have managed to do this but this is not efficient I would like to fire that sql once not on every count

0 1
0 1.6K
InterSystems Developer Community is a community of 25,124 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 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 403

Sometimes, we need to copy part of the properties of an object into a different one.
The simplest thing would be to do the following:

Set obj1.FirstName = obj2.FirstName

Set obj1.SecondName = obj2.SecondName

What happens if the object contains a large number of properties? or we just want to extract an important group of data, and complement the information in another object?

Having the following classes:

4 6
0 1.8K

Hi Community

I've just started developing for a new client and noticed that the View Raw Contents link isn't displayed when inspecting HL7 message contents in the Management Portal. Is the link missing due to:

1) a configuration setting?

2) a security setting?

3) a difference between installation on Unix Vs Windows?

And is there a way to turn it on?

I've trawled through the doco but haven't been able to find anything on this.

Thanks in advance for any help you can give

Duncan

0 2
0 297

I am trying to create a list of id's which are of type integer. I have created a class like below and then I am trying to call the class from a BPL to first initialize the list. In the BPL, I have an assign action that is using set and a context variable setup to hold the list data. The property is using the class I have created, ##class(MSI.IN835.EOBList).%New(). I keep getting an error back saying the method does not exist. Why does it not like the %new method? I am new to cache object script, so if their is a better way to do this, I am open to that as well.

0 9
0 2.1K

Hi, Community!

This post is a digest of the Developer Community postings in April 2018.

Most viewed

Class vs Routine in ObjectScript. What Do You Use And Why? 286

Drawing boxes 240

How to resume inner $order loop from given point? 187

DNI functions 138

How to set space in numbers 132

sql insert from cache 127

Cache Compile Problem 119

MUMPS database - Cache migration 117

Extract text from file 115

Why can I not 'Assign' request directly to a context variable ? 11

0 0
0 262

Hi! I have a local project written on Cache and Atelier on my PC. I need to move it to notebook. Tried to export globals, classes, MAC-programms and csp with frontend stuff, but after I created my apps on notebook and imported my set, it just didn't work. I think it's because I have some settings on Management Portal, so how can I export portal settings and what I should export to have my working apps on another computer?

0 3
0 376
Article
· Apr 25, 2018 4m read
DNI functions

Hi everyone!

I want to share four functions with you. I hope that you can use it at some time.

DNI: the initials of the type of national identity document, is composed of different series of numbers and letters. That proves the identity and personal data of the holder, as well as the Spanish nationality. Example: 94494452X

NIE: The NIE or foreigner identity number is a code for foreigners in Spain.


In this page you can generate examples of DNI or NIE https://generadordni.es/

3 8
0 910

I am using the EnsLib.RecordMap.Operation.BatchFileOperation to write a batch to a file but for some reason this has been working fine as of yesterday I had a problem with the cache databases filling up running out of memory so had to compact my database and gain space now when I run the operation I get the above error .Of course in my batch table there is no batch record with ID 1.The message is passed with the correct header information but still get this error any suggestions why?

0 3
0 1.1K

Hi,

I have a service that I need to receive notifications from when the service has started. Usually this service will be off, but when started a need a method to be called so I can email and be alerted. The only method I know I can use is " OnProcessInput" but this is when an input is received (new file, new message...) but I could not find any events to deal when the service starts...I tried "OnInit" but does not seems to work...any ideas?

0 3
0 402

Hi Community!

Please welcome a new session recording from Global Summit 2017:

Shared Development in the 21st Century

https://www.youtube.com/embed/gOLC2gICEVQ
[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]

1 0
0 432
Question
· Apr 24, 2018
Atelier sync fail

Background : We are now using server side shared developer pool via Studio.

I have setup Atelier on my local and forked the code from the server to workspace on my local. Meanwhile another developer made a change in some class and I want to see the changes.

So I went to Atelier Explorer found the class with "small yellow triangle" (this says that the code changed at the server). So right clicked and did a diff against the server version and found the changes. Now I tired to sync my local with server code by clicking right click and "Synchronize". Got following error.

0 6
0 497

Hi, folks. I have an HL7 SIU message inbound that is missing a few fields, such as patient ID and provider ID. I insert this HL7 message and a few of the fields into a SQL database. My SQL team then runs a stored procedure to retrieve the patient ID and provider ID and insert the found values into fields in the table. I would like to then do a select from the table, load the HL7 message and add the fields that were found by the SQL stored procedure into the HL7 message. I'm attempting to use a DTL to accomplish this.

0 4
0 1K
Question
· Jan 31, 2018
EDIFACT SCHEME OR SEF

We need to process 01B edifact files, INVOICE / CREDIT NOTE / DEBIT NOTE, ORDER, MESSAGE STATUS

Does anyone have SEF files or scheme to import , this EDIFACT version or other to use it at Ensemble?

Thanks in adavance!

0 12
0 698

"Telegram" is a well-known instant messenger, which provides an API for creating bots. The features of this API allow you to create bots with a wide range of functionality including receiving payments.
With the help of the telegram bot, I solved a simple task - sending Alerts from Ensemble to Telegram.

Advantages: Alerts come to the mobile phone, a notification appears, so there is no need to install any additional applications (in contrast to the solution https://community.intersystems.com/post/sending-alerts-mobile-phone-using-pushover- httpoutboundadapter).

The bot can be extended by adding new commands, for example, for managing the Production or for solving other tasks in Iris, Ensemble or Cache.

14 0
5 1.4K