Any insights, news, alternatives or experience about sequence pattern querying like with Oracle's MATCH_RECOGNIZE, more declarative, less simple direct COS way? Both obvious solutions (shadowing data to oracle cloud or implementing MATCH_RECOGNIZE compiler in COS from scratch) seem big overkill. Do Intersystems have plans to adopt this "2007 ANSI standard proposal" and "SQL:2016 standard"

Last comment 4 May 2018
0   0 2
0

answers

177

views

0

rating

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

Last comment 4 May 2018
0   0 2
0

answers

299

views

0

rating

Hi, 

We have a PAS that accepts HL7v2 QBP^Q21 requests, and returns patient details in an RSP^K21.

We have a clinical system that wants to sent an http GET request of the form http://server/getpatientbyid?pid=M1234567

So I think I need to convert the query url into a QBP^Q21 (HL7) message, then take the response in HL7v2, convert to SDA, convert to FHIR, and put that in the response to the  original GET.

Does anyone have any experience doing this? is there an approach you would recomend?

Last comment 19 April 2018
0   0 3
0

answers

504

views

0

rating

Hello,

I am running a transformDTL through COS that transforms an EDI document to JSON and would like to validate the document and throw an error if it does not validate or build a map.

I am looking at available methods and haven't been able to find one that sort of does:  Set tSC = ##class(*).Validate(tDoc,"HIPAA_5100").

Any help here would be appreciated, it seems like I am missing something simple.

Last comment 11 April 2018
0   0 2
0

answers

160

views

0

rating

I'm having a lot of trouble figuring out how to properly map List collection types. I can't change the schema at all, and I don't have the ability to change the way they are stored from the serialized form to the Array projection. I'm also pretty locked into using JPA for Java interoperability, as I'd like to be able to change out the backing database arbitrarily.

0   0 1
0

answers

0

comments

124

views

0

rating

Problems encountered with Java Gateway

I am writing a framework for use on the Java Gateway. The role of the framework is:

1. Import the framework jar file into ensemble studio (test completed);
2. In the framework jar, handle the related functions of the remaining jar files (the rest of the jar files are written by colleagues).

The general idea is as follows:

Send: Ensemble Java Gateway -> Framework Jar -> Plugin Jar (colleagues write, processing data).
Returns: Plugin Jar (processed return data) ->Framework Jar->Ensemble Java Gateway.

Last comment 29 March 2018
0   0 3
0

answers

299

views

0

rating

Sounds odd - but I encountered it - twice now. Cache was restarted. in that period the primary journal directory was full and it was writing to the secondary journal directory. So upon start-up, it was quite obvious that it was not going to write to the primary. Cache reported this but was able to continue with the start-up but writing to the secondary. All of a sudden it doesn't recognize the 'primary' config any more and started saying 'Alternate and primary journal directories are the same'.

Last comment 29 March 2018
0   0 3
0

answers

269

views

0

rating

I tried to access Caché using ADO.NET. This works fine but when I want to use Entity Framework, I can't access the Caché Data Source.

I'm using Visual Studio 2017, and followed the procedure described in Caché documentation.

(This document has been written  regarding VS2013)

Did some meet the same problem ?

Thanks in advance.

 

 

Last comment 21 March 2018
0   0 4
0

answers

326

views

0

rating

Hi ,

     I'm using standard business service not(Customized business service). I'm not able to process the Hl7 data file which contains CRLF characters.It shows warning "Discarding  Received non HL7 data". Actually it discards some segment after CRLF character. Is there any settings to overcome this problem?

 

Also i tried UTF-8, Ascii,Unicode.. characterset . But it won't work. Please help me .

 

Urgent!!!

Last comment 7 February 2018
0   0 3
0

answers

436

views

0

rating

Hi,

I have the Atelier plugin (latest stable release) installed in Eclipse Oxygen running on Ubuntu 16.04.2. Working well except for the BPL visual editor. When I select it, it displays a pixelated image in the view tab. Not sure if this is a Atelier issue or an Eclipse/GTK issue? Has anyone else seen this behavior?

Thanks

 

 

 

Last comment 12 January 2018
0   0 2
0

answers

169

views

0

rating

Hi,

Our ensemble instance has grown significantly since it was first implemented in 2014, and the old interfaces diagram is no longer useful. We started with a few HL7v2 ADT and demographic interfaces, but our use of Ensemble* has grown to include document interfaces, orders and results, ITK and inbound and outbound interfaces from other organisations. (more and more like an Enterprise Service Bus than a simple integration engine)

I'm looking for examples of and methods for creating;

Last comment 8 January 2018
0   0 2
0

answers

220

views

0

rating

Hi, I'm a student, weak programming. I ask for your help, I write a program in C #, there are two tables, but I do not understand how to organize the connection between them many to many. Table in DataGridView1 from DataSet1 on Form1 key connection in DataGridView1 from DataSet1 to Form3

I do this on Form1

Last comment 12 December 2017
0   0 1
0

answers

238

views

0

rating

We have a program set up in the HealthShare Facility Registry. And we have some patients enrolled into this program. In the HealthShare Registry management, we set up following consent policy for this facility (we call it program), Default Block Except: Block data except for the groups specified below, unless overridden by patient. There is no program in the Selected Programs so the consent should be applied to everybody.

0   0 1
0

answers

0

comments

214

views

0

rating

Dear community!

What do you think about webinar "Declarative programming on COS"? I want to do such one.

I am going to tell about main points of declarative programming and how you can implement it in your real projects.

Please feel free to write your opinion here.

Please if you wish to become a member of such webinar write me a message to atygaev.mi@gmail.com with subject "webinar".

Last comment 23 November 2017
0   0 2
0

answers

129

views

0

rating