New post

Hi, folks!

Suppose you have a Caché class with %String property which contains relatively large text (from 10 to 2000 symbols).

The class:

Class Test.Duplicates Extends %Persistent 

{

Property Text As %String (MAXLEN = 2000);

}

And you have thousands of entries.

What are the best options to find entries which are duplicates on this property?

0 26
1 1.4K

There are several options how to deliver user interface(UI) for DeepSee BI solutions. The most common approaches are:

  • use native DeepSee Dashboards, get web UI in Zen and deliver it in your web apps.
  • use DeepSee REST API, get and build your own UI widgets and dashboards.

The 1st approach is good because of the possibility to build BI dashboards without coding relatively fast, but you are limited with preset widgets library which is expandable but with a lot of development efforts.

The 2nd provides you the way to use any comprehensive js framework (D3, Highcharts, etc) to visualize your DeepSee data, but you need to code widgets and dashboards on your own.

Today I want to tell you about yet another approach which combines both listed above and provides Angular based web UI for DeepSee Dashboards - DeepSee Web library.

3 16
5 2.4K

Hi, Community!

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

Most Viewed

Developers Meetup 25th of October, Cambridge MA, CIC 269

COS extension for Microsoft Visual Studio Code 183

Release of Caché / Ensemble 2017.2.0 and HealthShare Health Connect v15.03 for 2017.2.0 179

How to interactively run a Windows or Unix command from inside Caché/Ensemble 172

Yet Another Way to Duplicate Quotes in String 162

Studio Source Control in Atelier 161

Using $fromObject throws error 155

Global Masters Badges Descriptions 147

Querying a list property with SQL 144

Can a class refer to a global in a different namespace? 141

0 0
0 279

Sometimes you can face the situation when you did update the web app on Caché server but you cannot get the newest version of the app in a browser.

Here are couple recipes which help me to solve it. From simplest to more sophisticated and not obvious.

1. Refresh page in a browser

In Chrome it is Ctrl+R or 'Refresh' button. Obvious, but helpful.

2. Hard reset in a browser

If you are in Chrome, open Developer tools

2 1
0 1.6K
Announcement
· Oct 6, 2017
October 2017 DC Release

Hi, Community!

It's October and we have new DC release here. What's new?

1. InterSystems Single Sign-On for Global Masters

As you maybe heard about InterSystems Global Masters (GM) program. With this release, we introduced InterSystems SSO support for GM. So now everyone who has active WRC account can join GlobalMasters and no special invitation needed. You are welcome!
How it works:

0 0
0 300

Hi, Community Members!

The goal why we are posting questions on Developer Community is to get the answer.

Here is very simple guidelines document on how to ask questions which would get answers.

When you post a question you need to feel 3 fields: title, body, and group. And tags.

1. The Title

A good title should contain the brief description of your problem - it should not be longer than 80-90 symbols.

But brief doesn't mean one word. These are not very good titles for questions: Cache, Ensemble, Peace, World.

2 6
0 495

Hi, Community!

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

Most viewed

DeclarativeCOS — Declarative Programming in Caché 503

New Programming Language - Discussion 318

InterSystems IRIS Data Platform 253

? Where/How can we touch IRIS ? 207

InterSystems Global Summit 2017 Key Notes Live Stream 199

Filtering non-printable characters 188

Double dot? 172

Search InterSystems documentation using iKnow and iFind technologies 168

SPOOL - the fogotten device 167

InterSystems Cloud Manager and Containers at GS2017 XP-Lab 166

Vue.js: getting started with a basic HTML/REST/JSON example 162

Pro Tip: Controlling your SysTray Cube icon appearance 155

Widgets Direct 141

Horizontal Scalability with InterSystems IRIS 138

UnitTest : A Mocking Framework for InterSystems objectscript classes. 13

2 0
0 312

Hi, folks!

Is there any way to use $CASE or $SELECT functionality in SQL SELECT query?

E.g. something like this:

SELECT product, $CASE(status,"New":field1,"Payed":field2) as data from sales

To see either in data column either field1 or field2 values in regard of status value.

0 3
0 861

Hi, folks!

When you deploy DeepSee solutions you often do not want grant a User %All Role to work with a particular Dashboard.

Consider a Dashboard 'Dash' with a few widgets where listings are being used.

If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access, grant access to a Dashboard resource (if any) and ... grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets.

1 3
0 499
Announcement
· Sep 25, 2017
September 2017 DC Release

Hi, Community!

I'm pleased to announce that we deployed a new release of Developer Community.

With this release we introduce:

1. New post type is introduced: Announcement

Choose Announcement as a post type if you want to say about a new product or feature release, about some new services in your company, if it is event announcement or there is a new job position open in your company.

2 10
0 401

Hi, Community!

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

Most viewed

Your Workflow: Issue Tracking, Version Control etc. 243

Runtime type detection 217

Feeling the power of Caché 188

AES Encryption 159

from the roots to InterSystems 156

Load JSON from a file 149

Server-side way to disable logins for all users 149

Grafana-based GUI for mgstat, a system monitoring tool for InterSystems Caché, Ensemble or HealthShare 148

Caché and Ensemble 2017.1.x on OpenVMS - Recall 145

PDFs and Reading them 144

Winning in GIS competition 135

Frontier: A different way of working with REST 118

Handling images with Caché & JSON, and why 57 is a magic number 117

1 0
0 297