Evgeny Shvarov · Mar 1, 2016 go to post

Hi, Scott!

You are right!

The explanation is very simple - we had a bug in formula.  Sorry about this.

But the final leaderboard is quite right! 

We have points for: posting, commenting, votes in your posts and comments. 

And yes, we filter Announcements and Developer Community Feedback groups.

Evgeny Shvarov · Feb 26, 2016 go to post

As an alternative you can use Cache Web terminal.

Download xml, import it with help of Caché Studio into any namespace and get terminal in the browser with:

http://server:57772/terminal/

1) You can run read command.

2) And you can run some routines with VT-100 terminal UI

Source code

Evgeny Shvarov · Feb 26, 2016 go to post

Hi, Benjamin! Thanks!

There was also DC update last week Paul mentioned about new button in WYSIWYG editor. 

You can click upload button (red circle in a screenshot) and image will be uploaded to your message in the place of cursor.

Of course it is good to stretch it to 600px - you can do it if you select all the image and click image button (red rectangle in screenshot) and set image's widh.

I did it to the screenshot of the post.

Evgeny Shvarov · Feb 24, 2016 go to post

We have a formula which summarize votes for posts, votes for comments.

It also gives some score for comments in your post.

It counts points also for your comments in other posts - e.g. for your answer on the question.

Evgeny Shvarov · Feb 24, 2016 go to post

I would add "Go Scott!" 

If you change filters to February scope there is  following picture for top 20:

Where are your new cruel questions? )

Evgeny Shvarov · Feb 23, 2016 go to post

And there is new "Separate teaser button in WYSIWYG editor to insert tag to separate annotation from the rest of the text.

Use it to manage annotation paragraph which readers see in the list of posts on the main page.

Evgeny Shvarov · Feb 22, 2016 go to post

Hi, Mike!

Nice to see you in InterSystems Developer Community!

I have you book on my table) Thank you for your work! Can we wait for any new books from you?

I see Paul and Benjamin answered your questions. 

Here are my 2 cents: COS highlighting,  small FAQ. But as Paul mentioned DC is changing weekly so some of the advices became obvious some has become deprecated already.

Evgeny Shvarov · Feb 19, 2016 go to post

Great article.

I like to use this approach with CacheUpdater tool. It adds a Task in Caché with parameters of github repo URL and credentials if needed.

So if I need to update the app  with new code from github repo I just run the task.

Evgeny Shvarov · Feb 18, 2016 go to post

Hi, Sylvian!

We used another approach to this problem and find solution which our customers use in production.

Customers wanted sophisticated excel reports from DeepSee. Thay alredy had hundreds of predefined reports in form of Excel.

What we do:

1. Transform this standard Excel reports into excel-xml(save Excel as xml) templates with XSLT variables inside.

2. Programmaticaly run reports in DeepSee, parse the result and perform XSLT transformation under excel-xml templates and data from DeepSee. You can use for this either %DeepSee.ResultSet or %DeepSee.REST.API or MDX2JSON.

3. Get the ready to use Excel reports with data from DeepSee in excel-xml form.

Here are some code examples, presentation and workthrough which are mostly in Russian (except COS).

Hope it helps.

Evgeny Shvarov · Feb 18, 2016 go to post

Thank you Andreas! 

I used Caché Monitor many years ago,  it is great! 

Server Navigator link doesn't work, would  you please fix it?

Evgeny Shvarov · Feb 16, 2016 go to post

Hi, Steve!

Have you tried %Last function?

E.g. in a MDX query below it counts records only for the last month of sales for every product. 

SELECT NON EMPTY %Last([DateOfSale].[Actual].[MonthSold].Members) ON 0,NON EMPTY [Product].[P1].[Product Category].Members ON 1 FROM [HoleFoods]