Question Evgeny Shvarov · Jun 9, 2017

Caché Classes: How to Make a View on a Class to Manage Property Level Security?

Hi, Community!

Suppose I have class A with properties P1 and P2.

I want to introduce class B, which would have same records as Class A, but only  one property - P2.

What is the easiest  way to manage it assuming that I would like to use Class A to add records and be available for any operations to Users with Role A.

And I would like to introduce class B for Users with role B for read-only access.  Preferably they shouldn't even be aware of Class A and P1 existence .

What is the easiest way to introduce it and manage it?

Use some proxy-classes?  Property-level security?

Or to Introduce usual class B

#Caché #Data Model #Object Data Model #Security
10
0 814
Question Arockia Raj B · Jun 8, 2017

SQL Connect

How to simply going to get the value of the system language from ^%z?  Because  I got a problem, U2 context isn't setup while connecting the SQL Connect.

#Caché #SQL
4
0 450
Question Kishan Ravindran · Jun 10, 2017

How to Make a CSP Page With %CSP.Page Class?

Hi!

In the below code for cls with csp i have passed the output to a global but after i give the content in the text box it is getting stored, but when i check the global it is empty.

Class User.zkqr Extends %CSP.Page
{
ClassMethod OnPage() As %Status
{
&html<<html>
<head>
</head>
<script type="text/javascript">
function EmpTable(){
var EmployeeName=document.getElementById("ename").value;
var EmployeeNumber=document.getElementById("enumber").value;
var EmployeeDOB=document.getElementById("edob").value;
var EmployeeDOJ=document.getElementById("edoj").value;
alert(EmployeeName+"^"+EmployeeNumber+"^"+Employee

#Caché #CSP
4
0 707
Question Eduard Lebedyuk · Jun 6, 2017

Output 9876543210 without using numbers

Hi, Community!

Last weekend we held the Final of InterSystems Contest on InterSystems Caché and DeepSee as a part of IT Planet Student Championship in Sochi. BTW, this year we had about 2 000 participants in InterSystems Contest.

One of the tasks for the finals was to solve the following  with Caché ObjectScript and use the minimum code. 

Problem description

Write a method that would return the string 9876543210, however cls code should not contain numbers 0-9.

The goal is to write the shortest method.

Here's a method signature (it can't be modified):

ClassMethod main() As %String
#Caché #Contest #ObjectScript
23
0 1244
Question Stuart Byrne · May 23, 2017

Unable to Parse CSV from Business Service to Business Process

Dear All,

I’m having trouble creating the following business service.  It’s intention is to pick up an CSV via FTP and pass it to a Business process that transforms it to a HL7 message.

I have created a record map for the CSV file, which I am trying to call in the business service and parse it into a new message class, which can be transformed in the business process.

Please could you advise:

Business Service:

/// Collects CSV from Epic FTP, looking for ENH patient
/// antiobitic sensitivities to be passed on to ENH Infection control
/// Patch 176
Class CUH.Serv.EpicFTPFilePickup Extends
#Ensemble #Business Service #CSV #FTP
2
0 652
Question Stuart Byrne · May 4, 2017

Removing HL7 Searchtable entries

Hi,

I've built a custom HL7 searchtable, but wish to remove some of the items.

I've removed the items I no longer wish to index recompiled the custom searchtable, however the previous searchtable values are available when searching messages in the namespace.

Do I need to rebuild the index for this searchtable to purge searching the old values?

I have stop and started the production.

Regards

Stuart

#Ensemble #Message Search
2
0 461
Article Lexi Hayden · Jun 8, 2017 3m read

Using the OnGetNodeInfo callback of a Zen <dynaTree>

I needed to use the OnGetNodeInfo callback of a Zen <dynaTree>, because this seems to be the only way to control the style separately for different levels of the tree. This post describes two discoveries I made.

How a dynaTree builds a tree via the OnGetNodeInfo callback

When you use a dynaTree with the OnGetNodeInfo callback, the dynaTree creates a series of nodes and displays them top to bottom in the order they were created. 

The OnGetNodeInfo callback is an iterator.  To create the nodes, the dynaTree calls the OnGetNodeInfo callback, each time passing the variable pHandle to it.  Initially,

#Caché #ZEN #Caché
0
0 377
Question Arockia Raj B · Jun 8, 2017

COS Expression

What is COS Expression? Is the related to SQL Expression?

Can you give a basic code or query related samples? If anyone give a sample, it's understanding easily.

#Caché
2
0 550
Question Jorge Torres · Jun 7, 2017

"Sort After" ObjectScript Bug?

Hello experts,

I’m working on an "Sort After" (]]) bug that I traced back to some weird behavior in ObjectScript.  Perhaps someone can enlighten me…

The problem is as follows:

Let’s say we have:

Set A = “1.0”
Set B = “2.2”

If you execute the command ‘Sort After’ (]]), you get the following:

