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

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?

Hi, Rubens!

Generally, Feedback group is intended for DC issues and is hidden from the main feed.

We moved feedback requests from the main feed last year cause there were so many requests that they overlapped technical discussions very much.

This year DC engine works better and there are few issues to it, so I don't mind if we can discuss some DC problems on the main feed from time to time as your post about accepting answers. If you feel that you need more focus and discussion on the particular DC problem it worth to have it on the main feed.

So it's up to you.

Hi, Sebastian! What I like about your comment that you are not saying that it is impossible.

About small COS community: how large the community should be in numbers to support the project in your opinion?

In my opinion, 3rd party library for InterSystems data platform would be supported by the community if:

1. It provides a great added value for significant part of community

2. It is easy to collaborate in development

3. It is easy to install/deinstall the library