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.

Hi, Mike!

It's a good question.

Now Groups are tags, which we want to be in any post. Every Group tag relates either to InterSystems Product (CachéEnsembleHealthShare),  or InterSystems Technology (DeepSeeIKnow) or InterSystems Service (Learning ServicesWorldwide Response Center (WRC)). 

All the rest valuable things are tags. HTH.

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.

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.

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