W A]]B
​1

…Which is wrong, A does NOT sort after B.  The output should be 0.

If you set A and B to numeric values, it correctly outputs false (0):

set A = 1.0
set B = 2.2
​W A]]B

0

I dug for a bit, and came up with this:   If you set  a numeric string to “<number>.0” an write the variable, it will be set as a

#Caché #ObjectScript
9
0 542
Article Sean Connelly · Jun 7, 2017 1m read

Cogs.JsonClass 1.0

The Cogs.JsonClass library is now available in the Cogs project on GitHub.

https://github.com/SeanConnelly/Cogs

Please see the README and the /docs folder on how to use the class.

Overview

The Cogs.JsonClass class provides a one step serialisation and deserialisation to and from Caché registered and persistent classes. It is not dependent on any other code and should be compatible with older versions of Caché.

The unit tests have been included in the update, but until I release the dependent Touchstone unit test solution it won't be possible to run these tests.

Please report any issues on the

#Caché #Caché #JSON #ObjectScript #Release
5
0 706
Question shobha rani · May 30, 2017

Performance testing in Ensemble

Hi,

Can you please help me to know if there is any performance testing tool for Ensemble production.

Requirement is  : I need to track the time consumed for conversion of message in BP , from the time the service picked the file from "In " folder and gives the response output file in "Out" folder.

Thanks ,

Shobha

#Ensemble
6
0 820
Question Lucas Scarduelli · May 30, 2017

Problems using Java Gateway with Caché 2016.1

Hi people,


I am migration my web application of Cache 2013 to Cache 2016, in Cache 2013 I have a integration with a Java aplication using Java Gateway mapping proxy classes and consuming a method that param is a object, and it works perfectly.

But in Cache 2016 this integration don't work, I send the param as object but Cache send as String with the ref of object...


I maked a test, importing two classes used by the Java Gateway (%Net.Remote.Proxy and %Net.Remote.Gateway) of the Cache 2013 to Cache 2016 and integration come back it to works, but I don't see significant changes to justify.


Someone

#Caché #Java #Mapping
2
0 522
Question Steve Pisani · Jun 6, 2017

Running the Management Portal pages over HTTPS

Hi,

I'm unable to locate a set of instructions that would allow me to encrypt the traffic to/from the Cache' Management Portal (that is - run it over HTTPS)

I am referring to the Management portal as hosted by the private Apache Web server instance installed with Cache. (I know how to do this for regular web sites hosted on, for example, IIS).

I would imagine the steps would involve, (a) enable SSL on that apache instance and (b) deploy certificates into the Apache web server.

Does anyone have a step-by-step guide on how this is accomplished ?

Thanks in advance - 

Steve

#Caché #Security #Management Portal
6
0 2355
Question Gaolai Peng · Jun 2, 2017

What is the max length of the content when resending a message

We have a service that sends XML message. During unit test, I tried to resend the message with following scenario:

(1) If I leave the content blank, the original message will be resent in the ContentStream;

(2) If I post a new XML message, the new XML will be sent in the Content, the original message will be resent in the ContentStream;

(3) If I post a new XML message with very big length, it will be converted to 5@%CSP.CharacterStream, and following kind of error will be thrown:

