I experience this constantly with Cache SQL.  Especially when querying the ATNA log.

SELECT TOP 400000 * FROM HS_IHE_ATNA_Repository.Aggregation ORDER BY ID DESC

That took 12 seconds.  I then upped the number to 500,000 and it took 185 seconds.

Shouldn't the execution time scale proportionately?

If I run the 500,00 query again it takes 2.4 seconds.

I need to do an UPDATE via SQL and I would like the statement to return the `ID` column of each row that is updated.  MS SQL has an "OUTPUT" statement, but I don't see anything similar in Cache.  Is there a way to do this?

We have an incoming ADT adapter and the ACK MODE is set to IMMEDIATE.  This is what the docs say: 

An inbound ACK shows up as a square in the visual trace.  These do not.  How can I view them?

Given the following data type:

<DataType name='TN' description='telephone number'>
    <DataSubType piece='1' description='telephone number'/>
</DataType>

What is the point in setting a SegmentSubStructure's datatype to "TN" instead of "ST"?

I see the TS and DT data types in the default 2.3 schema:

<DataType name='TS' description='time stamp'>
    <DataSubType piece='1' description='time of an event' datatype='ST'/>
    <DataSubType piece='2' description='degree of precision' datatype='ST'/>
</DataType>

<DataType name='DT' description='Date (2.8.13)'>
    <DataSubType piece='1' description='Date (2.8.13)'/>
</DataType>

but it doesn't appear that it would actually validate the format. Is this possible? We had an instance recently where a customer was sending a timestamp with a missing digit (20160503120 for example).

Did some searching online with no luck.  In Studio, is it possible to add comments to .HL7 schema files?  For instance

<!-- This is a comment -->
//or maybe this is
<MessageStructure name='ACK' definition='MSH~MSA~[~ERR~]'/>

Using Node.js with Caché - Introduction says the following:

