Caché

Syndicate content 115 

Hi,

Cache Studio's inspector window can show me a Cache class's properties,methods parameters, XDATA blocks, Triggers, Foreign Keys, Queries and more, in a table in the Inspector window. Additionally, for properties, where the property accepts parameters, these parameters are listed together with possible value choices.

Last answer 31 May 2017 Last comment 1 June 2017
0 1
270

views

0

rating

Is there any methods/ways through which will get to know whether any of the Unit Test cases is/are failing in the Terminal with status as either 0 or False in case of Failure & 1 or Ture in case of Test Passes (we are getting an url of the csp page with the report which has the passed failed status) as we need to send this failure status to Jenkins for the Build to Fail (where in we have acheived this part in making the build failure/success based on  harcoded boolean)

Last answer 31 May 2017 Last comment 31 May 2017
0 5
295

views

0

rating

I need to execute a single csession command which calls a multi-parameter routine, such as ^SECURITY. This will be to do things such as create databases, resources, etc. (see below). When I run the command all at once, I get a PARAMETER error.

[user@host ~]$ csession INSTANCENAME -U %SYS "^SECURITY(4,1,\"testresource\")"
<PARAMETER>SECURITY^SECURITY

Last answer 30 May 2017
0 4
0

comments

267

views

0

rating

As Bill has mentioned earlier in his post, we have carefully reviewed the JSON capabilities and made some adjustments to ensure they deliver the best benefit to you. In this post, I am going to describe the modifications in more detail and provide guidance for you to understand the implication for your code base.

Last comment 30 May 2017
0 12
2456

views

+ 11

rating

I am inserting rows in a table. This table is appearing in all namespace as I did global mapping. 

So once I run insert command from a method, it insert the rows. When I run the same insert command from other namespace, it replace the existing data in table. 

Insert command is same in all namespace but the data I m inserting is different. 

 

Last answer 30 May 2017
0 3
0

comments

224

views

0

rating

InterSystems is pleased to announce the availability of the following maintenance releases:

  • Caché and Ensemble 2017.1.1
  • HealthShare Health Connect v15.021 on core technology 2017.1.1

Caché and Ensemble are available on the same platforms as 2017.1.0, except as noted below

  • The full list of corrections can be found in the release notes.
  • The version number of the kits for these releases is 2017.1.1.111.0
  • Oracle Solaris 10, 11 for SPARC-64 and Oracle Solaris 10, 11 for x86-64 are not yet approved.

HealthShare HealthConnect v15.021 on core technology 2017.1.1.111.

0 1
0

comments

227

views

0

rating

Hi!

I'm saving object instance using RestForms.

RESTFormsUI calls %Save() for me, which is great. But I want to set the property CreationDate with the current date for every new record being inserted.

So  object callback implementation seems as a reasonable option. I did the following:

Method %OnBeforeSave(insert as %Boolean) As %Status [ Private, ServerOnly = 1 ] 
{

 if insert s ..CreationDate=$H

 q $$$OK

}

And it works fine.

But Documentation says I'd better use %OnAddToSaveSet()

What are you using for the callbacks in similar cases?

Last answer 26 May 2017 Last comment 26 May 2017
0 7
258

views

0

rating

In Cache 2013.1.6.950.1 I have a ZEN dataGrid which works fine except if I use the mouse wheel to scroll through it.

If you use the mouse wheel (rather than the scroll bar) to scroll to the bottom of the grid and then click the checkbox against the bottom row it works the first time however if you then scroll back down the grid with the mouse wheel to the check box and uncheck it the check box will still be checked when you scroll back down to it and it only goes unchecked when you click in it a second time.  It works fine when the scroll bar is used. I have attached the code (cut down to show the problem) with some sample data. This code should be loaded in the USER namespace.

 

 

Last answer 26 May 2017 Last comment 26 May 2017
0 3
188

views

+ 2

rating

The Data Platforms department here at InterSystems is gearing up for this year's crop of interns, and I for one am very excited to meet them all next week!

We've got folks from top technical colleges with diverse specialties from hard core engineers to pure computer scientists to mathematicians to business professionals. They come from countries around the world like Vietnam, China, and Finland and they all come with impressive backgrounds. We're sure they will do very well this summer.

Rather than providing a set list of projects this year, Data Platforms interns will be developing their own projects which satisfy a short list of requirements. I can't wait to see what they come up with!

