All
Accepted answers
Evgeny Shvarov · Oct 8, 2017 go to post

Finally, I ended out with the following expression:

WITH  MEMBER [DateOfSale].[LastDayOfMonthRevenue] AS 'AGGREGATE([DateOfSale].[Actual].[MonthSold].CurrentMember.LASTCHILD,MEASURES.[Amount Sold ])' 

So if you looking to get the value for measure other than you have in context AGGREGATE would be helpful.

This approach is very useful e.g. if you want to show daily running total but for the monthly scope.

Thanks [@Alessandro Marin] for an extra DeepSee support session on GLobal Summit 17 Tech Exchange ;)

Evgeny Shvarov · Oct 6, 2017 go to post

If I don't have control of this, who decides what is relevant?

Hi, Mike!

iKnow technology decides. iKnow analyses the article compares with all the rest articles in Community and makes the decision according to its algorithms and some settings and blacklists.  Actually, it's in beta state at the moment and sometimes it does irrelevant decisions. iKnow thinks that How to highlight Caché ObjectScript, work with htm, add image in the post and other questions article is relevant to your question at least by 30%. 

We would fix the algorithm in next DC version.

Evgeny Shvarov · Oct 6, 2017 go to post

Hi, Mike!

It's a good question, so I vote for your question too.

Here is the short explanation.

I guess everyone in DC would love to see qualitative articles, questions, and answers.

Voting is the way for us to introduce mechanism on DC which would encourage the creation of qualitative content and discourage the low-quality staff. And "Rating" is the sum of votes.

It's also the way for an OP to know how many people said "Thank you for your post and hard work" for his article. We can see articles with more than 10 "thank you for your post" signs.

It's the way to "Agree" and "I like it" for the answers and comments.

Also, sometimes Votes is the way to say "I disagree" and "I don't like it" and yes, it can be confusing to distinguish when you "disagree" or "dislike".

It's not an ideal mechanism, maybe we would introduce something better, need your advice here.

Evgeny Shvarov · Oct 6, 2017 go to post

Thank you, John!

I would add that for questions 2-3 sentences long teaser can include the whole question.

Evgeny Shvarov · Oct 5, 2017 go to post

Forgot to mention, that good question should contain only one question in the body. 

Evgeny Shvarov · Oct 5, 2017 go to post

Dmitry, thank you for your great input for the community. And looking forward seeing articles describing your docker experience with InterSystems technology and how you benefit from it.

Evgeny Shvarov · Oct 5, 2017 go to post

Hi, Fabio! Great article! Do you have a github repo or gist for your sample classes too?

Evgeny Shvarov · Oct 4, 2017 go to post

Hi,  Community!

We introduced Single Sign On for Global Masters (GM).

So you can use your WRC credentials to join globalmasters now.  First time it would also ask you for a GM specific password.

How it works:

For those who have no active WRC account yet the invite is a way to join! Comment this post to get the personal invite to the Intersystems Global Masters Advocates Hub.

And you can use your login and password if you are already a member.

Evgeny Shvarov · Oct 2, 2017 go to post

Hi, Tyler!

Nobody is clicking on them in the sidebar. Anyway if we would have a lot of votes on it we would move it underneath.

Evgeny Shvarov · Oct 2, 2017 go to post

Hi, Konstantin!

The problem with strange suggestions fixed, but it doesn't suggest anything for $CASE now ) 

Did you introduce $CASE in a blacklist? )

I think suggestions on all COS commands and functions is a good option for the search field (if possible of course).

Evgeny Shvarov · Sep 28, 2017 go to post

Hi, Konstantin!

I tried to search $Case word it finds, but it shows strange option in a dropdown list of a search field. See the screenshot:

What does it mean?

Evgeny Shvarov · Sep 28, 2017 go to post

BTW, we implemented related articles feature via InterSystems iKnow technology. 

It's in a beta stage at the moment, so if you find a wrong related list of articles somewhere I would appreciate if you provide it here, we would tweak the blacklist and similarity rate. Thank you in advance!

Evgeny Shvarov · Sep 28, 2017 go to post

Currently the only way to give permissions on "Future" tables (that is, tables you haven't created yet) is to grant permissions on the schema and then add tables to that schema.

Hi, Kyle! I do not want to grant permissions to "Future" tables, though your suggestion is interesting and helpful. The question was if anyone has a kind of wise parser which examines all the Listings in all widgets of a Dashboard and parse FROM clause to grant permissions to tables listed there.

Evgeny Shvarov · Sep 27, 2017 go to post

What if I want to export Resources only and then manage it on a target system manually?

It's not obvious how to export Resources only.

Evgeny Shvarov · Sep 26, 2017 go to post

Got it. But I think you missing Global and SQL views.

E.g. here is SQL view on Sample.Person (you can find it in your SAMPLES namespace):

 

Similar to your screenshot table structure, yes?

And here below there is a screenshot of Global data of the same table.

 

 

Anyway, regarding your question, there are SQL and GLobal ways to deal with your data but please provide more details on the scheme, either global names or SQL tables.

As I see you have JSON data in the field payload. So extract the data from this field with SQL query (this is a good article), extract date/time information via JSON and put it in another class field and sort via Index or just put it in a global index and get it sorted automatically.

HTH

Evgeny Shvarov · Sep 26, 2017 go to post

Hi, Soufiene!

I beautified your question a bit:

Fixed the title:

extract values from global -> How to Extract Values From a Global

Fixed some bugs in English in your question.

Beautiful title and text of the question motivate DC members to answer it.

Regarding your question: you ask about extracting from a Global, but provide the result of SQL query. Do you really want to work with global? If so would you please send the screenshot or structure of the global with data?