June 25, 2018 – Alert: Outer Join Query Results
InterSystems has corrected two defects that can cause SQL outer joins to return incorrect results. These defects can also impact DeepSee in Caché and Ensemble, as well as InterSystems Business Intelligence in InterSystems IRIS; in these cases, building and synchronizing some analytic models may result in build errors.
These issues exist on all platforms for the following released InterSystems Data Platform products:
When I down load a file using a csp page, the application shows the percentage as 37 %, 74 %, and 100 %. I am trying to make changes to the application that it shows one percentage after each read. The first time it reads, it would display 37%. The next run would replace
37 % with 74 % and so on until it completes its download. I have tried adding javascript code to the application however it doesn't work. For example when I enter &js('alert');, the application displays it value on the screen. Also, I tryed putting it between two scripts tags and it doesn't work.
I have a need to restrict some developers access to Message Viewer in a namespace without restricting their ability to create or modify productions components. Is there a way to do this? It's not clear from the documentation.
Hi Community!
As you know we have Global Masters program — InterSystems Data Platform Advocacy Hub.
All Global Masters members (Advocates) can achieve various levels of advocacy which depends on contributions on Developer Community and activity in Global Masters.
Every new level opens new type of challenges/tasks and new types of rewards.
We are excited by how engaged you are with Global Masters but realised that we have a really great gap between initial level Insider and the next level Specialist. Indeed, Specialist level demands really great achievements: 10 articles, 10 questions on DC, article with 1,000 views.
So we introduced a new level of advocacy with name "Advocate".
See the details below.
Hi Everybody!
We are pleased to invite you to the upcoming webinar "Optimizing Application Performance" on 29th of May at 10:00 (Moscow time)!
A unique chance to talk about application performance.
Hi Community!
InterSystems Global Summit 2018 is approaching fast!
We've just introduced 3 new rewards exclusively for members of the InterSystems Global Masters Advocacy Hub!
Check out new Global Summit 2018 Rewards below!
I'm facing a specific sort problem.
There are several thousands of articles sold all over.
Users expect to get a description in local language sorted by their specific collation.
Hi folks,
One of my clients want to project a null property of a cache object to an empty XML element. Say, if we have a class:
Class Diabetes.BS.Message.LabReportMessage Extends Ens.Request
{
Property Report As %String;
Property IsRisky As %Boolean;
Property RiskValue As %String ;
}
If the instance of this class has a null RiskValue, after projection, they want the XML as following:
<LabReportMessage>
<Report>Somestring</Report>
<IsRisky>1</IsRisky>
<RiskValue/>
</LabReportMessage>
Is there any way we can do it? Thanks.
Hi Community!
New video "Treating Patients with REST and iKnow" is available now on DC YouTube Channel:
I have a CACHE.DAT file that is working under CACHE version 2015.1.0.429.0
I have a second machine with CACHE version 2017.2.0.741.0
When I attempt to add/use the CACHE.DAT in the new version of CACHE, it will not mount.
How do I upgrade/convert the DAT file to make it work under the new CACHE version?
Thx. Larry...
Hello Community :)
I am currently creating some documentation for my team. I need to show every connections between my business process, business services, and operations . All I can have is only one link like this screenshot :
Do you know any way to show every links, or to get a good visual documentation ?
Thank you in advance, have a good day Developers !
Hi -
I'm working on a project that will be dealing with depression screening and I'm not certain where any of this information would belong in the HL7v2.x world.
Can anyone suggest what the proper placement of "has this person been screened" and if so, "this was what the screening showed"?
At first thought I was thinking that this is an "Observation" of some sort (and ORU message) for the "what the screening (or perhaps testing) showed", but I'm not sure if the screening was performed yes/no qualifies as an "ordered test".
Just looking for a starting point I guess. Thanks
Has anyone built tag cloud from iKnow domain?
If so, any advice on how to do that?
Hi
number - @''"
Hello,
I used the operation : EnsLib.EMail.AlertOperation to send mail to handle error. However, I want to get more information about the error (session ID message, the date, the namespace... etc).
what is the best way to do it?
I tried to add informations in OnAlertRequest method as below but I need to change mail operation from all namespaces...
I have iKnow domain with 1 source, 1 data and 1 metadata fields. Source is a table.
Let's say individual rows are immutable, but new rows are added after the domain is built.
How do I add them to domain?
In %SYSTEM.iKnow class IndexTable method is available:
classmethod IndexTable(pDomainName As %String, pTableName As %String, pIdField As %String, pGroupField As %String, pDataField As %String, pMetaFields As %List = "", pWhereClause As %String = "", pConfig As %String = "") as %Status
Assuming I have a table App.Text with fields:
Hi, Community!
Hi Community!
Come join us on Developer Week in NYC on 18-20 of June!
InterSystems has signed on for a high-level sponsorship and exhibitor space at this year's DeveloperWeek, billed as "New York City’s Largest Developer Conference & Expo". This is the first time we have participated in the event that organizers expect will draw more than 3,000 developers from 18th to 20th June.
1) I have an oref pointing to an object on disk
2) I save the object which causes an UPDATE / AFTER Trigger to fire, and updates a value in an embedded object property
3) I would like to see that new embedded property value in my in-memory object (for unit testing)
Is there a way to do this via a method call? Or do I need to close the object and re-open it to see the updated value?
Thanks!
Ben
Hello,
I want to convert a json, which passed on in the a REST call, into a request message.
I use method %ConvertJSONToObject of the %ZEN.Auxiliary.altJSONProvider class.
Set sc = ##class(%ZEN.Auxiliary.altJSONProvider).%ConvertJSONToObject(%request.Content, "TestRequest", .request)
Is there an alternative for this? I want to avoid to use the %ZEN library.
Best Regards
Roger de Coninck
I have iKnow domain of forum posts, their full text is an iKnow data, and each post also has a number of views as a metadata field.
I want to get a sum of views by concept. Let's say I have a concept called "TESTEST" and there are 10 sources that have this concept. Each source has some views. I want to get views total - impact of this concept so to say.
What's the best iKnow architecture for this use case?
So far I got this:
I need to do an ordering, within another order, but it is not ordering.
Hi,
While accessing Trakcare in IE 11 i am getting error:
The Trakcare Layout Editor is not functioning.Please check your browser security setting for scripts and ActiveX controls.You must have ensemble installed locally to use this application.
I have an iKnow domain and a blacklist called Ads.
I want to get all sources that do not contain entities from Ads list.
Currently I'm doing it like this:
Let's say I have a user-generated document template with placeholders and I want to replace them with actual values.
Values could be:
So far I wrote a simple find/replace tool that works with RTF format (because it's not a binary format), here's how it works:
set template = "D:\Cache\RTF\template.rtf"
set var("%title") = "Hello"
set var("%table") = $lb("Utils.RTF", "TestFunc")
set result = "D:\Cache\RTF\out.rtf"
set sc = ##class(Utils.RTF).replace(template, .var, result)Question:
How can I get a value of a setting of a Production item programmatically?
Answer:
You can use one of the API methods of the Ens.Director class, for example:
Ens.Director:GetItemSettingValue()
For example –
In the Production Demo.Workflow.Production the item (Business Operation) 'Demo-Development' has an 'Auto Create Role' setting:
Clicking on the Settings Defaults button you can see this is a 'Host' setting:
And you can access the value using this call for example:
ENSDEMO>write ##class(Ens.Director).GetItemSettingValue("Demo-Development","Host","AutoCreateRole",.status)
1I have a serial object:
Class EmbedObj Extends %SerialObject
which is stored as a property of another object
Class ContainerObj Extends %Persistent
Property InnerObj As EmbedObj;
Property Foobar As %String;
Question:
From within the context of an instance of EmbedObj, how can I navigate to the containing instance of "ContainterObj" and find that value of its Foobar property?
Harder Question: Is there a way I can do this as part of SQLComputeCode? (my EmbedObj has a Calculated property which now needs to depend on the value of property Foobar of the containing object).
Hello,
If this question is in the wrong section, I apologise.
Has anyone ever used Cache Object Script to connect to any hardware such as a sensor?
What I mean is this :-
Lets assume that code has been written in Cache Object Script where it can detect breaks in electrical connections.
I've set up a Ens.Alert routing rule and would like to route alerts to different email groups based on business partner or alert group instead of relying on source config using Document.SourceConfigName. Is there a way to reference the business partner or alert group property in a routing rule?
