How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total?

I have already used the wrench under Column Options as % of Total so, I can't use that option.

I am trying to write some code that takes in a string and does a serverside transformation of it to find embedded URLs and replace it with clickable links.   I found the following regex for Javascript which is rated highly on StackOverflow;

    replacePattern1 = /(\b(https?|ftp):\/\/[-A-Z0-9+&@#\/%?=~_|!:,.;]*[-A-Z0-9+&@#\/%=~_|])/gim;
    replacedText = inputText.replace(replacePattern1, '<a href="$1" target="_blank">$1</a>');

And I tried to do the following in Caché ObjectScript but it's not working:

set matcher=##class(%Regex.Matcher).%New("/(\b(https?|ftp):\/\/[-A-Z0-9+&@#\/%?=~_|

The >/</= etc. operands in named filters are great... except they won't work with measures ('native' or calculated - and what a boon it would be if  they could work with both). 

Are there any plans to add this capability?

And are there any plans to have a 'named filter' control within widgets that would let you change the operand?

Thanks.

I use Cache Instance. I'm trying to implement OAuth 2.0 in Cache instance.
Is it possible to use Cache instance as Client and Server?

And What is the Difference between CLIENT and AUTHSERVER instance?

Why is it used? I want to know which instance use which type of application?

1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

Thanks!

Has anyone ever worked with a load balance for ECP servers access? If yes, wich one? 

What are the pros and cons of such a solution? We use ECP servers as data servers via ODBC, thanks!

Suppose I find a post that seems really useful, and that I expect to want to return to in the future. I click on the star to favorite it (giving the author some kudos). But later there's a lot of commenting on it that I don't care about. Can I keep it as a favorite but unsubscribe from updates? Or should I resort to browser bookmarking?

I created the sample rest services in Cache, I also set output in JSON format.

Can anyone explain how to pass JSON in Rest Services using POSTMAN?

Thanks.

Hi all,

I've created a WebApi and I've deployed in our development environment. So we test calling http://localhost:57772/Client/login and it works.

Now, I wondering how to change the port to call in pre production environment.

I've changed the port in the business service object, but it is ignored.

Other workaround is change the WebServerPort in System > Configuration > Startup Setting but it changes for all environment (connect to managment portal, etc..)

Is there any way to change the port of the WebApi to redirect to 80 (for example) u other one?

Best regards,

Francisco

Hi

I need to process a very large Batch file which contains HL7 charges which we pull using FTP. I need to loop through the file and do some checks and then split the large Batch file in to individual messages. These individual messages then gets process through a different module to create a output batch of different format

I created a simple CRUD operation using Rest Services in Cache.

Class EX.example Extends %CSP.REST{XData UrlMap{<Routes><Route Url="/insert/:loc/:ssn/:name" Method="GET" Call="hello"/><Route Url="/update/:key/:loc/:ssn/:name" Method="GET" Call="iam"/><Route Url="/delete/:key" Method="GET" Call="there"/><Route Url="/findid/:key" Method="GET" Call="now"/></Routes>}ClassMethod hello(name As %String, ssn As %String, loc As %String) As %Status{s mName=$zcvt(name,"U"),mKey=ssn,mLoc=locs ns=$namespaceznspace "USER"try{s obj=##class(Sample.Classes).%New()s o

Hi all,

I have the following problem with a WebApi that I've developed in EBS.

I have a GET method that reads the parameters and puts into a message to process.

Class MyApp.BS.ServiceRestBase Extends (%CSP.REST, Ens.BusinessService)

XData UrlMap [ XMLNamespace = "http://www.intersystems.com/urlmap" ]
{
<Routes>
<Route Url="/login" Method="GET" Call="Login"/>
</Routes>
}
/// Login
ClassMethod Login() As %Status
{

// Get the parameters
set login = %request.Get("login")
set password = %request.Get("password")
set app = %request.Get("app")
....

}

The password is a value in Base64, if I call the WebApi with the fo

I'm trying to implement Crud operation in rest services.

I'm confused about this implementation. 

Is it possible to call rest services method in CSP pages?

If not means, can you tell me another way?

I need some examples or reference to implement Crud operations.

Thanks

Hi, I tried the new rest file in User namespace. But I couldn't run it.

Here the Code:

Class com.Testing Extends %CSP.REST{XData UrlMap{<Routes><Route Url="/insert" Method="POST" Call="one"/><Route Url="/print" Method="POST" Call="two"/><Route Url="/update" Method="POST" Call="three"/></Routes>}ClassMethod one(){Write "This is 1st Method!!"Quit}ClassMethod two(){Write !,"This is 2nd method"Quit}ClassMethod three(){Write !,"This is 3rd Method"Quit}}

I tried it in the below link:

http://localhost:57772/csp/user/testing/insert

As more people join Developer Community, and with increasing efforts to promote code sharing, I'd like to draw fresh attention to this post I wrote a year ago. It spotlights a feature within the class compiler which is both useful and dangerous. When importing code (e.g. from an XML export of classes received from someone), it's worth considering the risks.

Even if that post doesn't seem relevant to you at the moment you may wish to note it for the future. A handy way of doing this is to click the star icon at the end of it.

Our client is a test out of 2016.1 (Build 656U) Healthshare that wants to do a one way SSL connection to our Java 1.7/Tomcat 8.0 server.  We have yet to come up with a secure cipher set that Healthshare and Java agree on for the handshake.  So far we've had to use these ciphers identified which are not recommended (though it does do a handshake properly).  Our definition of "secure cipher set" comes from this best practices section 2.3 and ideally we'd like to use the ciphers identified.  Are any of these available in HealthShare 2016+?

Our setup:  In Healthshare, we have an SSL/TLS configura

When the Group field on the Create Post page was a list, if I started my post from a group's homepage such as https://community.intersystems.com/group/developer-community-feedback then this group was preselected.

Now that the Group field is a set of radiobuttons I have to select the group.

Is this a bug or an intentional change?

I have flagged a couple of posts as favorites. Here's how they appear at the bottom of the right-hand column when I'm on the DC homepage:

Is it deliberate that the obscure the start of the post names?

Apparently if I pose a question (like this one) and subsequently discover an answer, I can't add that as an answer. I'd have to resort to a comment on the original posting, or editing the original posting.

After the March 15th DC update I posted one Question (as opposed to Article). I've been used to getting notified by email no more than an hour after someone responds to a post of mine. In the case of my question, I think I only got that email when someone posted a Comment on the question. When I went to read that comment I saw that there were several Answers that had been posted many hours earlier.

It's possible I overlooked earlier notification emails, so part of the purpose of this question is to act as a test. Please don't add a comment to the question. Instead, add an Answer. If I get notif

If your Ensemble environment is actually a HealthShare one, here's a snippet of information that I wasn't able to find in the documentation.

When a namespace is HealthShare-enabled it gets some mappings added to it in order to fetch stuff from the HSLIB database. The most obvious mapping is a package mapping that gives your namespace all the HS.* classes.

Far less obvious is that your namespace will also be fetching/filing Test.* classes from the HSLIB database. So if you thought that, say, Test.MyExperiment was a good name for a little class you wrote in order to try something out, beware that

This is the code here:

I got error in form tag declaring

Can anyone help me to resolve this error!!

Any recommendations, to this VMware disk type debate, with Cache installations in particular?

Thick Provision Lazy Zeroed

Thick Provision Eager Zeroed

Thin Provision

Hi, Community!

Please see the digest of Articles and Questions published in February 2017.

Most viewed

Part II – making community package manager  250

Converting documents with Caché and LibreOffice  160

Using InterSystems Caché and Apache Zeppelin  132

Making encrypted datafields SQL-searchable   131

How Intersystems Caché fits in the Graph Database Arena !  117

Can you keep a secret?  109

Creating custom SNMP OIDs  104

Notepad++ Language Pack for COS?  103

Scripted/Automated Production Deployment?  98

Local instance caché 2016 messed up; server availability error  97

Most voted

Using InterSystems Caché a

Hello. New to the forum and was hoping I could get some expert help here. I have one data set that is using CHD Logic to combine Procedure and Diagnosis codes to define Sensitive data and flag the record for additional protected filtering. The files coming in define what is flagged and the Clinical Info Rule and Clinical Info Type are tied to the flag in the file which identifies it as a additional protected record.

Now, I would like to enhance that and have been investigating how to use Clinical Info Rules, Types, Consent Rules and Consent Groups to now filter on the other data sets coming

Hi, Community!

We have a new release here!

What has been introduced:

1. Better notifications

With this release I hope you will turn on back the email notifications because every new notification today in the beginning of itself will tell first, why did you get it describing the exact reason you got this particular notification.  And if you don't want this type of notification to be delivered anymore click unsubscribe link in the notification and it will lead to the settings of this very type to alter.

Also, I can indeed recommend digest mode (Use Subscriptions/Overview to turn it on). 

It sends you

Hi!

Consider I have a class Package.Data with Property UniqueStringValue as %String.

I introduced the Index for this property:

 Index ValueIndex on UniqueStringValue [Unique];

It works well.  But if I try to check if there is an object with the certain value in code like this:

if ##class(Package.Data).ValueIndexExists(value)  

this expression fails, if value="value", even if there is an instance with instance.UniqueStingValue="Value"

How can I set the index to prevent saving case sensitive values in this class?

I am having a problem getting pair key authentication to work on my local PC. I am using freeSShd as the SFTP server. I generated private and public keys using putty gen . I used these keys to successfully log into the root directory using both Winscp and Putty. But this is not working with an FTP Operation. Below is the error that results. freeSSHd server log shows that I log in but immediately disconnect.

I am working on HS2015.1.1 Please help !!

failed for localhost:22/SFTP/SSL='!SFTP'/PubKey='C:\Users\myhiddenusername\KeysForFreeSSHd\myhiddenusername'/PrivKey='C:\Users\myhiddenusername\Priva

Hi!

There is an option to introduce Named filters in Analyser and save it with the pivot.

How can I make the Named filter available in a dashboard?

The recent announcement of a collision for the SHA-1 hash algorithm has caused some consternation:

https://shattered.io/

Here is some background to help put this in perspective.

Cryptographic hash functions can have a variety of properties.  The property at issue here is:

"Collision resistance - it is computationally infeasible to find any two distinct inputs x, x' which hash to the same output, i.e., such that h(x) = h(x')."

(Menezes, van Oorchot, and Vanstone, "Handbook of Applied Cryptography", section 9.2.2)

What properties are required depends on the application for which the hash function is u