Article Evgeny Shvarov · Nov 15, 2017 3m read

Hi, Community!

In the second part about DeepSee Web, I’ll describe what customization options you have with DSW.  

There are two types of customizations: widget customization and dashboard panel customization.

Example of dashboard customization on Developer Community analytics.

5
0 1136
Question Evgeny Shvarov · Nov 6, 2017

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?

26
1 1526
Article Evgeny Shvarov · Nov 3, 2017 3m read

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.

16
5 2661
Article Evgeny Shvarov · Oct 19, 2017 1m read

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

and then right click on Refresh button.  Less obvious and very helpful sometimes.

3. Clear cache in CSP Gateway

If 1 and 2 don't work for you, try to flush the CSP Gateway cache.

1
0 1671
Announcement Evgeny Shvarov · Oct 6, 2017

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:

You can use your previous credentials as well. And you can get the invite also - just comment here or in this post.

2.

0
0 325
Article Evgeny Shvarov · Oct 5, 2017 2m read

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.

6
0 594
Question Evgeny Shvarov · Sep 30, 2017

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.

3
0 946
Question Evgeny Shvarov · Sep 27, 2017

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.

And every

3
0 605
Announcement Evgeny Shvarov · Sep 25, 2017

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.

E.g. here is an announcement, this is another example of event announcement and this very post is an announcement too.

Announcement post has "loudspeaker" sign in the post feed. See the examples:

2.

10
0 461
Question Evgeny Shvarov · Sep 4, 2017

Hi, folks!

What could be the best backup/restore strategy for a small (less than 100MB) but very valuable database which is placed on AWS/DO virtual host?

1. Use AWS/DO backup/restore features?

2. External backup (as the most recommended)?

3. InterSystems backup?

4. Globals export to a zipped file?

5. cache.dat copy?

Looking for the most robust and easy to use/implement method of backup and restore in a way "setup and forget" (until it becomes needed :)

2
0 737
Question Evgeny Shvarov · Aug 28, 2017

Hi, folks!

I'm sending emails with %Net.MailMessage.

How can I add a new line for the email body?

The code is:

dim msg as %Net.MailMessage = ##class(%Net.MailMessage).%New()
set msg.Charset="UTF-8"
do msg.TextData.Write("Dear  "_Username)
do msg.TextData.Write("Line1")
do msg.TextData.Write("Line2")
And I'm getting in email:
Dear UserLine1Line2

How can I get:

Dear User

Line1

Line2
8
1 1887
Announcement Evgeny Shvarov · Aug 23, 2017

Hi, Community!

For those developers who are attending Global Summit 2017 this year: you have an opportunity to share your solutions, framework, and experience with the rest GS attendees and Developer Community.

On Monday 11th we would have Developer Community Sessions in Tech Exchange Open House (see the agenda).

Every presenter would have 10 minutes for slides and 5 minutes for questions. So we have 6 slots available at the moment.

We would have a live stream of the event on DC YouTube so you would be able to watch it and ask questions in comments to the streaming over Internet.

11
0 718