greetings Community!

InterSystems Learning Services is working to identify and create libraries of high-quality learning resources for third-party technologies, platforms, and systems that are part of, integrated with, or commonly used with InterSystems products and technologies. we don't create content for these ourselves, but want to support our clients, external and internal, in learning about them and how to use them.

0 0 53

I have  a SQL query that I want to run against MS SQL from cache ensemble using the SQL outbound adapter. If I run this query direct from MS SQL Studio it take about 7 seconds MAX and returns about half a million rows. The row only contains one column it is a number all same size and if I run this query in the production in ensemble it takes for ever the production finishes without getting the response back. The same query run in cache outside the ensemble environment writing results to a file it returns results taking about 3minutes to complete.

0 0 66

Consider a Natural Key with an Identity (Serial) field.

I cannot seem to acquire the generated value after persisting my entity. That is, the returned entity by Spring Data's "save" does not have the generated value.

The value is generated by the database, and I can query it after

I have done some testing and created a Github repo with it...

0 0 78

Following instructions on this page I am trying to create a Data Connector to be used as a base class for a cube with update support.
That page suggests that putting an SQL query inside XData block is not suitable for a Data Connector that supports updates.
Later it also suggests that to enable updates your SQL query must include 

0 0 79
Jian Li · Nov 20, 2020
validate logon

When I log in to the management portal page, I want to know where to verify whether the user name and password information I entered are correct, and how to handle it in the program. Is it handled through routine? Or is there a Dispatch Class to handle?

0 0 99


I was tring to figure out the correct way of using action code = c under <Encounter>, but havn't got much progress. Here is what I tested and observed:

Quote from the class reference doc: 
D = Delete this Encounter and any other Streamlets linked to it via EncounterNumber
C = Clear all Encounters for this Patient and any other Streamlets linked to them via EncounterNumber

0 0 108

I'm building a .Net Core Gateway container. Here's the issue.

As a final step I'm building a .Net Core 2.1 library. It has a runnable dependency - .Net Gateway, which I need to start first.

However dotnet publish generates .runtimeconfig.json and .deps.json only for my library and not for my dependency (.Net Gateway).

Is there a way to force dotnet to generate .runtimeconfig.json and .deps.json for a dependency?

I have tried:

0 0 1,654

I have developed a pos and tested my  bit map on multiple sites, but the switch is not responding,
what do you think the error is:
<log realm="channel/" at="Fri Jun 12 14:42:03 EAT 2020.15" lifespan="64ms">
<log realm="channel/" at="Fri Jun 12 14:42:17 EAT 2020.802" lifespan="1ms">
      <!-- org.jpos.iso.packager.XMLPackager -->

0 0 83