For an idea of what to expect, check out the white paper attached from my group last year who ported Deep Feature Synthesis research done at MIT for SQL platforms to Caché. Sarat Vysyaraju and Ryan St. Pierre did me and all the other mentors who provided guidance proud

0 3
0

comments

282

views

+ 6

rating

Hello,

I’m creating a REST API service but I need to convert my object in JSON.

The Class “A” is extended from another Class “B”:

Class message_B Extends Ens.Request
{

Property ClientId As %String(MAXLEN = "");

Property mesagge As %String(MAXLEN = "");

}
Class message_A Extends message_B
{
Property idDate As %String;

Property Datetime As %String;

Property time As %String;

​}

When I use:

set pRequest = ##Class(message_A).%New()
​do ##class(Ens.Util.JSON).ObjectToJSONStream(pRequest, .content)

This convert all properties  (A y B), but I want that only convert properties in A. I mean, in JSON appear all property, incluided ClientId, mesagge, however I want that this varibales not appear in my JSON.

How can i do ?

Last answer 25 May 2017 Last comment 25 May 2017
0 3
611

views

0

rating

Suppose I have a web application named "/my/api", with a dispatch class configured (a subclass of %CSP.REST), and I want to be able to respond to:

GET /my/api/something/:id

by loading an object with the specified ID and returning it as JSON

GET /my/api/another-thing/data.js

by returning the contents of a file (data.js) in a configured location in the filesystem, ideally based on the "CSP files phsyical path" for /my/api. (The thought is that at some point in the future the dispatch class might change to do something more complicated server-side, and that it would be nice for such a change to simply be a matter of code rather than system configuration.

Last answer 24 May 2017 Last comment 24 May 2017
0 4
447

views

0

rating

Since most of our customers moved to Caché 2015.1, some admins became abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

          CPUPct              job_type             CPU usage (percent) by all processes of the listed job type in aggregate       

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert? 

Checking the latest docs showed that the description of CPUPct was excluded from it, while the object still exists (at least in 2017.1.0)

Last answer 23 May 2017 Last comment 24 May 2017
0 2
270

views

0

rating

We have multiple server and multiple namespace. 

 

I have a script having sql query  which fetch data from current  namespace of a server. 

If I want to run the same query on different server to fetch data, but I want to run that script on just one server for all server. 

Please let me know how can I proceed. 

Last answer 23 May 2017 Last comment 22 May 2017
0 2
224

views

0

rating

From a browser, an XMLHttpRequest to a CSP page on a different server will obviously hit the CORS security check.

To get around this I can set the Access-Control-Allow-Origin header on that particular CSP class.

However, setting any request headers on the XMLHttpRequest object will trigger a pre-flight OPTIONS request.

This OPTIONS request is not handled by the target CSP page and the Access-Control-Allow-Origin header is never set, triggering a CORS error.

I can see in the new REST class that it can get a handle on the OPTIONS request but standard CSP pages don't seem to get them.

Are there any solutions for doing this in standard CSP such that it will work with older versions of Caché?

It currently feels like the answer is no, so I am looking at JSONP as an alternative, but would appreciate if anyone has managed to solve this without a hack. I also want to avoid using a proxy which is what I normally always use.

Sean.

Last answer 23 May 2017
0 3
0

comments

230

views

0

rating

I need a trick to display the cellTitle for just ONE column in a tablePane with a unique value.  Here are the issues:

1. OnDrawCell has access to the cell data for that row/column, in %query(pName),  but setting the cellTitle property to a column doesn't refresh the column object

2. Setting showValueInTooltip is good for the entire table, not just one cell

3. ** the column element does not evaluate zen expressions, so I can't say cellTitle="#(%query.Comment)#", for example.  That's the crux of the problem.

 

Last answer 23 May 2017
0 3
0

comments

185

views

0

rating

Hello.

I would like to know if there's a way to batch a certain amount of writes done inside a job and display it sequentially on the main process.

My idea is to prevent the main process from freezing while displaying the batched data. The main process's device could be

the terminal or the Studio output.

%Studio.Debugger does something close to that when printing the output from the debug target process.

$System.Event.Signal($zparent) doesn't signals the parent if a device is open. So I can't create the batch buffer along, because I can keep the buffering device open and notify the main process.

I tried using  an IJC device, but I couldn't get the buffered data back from the writer device using the reader device.

Also what does ChangePrincipal ($zu(132)) do?

Last answer 22 May 2017 Last comment 23 May 2017
0 0
358

views

+ 1

rating