ERROR #6901: XSLT XML Transformer Error: SAXParseException: invalid document structure (Occurred in an unknown entity,

#HealthShare #Caché #Ensemble
1
0 647
Question Stephen Wilson · Jan 18, 2017

ZEN tablePane always selects the bottom row. Why?

I have a tablePane that always displays with the bottom row selected. The SQL is executed when the submit/search button is clicked.  See attached.

Does anyone know how to enable row selection but prevent the bottom row being selected after the button onClick event?

<tablePaneid="workBioTable"maxRows="1000" pageSize="6"width="1000px" showRowNumbers="false"showZebra="true"useSnapshot="true"extraColumnWidth="5%"
  initialExecute="false"sql="SELECT workbio.RequestDate, workbio.SpecId, workbio.Worksheet, %SQLUPPER(wsfbio.ProfileDescription) As ProfileDescription,
#Caché #Frontend #ZEN
5
0 474
Announcement Janine Perkins · May 22, 2017

Webinar Recording: Securing the Management Portal

Do you need to give additional users access to the Management Portal to help maintain and monitor your system? You may be wondering what’s the best way to:

  • Ensure all users have access to the information they need, when they need it.
  • Prevent certain users from seeing sensitive information.
  • Prevent users from editing something they shouldn’t.

Watch the webinar titled Securing the Management Portal delivered by Shane Rose, a technical trainer with InterSystems. Learn about the role-based security model, as well as how to give users appropriate access to different areas in the Management Portal and

#Learning Portal #Webinar #Security #Management Portal #Learning Portal
2
0 504
Question Tom McDevitt · May 26, 2017

Create schema independent DTL to add FTS segment

 I ike to create schema independent DTL to add FTS segment  to the end of a message. The problem that I see if do I need to loop each segment  to find the last segment ? Or is there a better way to do this?

ClassMethod Transform(source As %RegisteredObject, target As %RegisteredObject) As %Status
{

     set target=source.%ConstructClone(1)
     set FTSseg= "FTS||End Of File|"


ERROR
    quit sc
}
 

#Ensemble
1
0 508
Question Javier Gonzalez · Jun 6, 2017

Generic Class in COS

Hello everyone,

I'm doing a REST service for integration between 2 systems. The system that invokes me expects a response object where only one of its attributes changes. It could be something like this:

Class ResponseCustomer  {
    Property Code As %String;
    Property Info As Customer;
}
Class ResponseAppointment {
    Property Code As %String;
    Property Info As Appointment;
}
Class ResponseCancellation  {
​    Property Code As %String;
    Property Info As %String;
}

To avoid creating almost identical objects for each of the methods of my REST service, I had thought to implement

#Caché #ObjectScript #REST API
3
0 665
Question sam v · Jun 1, 2017

Use HTTP Request/Response in Ensemble Production

Hi,

We are trying  to feed in HTTP request & get HTTP Response in ensemble production.

From the below link  we got the code for HTTP Request/Response Example. while executing the code we are getting following error: "ERROR <Ens>ErrFailureTimeout: FailureTimeout of 30 seconds exceeded in Test.HTTP.Operation; status from last attempt was ERROR #5922: Timed out waiting for response​"

URL : https://sites.google.com/site/intersystemsensemble/code-collection/exam…

Could you please help us in this regard. 

Could you please guide us in Creating a new Ensemble Production

#Ensemble
2
0 1005
Article Chris Stewart · Apr 25, 2017 5m read

Let's write an Angular 1.x app with a Caché REST backend - Part 9

In our last lesson, we implemented a linkage to our WidgetAccessory class, and debugged some errors we encountered along the way.  We now have our data being returned by REST, but what if we want to update or add new data to our application?  

So far we have only used HTTP GET commands with our REST Services, we now have to implement PUT (which roughly corresponds to an Update) and a POST (which roughly corresponds to a Create.  Author's note: there is a lot of writing online about why this statement isn't entirely correct, I'm not going to go into the detail here).  However, before we start,

#Caché #Angular #CSP #JavaScript #REST API #Frontend
7
0 2599