Hello everyone.

I'm new to Caché.

I would like to know how I can connect my PHP application to the intersystems database.

Is it the same as MySQL?

Need help.

Thank you

Hi community,

I do not understand why I get a 'javaScript exception'?

Purpose is to search for a [Country] based upon a [Code] as search parameter.

this is my code:

<hgroup>
<text id="CountryID" name="Code" label="Code" size ="8" />
<spacer width="5"/>
<text id="CountryName" name="CName" label="Country" size ="24" />
</hgroup>
<spacer height="5"/>
<button caption="Search" onclick="zenPage.searchValue();"/>
</page>
}
ClientMethod searchValue() [ Language = javascript ]
{
var ctrl = zen('CountryID');
tVar = ctrl.getValue();
alert (tVar); ///test-show text value
zenPage.

Recently I have encounter an issue to get the columns out from a query without execute it.

For example:

I have a Query looks like below. How can I get the 'col1,col2,col3,col4' or the text of the query("select col1,col2,col3,col4 from mytable") back?

Query myquery() As %SQLQuery(CONTAINID = 0) [ SqlProc ]
{
 SELECT col1, col2, col3,col4
 FROM  mytable
 }
 

It is taking several hours to read  a large text file because the while loop uses ReadLine() !  Is there some way in Cache to  process a single file using multiple processes. Something comparable to this:-

http://stackoverflow.com/questions/11196367/processing-single-file-from…

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016.  However, we're on version 2014, and that method does not seem to exist yet.  I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014.  I don't want to have to go through and get all the properties manually, but I will if I must.  Any other good way  already written?

Thanks,

Laura

Hello All,

I have a question / issue regarding the calling list.FindOref(<object from indexOpen call>)
Here is a simple way to reproduce the issue: 
2 classes: Utility.contacttypes and Utility.person
*************************

Class Utility.contacttypes Extends %Persistent
{
Property description As %Library.String(TRUNCATE = 1);
/// Index for property description
Index descriptionIndex On description [ Unique ];
}

*************************

Class Utility.person Extends %Persistent
{
Property types As list Of Utility.

Most viewed

This post is a digest of the Developer Community postings in April 2017.

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

Compilation gotchas and a request for change  250

Bug killing development tips  175

Let's write an Angular 1.x app with a Caché REST backend - start here  125

WebSockets vs Long Polling vs Short Polling?  122

Authentication with REST  114

Containerization Caché - let's add our application  108

Node.js: create a basic web app with React - part 1  101

Is it possible to change GUID of an instance?  98

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

Hi,

I would like to list out unchecked mapped items ( classes in management portal )  classes of a particular namespace. Is there any code or terminal command which i can use ?

I am able to list out classes of namespace . But I need to list out unchecked mapped items classes

do ##class(%SYSTEM.OBJ).GetClassList(.result)

Hi,

I would like to know if there is any code to compare and update two directories/namespaces for class files.
If file is present in directory1 and not present in diectory2, it should import the classfile.
If file is not present in directory1 and it is present in directory2, the corresponding file should be deleted from  directory2.

Please suggest code for the task.

Thanks,
Arpitha R

Something that shot up the popularity stakes last week was this article on a very interesting initiative: RealWorld:

https://medium.com/@ericsimons/introducing-realworld-6016654d36b5

I decided it would be a good idea to use this as a way of creating an exemplar implementation of a RESTful back-end using QEWD against their published API (https://github.com/gothinkster/realworld/tree/master/api)

The results are here:

https://github.com/robtweed/qewd-conduit

Actually it's the first 3rd-party implementation out of the blocks!

Hi Community,

I'm just editing a class in Atelier. I have added below code into the class.

Set tStream=##class(%Stream.GlobalCharacter).%New()

When I type tStream. , It's not automatically suggesting properties of that object instance in Atelier. If I click "Ctrl+Space", It says "No completions available". 

Is this functionality not available in Atelier yet Or Should I make some configuration changes in Atelier to make it available?

I'd like to have production specific settings for different environments (OTAP). I have set the system default settings on my production to override the default settings. However, this does not seem to work. It is my understanding that the system default settings override the settings I have set on the production (I thought I heard my Sales Engineer say this). However, reading the documentation I am not sure of this reading either. However, when I clear the values for the adapters on my production my system default settings are still not apply.

Is there any good book where is described process of mapping globals to classes? And book about Storage? 

I didn't find much information about these questions in documentation :-(

Greetings.
I'm trying to do some experiments using the Atelier REST API, but I noticed a bug that I simply can't bypass.

When requesting the Atelier server asking for an array of docs, it seems to fail when using it with multiple formats.
Like: [ "RCWWW015.int", "Class.cls" ]
While this method does return the class's source code, it fails when fetching the routine.
Like this:

      {
        "name": "RCWWW015.int",
        "db": "DEV",
        "ts": "2017-01-24 11:37:05.851",
        "upd": true,
        "cat": "RTN",
        "status": "ERROR #5001: Missing Source for Document: RCWWW015.

Using the CSP Gateway is there a  way for an web application to mimics MLLP sockets connection? I have a requirement for no PHI in the DMZ and I wanted to see if there is a way to install the CSP Gateway in the DMZ to received inbound/outbound messages where the DB is in the protected zone.

We at George James Software are pleased to announce the release of version 2.6 of Serenji, our editor and debugger for Caché, Ensemble and HealthShare.
The main enhancement in 2.6 is the ability to run on a Linux <edit> or OS X </edit> workstation using Wine 1.8. More release details are here.
This is a free upgrade to users already holding an activation key. For new users a free 30 day evaluation period is granted upon installation.
John Murray
Senior Product Engineer
George James Software

What is a correct way to pass parameters to the  %CONTAINS in embedded SQL statement when searching thru %Text property?

s sp="child,health"

&SQL(

DECLARE c1 CURSOR FOR

SELECT ID INTO :id FROM ICD WHERE Name %CONTAINS (:sp)

...

is not the same as executing the following in the SQL Manager

SELECT ID FROM ICD WHERE Name %CONTAINS ('child','health')

Hi ,

From the below code, we are able to import the class file to the namespace ( specified path is C:\temp\distr ) 

I have a class file and a folder in the above specified path. When i run the code, it is importing only the class file but not the class files present in folder. 

I would like to know is there any code to import the class files present in folder as well. 

Include %occInclude

Class User.InsClass
{

/// You can see generated method in zsetup+1^App.Installer.1
XData Install [ XMLNamespace = INSTALLER ]
{
<Manifest>
    <If Condition='(##class(Config.Namespaces).

How is the security handled in intersystems for GUI and web services testing part ? Does it have inbuilt security handling packages ? what are the limitations ? Please enlighten.

Hi All -

Our environment has multiple instances of HealthShare installed and most are on separate VMs/servers. Does anyone have any ideas on how to efficiently manage user accounts across all of these multiple instances of HealthShare? As you can imagine, creating 10 separate Cache accounts on each instance during onboarding of new associates is cumbersome and tedious as is disabling them. We have yet to integrate with AD but we do have a Cyberark initiative under way but it is in the very early stages.

Hello,

I am interested in working with a third-party API in my instance of the Community Portal.  I was curious as to how you all work with third-party apis.  Do you typically connect directly from within a ZEN Mojo Page or do you route the request through an operation in the management portal?  Are there any sort of best practices I should be aware of?

Thanks,

Bob

I am new to Intersystems and I am wondering if there exists a NYC tri-state regional or NE regional group for Ensemble?

If anyone has any information, please reply.

Thanks,

George Cornejo

NYC Health and Hospitals Corporation

55 Water Street

NY, NY

Please let know if it is feasible to integrate Security tools ( W3af and Iron Wasp ) with intersystems. If so, please let know how to do that..

I want programmatically select last added row in tablePane. How I can do it?

I am using a method: %OverrideGuidAssignment("NEW GUID HERE") to override my GUID, and would like to know if there are any parameters, which allow this method to return a status & or error msg? If you currently set it to a variable it returns the new GUID you originally passed in, regardless of if it failed to override or not.

Thank you in advance

Suppose I have an image and need to convert that image into a PDF for inclusion in an HL7.

I know that Zen Reports can display an image in a PDF but I do not want to view the image in a web page. I just need to convert the image to PDF in a Process and then include that PDF in an HL7. The  workflow would be like this:

Get image -> Convert image into PDF -> Include PDF in HL7 OBX.

I know how to do the last part to include PDF in HL7 OBX. Just need ideas on the first part.

let know the source code to fetch files from git hub repository..while running the attached file we are getting error. ERROR #5001: Repository doesn't exist OR you don't have accesscoming1 1

Please help us to resolve the error.

Please find the code used :

Class Util.download Extends %Persistent
{

ClassMethod Update(Owner As %String, Repository As %String, Branch As %String = "", Username As %String, Password As %String, Namespace = {$Namespace}) As %Status
{
	write ! , Username
		write ! , Password
    Set req = .CreateRequest(Username, Password)
    write !

In our last lesson, we added some formatting and validation to our Edit Widget form.  So, now we are ready to add the ability to add new Widgets to our application.  However, the great Widget Wars have come to an abrupt end, as Widget Direct has purchased its biggest competitor, WorldWideWidgets.  In order to maintain some continuity, we need to display their catalog on our new application.

So, we have good news and bad news.

It's almost a year since I have published a series of articles explaining how to configure Cache instance as a client / resource server / authorization server. By that time, the implementation of OAuth 2.0 was still a pre-release software.

With the advent of Cache version 2017.1 a lot has changed. OAuth 2.0 implementation is fully completed and supported. Numerous new features were added (e.g. dynamic client registration)  - see release notes here for full details - and configuration pages have been redesigned to a great extent as well.

In our last lesson, we added a form to Edit our existing Widgets, and save them back to the server.  However, our Form was not well structured and our Save button had no intelligence, and was not fully visible.  So today, we will apply some Material components and Angular style to make the form more useful

Let's open EditWidget.csp, and make some changes.  First, we want to change the component from an md-card to an md-dialog.