The cache.node module is the Node.js interface for the GlobalsDB kit, which can be obtained from the GlobalsDB download page (http://globalsdb.org/downloads/). The Node.js interface can be used with either Caché or the free GlobalsDB database.
The installation kit includes detailed documentation on how to install and configure the cache.node module.

However, http://globalsdb.org/downloads gives a 404 and http://globalsdb.org just redirects to intersystems.com

Where can I find the files I need?

I'm doing some Schema changes.  I used our existing standard schema as a base, which was already based on 2.3.  So let's call our existing one Custom.MHC.Schema (based on 2.3).  I created Custom.MHC.Schema.Advanced (based on Custom.MHC.Schema) and copied down one of the code tables then made a change to it.

When I ran a message through, the code table change didn't show up.  I noticed in the message viewer that the DocType is still Custom.MHC.Schema:ADT_A01 but the DocType Category is Custom.MHC.Schema.Advanced.

I get email digests like this every few days.

Took a look around and didn't find any.  I'm playing with setting it up now in our dev environment but reading walls of text only gets me so far.

We had a major problem recently where a participant was sending unexpected data. It was not enough to throw an error or warning in the actual trace, but when examining the message in the viewer it did show the following:

Build Map Status = 'ERROR <EnsEDI>ErrMapSegUnrecog: Unrecognized Segment 4:'CON' found after segment 3 (CON)'

How can I query for these or be notified of them?  This caused major ramifications but we did not notice it.  I have Managed Services investigating but I want to cover all my bases.

Sometimes simply reading the subject or summary of a post from the index gives me enough information to vote.  Instead of having to click through it would be nice if I could vote from the list of posts.

We have multiple implementations spanning many namespaces and edges.  I would like to see if I could identify a single place, perhaps on HSREGISTRY or HSBUS, that I could capture certain events like searches (from all customers) and record transfers (with requester and provider).  

The goal is to have a dashboard that would show simple stats such as searches by participant, records shared by participant and records consumed by participant.  These are the 3 most important.

I appreciated the feedback on the other question of "how" but now I'm hoping to find the "Where".  

I'm following the tutorial here.  When I try to call the default Test() method I get the following error:

An error occurred with the CSP application and has been logged to system error log (^ERRORS)

I found this document which says I need to make the "Web Application" accessible by running a couple commands.  I'm not even sure I created a Web Application.  Regardless, I tried a few variants but still get the same error.

Here is the URL for the Service Catalog: /csp/healthshare/mhclib/Custom.MHC.Scott.ServiceTest.

If I wanted to build a web-based dashboard that monitored various HIE transactions where would I start?

Examples of measures would be Provide & Registers by Facility, Patient Views by facility or even PHR related data.

I have a successful POC that uses nodejs, html and SQL but I think it makes more sense to use Intersystems technology all the way around, I just don't know where to begin.

CSP for the web piece I assume?  How would I access the data, for instance all P&R requests on the BUS?  Any other tips or starting points?  Maybe examples of a similar project?

We do not have a DeepSee license

Occasionally I see a production item with a little 2 flag.  When it has that, there is an "Item" dropdown.  What does this mean?

I have a tool I absolutely love for HL7 v2 analysis and manipulation. It's called 7edit.  I'm wondering if there is anything similar for HL7v3/CDA/CCD.  I know it is considerably more complex, but I still have hope.

So far the best resource I've found is http://www.cdapro.com/.  I'd love to hear anyone else's tips for tools or resources.

This is a bit weird.  I'm trying to use `DATEDIFF()` to calculate the time since the last message on an interface.  For some reason, when no messages are received, the number steadily decreases.  This is the opposite of what should happen.  Here is my current query and a few sequential result sets:

SELECT getDate() as now, max(TimeCreated) as latest, DATEDIFF (s,getdate(), max(TimeCreated)) as difference
FROM EnsLib_HL7.

I was planning to fully map out all the transforms that incoming CCDs go through before they are displayed in the Clinical Viewer or sent back to another facility.  When I opened the XSL files, I see some very good comments like the following:

I have two servers in our TEST environment.  One with HSBUS and one with HSREGISTRY.  Let's call them "HSBUS01" and "HSDB01" respectively.

Now, I can access HSBUS with my SQL client by using the JDBC driver pointed to hsbus01.full.name.com and port 1972 and specifying a namespace of "HSBUS".  I am, however, unable to access the HSREGISTRY instance via SQL with a similar combination of information.

I have access to the web interface on both servers (/csp/sys/#CSP.Portal.Home.zen).  What screen can I use to compare the relevant settings?  I think it might be a port issue.

I tried logging into https://beta.learning.intersystems.com to view a video.  My browser auto filled the login form.  The username, the same one I use here and on many other ISC sites, is "sbeeson_MHCX".  Now I have a message that says "Only lowercase letters allowed" and any time I visit the login form it just shows the same message.  I cannot get back to the form.

I could obviously use an incognito window or clear my cache, but this needs to be fixed.

I would really like to see (an option for) a more compact index of posts.  The current index layout makes me feel like a) there's not much content on the site and b) I have to look harder to get an idea of what's going on.  I feel like I'm forced to read each post instead of just glancing over a "list" of posts. 

If I'd had time I would have made a couple mockups, but basically see any forum or email inbox for an example of what I think you should work towards (at least somewhere in between).  The way it is it reminds me more of my Facebook feed.

It's amlost fixed!

But it still hijacks my right click.

I received an email notification and the only link was directly to the comment: https://community.intersystems.com/question406316/answer406331

From that page you can see that there is no way to get to the full question itself (unless I'm missing it).  

Looking through my subscriptions it looks like I'm literally subscribed to the answer and not the main topic. 

I think there should at the very least be a third option; "discussion".  

Was this intentional? I don't like it.

How about a default tag for each community?  If I'm in the Developer Community Feedback I shouldn't have to also pick a related topic of Developer Community.

This post brought to you by the department of redundancy department.

This latest update was a huge stride in making the community usable.  I think you fixed almost all of the major usage gripes I had and it's looking great!

We have a situation where we want to detect and ignore documents/records at the earliest possible point based on certain criteria.  We have an existing "CDA Preprocessor" in the workflow which is an XSL transform.  This is what our contractors are planning to utilize to "filter" these documents.  This doesn't really make sense to me.  I see XSLT as a way to manipulate the contents of a document and filter certain peices of data.  In my brain, I would use an Ensemble business rule to detect the criteria and route the document as necessary.

Does anyone have any input on this?