Overview

Encryption of sensitive data becomes more and more important for applications. For example patient names, SSN, address-data or credit card-numbers etc..

Cache supports different flavors of encryption. Block-level database encryption and data-element encryption. The block-level database encryption protects an entire database. The decryption/encryption is done when a block is written/read to or from the database and has very little impact on the performance.

With data-element encryption only certain data-fields are encrypted. Fields that contain sensitive data like patient data or credit-card numbers. Data-element encryption is also useful if a re-encryption is required periodically. With data-element encryption it is the responsibility of the application to encrypt/decrypt the data.

Both encryption methods leverage the managed key encryption infrastructure of Caché.

The following article describes a sample use-case where data-element encryption is used to encrypt person data.

But what if you have hundreds of thousands of records with an encrypted datafield and you have the need to search that field? Decryption of the field-values prior to the search is not an option. What about indices?

This article describes a possible solution and develops step-by-step a small example how you can use SQL and indices to search encrypted fields.

A feature I recently used in working on ISC internal applications is the ability to send emails on behalf of someone. This is useful when generating system notifications from an application when you want some of them to show up as being from a specific person, perhaps posting comments on a work ticket.

In my case I was updating our facilities work order system for tracking requests. Normally all notification emails are sent from the same noreply email address. I wanted to change that so comments added from the original requester would show up as being from them and stand out.

Hi,

Any COS API could detect the underlying system is supported unicode or not ?

Thanks for your help.

I have a tablePane ZEN Component and I am trying to get a filter running on the Specimen Id / Lab Number. The SQL is fairly complex with 3 UNION ALL statements joining 4 tables and a couple of lookup tables.

How would I get the filter on SpecId to work for my tablePane? It's not automatically applying the filter for me so I think I need code something.

Hi!

There is a 'New_window' control in DeepSee Widget which opens the page in a new tab in a browser with a given URL.

With the help of this control you can open another dashboard and supply some parameters in SETTINGS clause.

Consider I can setup in Dash1 the URL like:

Hello,

I am trying to integrate the Git with Studio. I have followed the below process to achiche Git tab in my Studio for Namespace

https://github.com/intersystems-ib/cache-git-studio

But I am getting the below error when I trying to Add the file. GitCodecache is my git repository.

fatal: c:/GitCodecache/cls/User/Testing.xml: 'c:/GitCodecache/cls/User/Testing.xml' is outside repository

Hi,

I have a stored procedure which would generate a standard Cache String and it would be called through JDBC and I would

dump the result in java console/standard output.

What kind of characters should I use in COS so when output get send back to Java side, it knows it contains new line character ?

Thank for your help.

By default, Analyzer executes queries as components are added. Often, there are times where you may know exactly what you are looking to do, and you do not want Analyzer to execute 5 queries as you drag and drop items onto rows/columns and select your filters. This is where toggling Auto-execute off can help.

Hi,

We have a mixture of legacy and new systems, and are grappling with the issue of moving documents between systems.

At the moment we are mostly using file drops and encoding metadata in filenames, but a new supplier (letter transcription) is going to provide a Hl7v2 feed sending MDM^T02 messages with PDF's of letters base64 encoded in the message itself.

We are thinking of asking all our suppliers to go with MDM (or ORU) for sending documents.

I'm interested in the pros and cons of the options; and if there are options I haven't thought of.

Hi,

I am saving 2000 objects of a class in a loop.

In one environment it is taking a total of 86 seconds and in another environment it is taking 0.55 seconds.

The code (the class and the code for save) is same for both the environment. I have Ensemble 2012.1.5.956

Can somebody help me to identify the cause of the discrepancy. Is there any memory or any other setup which may cause the problem.

Thank you in davance,

Susobhan

Please will correct the code:

a is a perse Unicode to Unicode mapping value.Str=other status. It is how to convert English to french .

So I finally decided to try out Atelier after having used Studio for who knows how many years. I primarily edit int files directly and am used to all the keyboard shortcuts in Studio. I was fiddling with the preferences under keys but have not got Atelier to behave very well for:

F2 = Jump to next bookmark

<Ctrl><F2> = Toggle bookmark

<F3> = Find Next, <shift><F3> = Find Previous

I can't find any equivalent to F12 to open the currently highlighted routine and jump to that entry point.

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.

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.