The typical WHERE condition in SQL relates mostly to some content of the rows you work on. So it needs to be calculated and checked for each row you access. Differently (and that's why I named it STATIC) is a WHERE condition that is independent of the rows you access.
We are ridiculously good at mastering data. The data is clean, multi-sourced, related and we only publish it with resulting levels of decay that guarantee the data is current. We chose the HL7 Reference Information Model (RIM) to land the data, and enable exchange of the data through Fast Healthcare Interoperability Resources (FHIR®).
Before we start with some intermediate and advanced topics, I would like to sum up some more general points. They are subjective, of course, so I will be happy to discuss them if you have other opinion or better arguments for any of them.
The list is not comprehensive and this is intended, cause I will cover some topics in future articles.
InterSystems team is heading to MIT's largest hackathon this weekend where we will introduce a tech challenge for hackers. We offer hackers to use IntegratedML or InterSystems Supply Chain Orchestrator in their projects in order to compete for some really cool prizes!
If you are in Boston and would be interested to be an InterSystems mentor at the event - drop me a line.
UPDATE: We have our amazing winners! Check out these projects:
Thanks to everyone who took part in InterSystems Challenge! Don't forget to join our Discord Server to stay in touch and receive notifications on upcoming InterSystems programming contests!
I am new to the developer community and i intend on writing a new article.
I have a few ideas on what to write but i need to know specifically what kind of content it has to be?
I do not want to update content that is not valid and waste the time.
Please let me know what kind of content am I allowed to post as it will be very helpful for this purpose.
Also if i post something and want to remove it i need to know how i could delete / remove what I have posted, or should I inform the relevant authorities if any on instances as such.
I and other developers want to know if do we need to ask permission for the creator to translate an article to portuguese? Sometimes we send a message requesting authorization, but we don't receive a answer, what we do?
I just met a personal challenge translating my article to French. Tough I had to learn it at school and could read and understand famous literature (Sartre, Molière, Mauriac, Proust, Saint-Exupéry, Anouilh, ...) I missed the specific terms used with ISC technology. Thanks to @Lorenzo Scalese my errors were corrected. But no dictionary was able to answer.
During my recent work on Tutorial - Working with %Query #1 I met a Class Property that is quite different from its same-named relatives. It is there since 'ever' but is rarely used, Related doc doesn't help so much.
Having developed systems using Caché ObjectScript and Ensemble on various projects over the last 4 - 5 years I'm considering trying for some certifications. I've found details of the Caché Systems Administrator and Caché Application Developer certifications but have a couple of questions:
1) Is there a certification for Ensemble Application Developer?
2) Are any sample questions and/or practice exams available?
we are trying to access a windows file server from our file adaptor, which has been setup using a Linux CIFS mount The mount requires a user/password to access the files on the windows server. How do we get the integration engine to pickup the right username/password?
https://www.youtube.com/embed/y2hMiFBC-p0 [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]
We have a application currently running on Zen framework, now business wants to use Angular JS as their front-end technology for any future release but they don't want to upgrade the existing the modules which are already there in Zen (as of now).
https://www.youtube.com/embed/PnguSWTGngw [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]
Before I begin my writing journey here I wish to introduce myself briefly, so that everyone who reads and follows me will get a clear picture.
To start with I did my Bachelors in Physical Sciences, Mathematics and Computer Science were my core subjects. I have 4+ years of experience in HealthCare Revenue Cycle operations including Medical Coding, Billing, AR Collections, Denial Management and Fincial Reconciliation. Also, 2+ years of experience in Data Operations and Analytics, specifically in Python, PowerBI, SQL and MsExcel.
Hi everyone, I am trying to create a listen server in Cache 2016 that can capture data from a specific port. Can someone guide me on how to set this up, including handling incoming connections and reading data from the port? Any advice or example code would be much appreciated!
I want to deploy Iris Interoperability Production in multiple containers . The production has File Services that process files from EFS location. All the files being processed by multiple containers are in the same directory. The standard Adapter class does not have Check Complete option to lock a file so that other containers File Services looking in the same file path cannot process the same file.
I updated the Inbound File Adapter class to offer another Check Complete option LOCK that will lock the file until it is processed and archived.
During the last weeks, I was working on various issues and problems related to SW development. I found that quite often problem analysis was mostly chasing issues just on the surface but not really attacking the deeper reasons of the problem and follow the consequences. It's like the doc that stops your leg bleeding but doesn't see that it is broken.
I have a question about something in Studio that has been bugging me for a while. Why does the font of some items in the Classes treeview (View > Class View) appear in italics whilst others do not?
I want to get rid of this account but there seems to be no way to do this by myself. Whom can I write to, to have my account deleted? Thank you in advance...
Presenter: Andreas Dieckow Task: Apply SQL security to multiple servers in a distributed system Approach: Provide code samples for using new API calls to apply SQL security statements to multiple instances of our products
Description: The requirement that started at all. See examples on how to use this new feature and integrate it into your application by discuss code examples.
Problem: SQL Security is local to the instance and most of time driven by customer application code. That it is only local to the instance and is not automatically going to other instances requires a solution.
Solution: With application code use new API calls to issue SQL security statements that is applied to multiple instances.
Content related to this session, including slides, video and additional learning content can be found here.