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 %occIncludeClass User.InsClass{/// You can see generated method in zsetup+1^App.Installer.1XData Install [ XMLNamespace = INSTALLER ]{<Manifest><If Condition='(##class(Config.Namespaces).Exis

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.

Additionally - I would eventually like to do some reporting based off of specific roles with

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

Hi, Community!

Hope you know and use the Developer Community Analytics page which build with InterSystems DeepSee and DeepSee Web.

We are playing with InterSystems iKnow analytics against Developer Community posts and introduced the new dashboard, which shows Top 60 concepts for all the posts:

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 !,req
    //Set req.Location = "rep

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.  The good news is at that WorldWideWidgets also use Caché, but the bad news is that their Widget table has different properties with different names than our Widget class,

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 order to keep the series up to date, I have modified the

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.  We then want to wrap the content in a div so we can set the layout to "column" so the controls display in a vertical list, and also a Form which enables Angular to ver

I have a CSP page that needs to allow the user to submit a file.  I have a form with an element in it <input type="file" name="file"/> which allows the user to select the file they want to upload from their local filesystem.  

How do I go about actually getting the file to be sent to the server?

How can I do second dimension for the dimension, where we have comma delimited expression?

How about displaying a different icon alongside a question for which there is an accepted answer? Perhaps add a green checkmark adornment to the existing icon?

Take this online course to learn the basics of SAML (Security Assertion Markup Language), the ways in which it can be used within Caché security features, and some use cases that can be applied to HealthShare productions.

Hi

I have an Ensemble Application with many classes and relationships between those classes.

I need a tool that can connect to Cache/Ensemble and create a visual ERD from the class definitions within a particular Cache Namespace

MS-Access is one option but it does not automatically create the relationship connectors between classes

Any suggestions

Nigel Salm

Hi, Community!

Please meet  a new Developer Community UI release with new features and some bugfixes.

With this release we changed a color scheme to meet corporate colors more. 

We introduced browser notifications not to miss new posts on Developer Community. They would pop up only if you turn them on and only if you don't see the Community at the moment. 

Also we introduced the special inverse color for accepted answers. Like here:

Dear question authors! Please mark answers as accepted to make the world better (of course if there is an answer, you can accept).

We also fixed a few bugs.

Please pro

The colour scheme seems to have changed from green to blue, perhaps to be more in line with ISC corporate image.

Anything else new?

UPDATE: information has since been posted here.

I still find it odd having to go to the DC homepage to get the "Create a New Post" button:

because it's not there when I'm reading a specific group, e.g. at the URL https://community.intersystems.com/group/atelier

It's good to see growing participation in DC. However, sometimes I think that responses posted as Answers to Questions would be better classified as Comments. For example, the respondent could be seeking clarification about the original question (e.g. "What Caché version are you using?"), or perhaps following up someone else's answer or comment.

Hi all,

I've a RESP API service in a Business Service to server different methods

I've created the route with the name of the method, each one has been created in lowercase 

XData UrlMap [ XMLNamespace = "http://www.intersystems.com/urlmap" ]
{
<Routes>
    <Route Url="/user" Method="POST" Call="User"/>
    <Route Url="/emailactivation" Method="POST" Call="EmailActivation" />
    <Route Url="/login" Method="POST" Call="Login"/>
</Routes>
}

But only there is a response if the call is used in lowercase

http://localhost:57772/mynamespace/emailactivation

my question is, is it possible t

Does anyone have a good example of setting up an Inbound Email Adapter Service to retrieve an email? I am thinking of sending this email to a BPL to retrieve the Attachment that is in the email. Would that be the correct method to do that?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

How to integrate SoapUI with Ensemble or is there any other tools for automation testing that can be integrated with ensemble? 

Hi. What notifications are available, if any, when any part of an SDA has been modified (inserted, updated, deleted, etc...)?

Thanks in advance.

Hi, 

I can't work out how to use the Cache CA Server to process certificate request from external clients!

We are setting up an interface where we use SSL/TLS 'Mutual Authentication' to allow a client system to securely transmit document to  our server. (they are off-site and hosting a service for us)

I am not a security expert, but my understanding of setting up mutual authentication where my instance of ensemble is the server, and it is receiving messages from a client is as follows

1. I create a CA private key and self-signed certificate ( or purchase a cert from one of the big providers)
2. Generate

Created by Daniel Kutac, Sales Engineer, InterSystems

Part 3. Appendix

InterSystems IRIS OAUTH classes explained

In the previous part of our series we have learned about configuring InterSystems IRIS to act as an OAUTH client as well as authorization and authentication server (by means of OpenID Connect). In this final part of our series we are going to describe classes implementing InterSystems IRIS OAuth 2.0 framework. We will also discuss use cases for selected methods of API classes.

The API classes implementing OAuth 2.0 can be separated into three different groups according to their purpose. All classes are implemented in %SYS namespace. Some of them are public (via % package), some not and should not be called by developers directly.