All
Accepted answers
Anderson Negreli · Oct 31, 2024 go to post

Oh, I had even done some simple calculations but the values ​​were not 100% matching, now it makes sense.
Thank you very much!

Anderson Negreli · Jun 12, 2023 go to post

I tried to access through the link but got an error, accessing through WRC returned the same error:

PS: Sao Paulo Brazil time zone

Anderson Negreli · Jan 2, 2023 go to post

Oh, this information is very helpful.
I've always considered Studio's terminal to be a true terminal, good to know.

Thanks for the answer.

Anderson Negreli · Dec 26, 2022 go to post

Interesting solution, it already serves as a diagnosis of what seems to be a bug, thank you.

Anderson Negreli · May 3, 2022 go to post

You can build a %Library.DynamicObject or a %Library.DynamicArray (both extend the %Library.DynamicAbstractObject class) from the ResultSet and use the %ToJSON method.
To build the object it will be necessary to loop the ResultSet writing line by line.

Anderson Negreli · Mar 25, 2021 go to post

PS: I could use the ID to get unique values, however I can only sort displayed values and I don't want to show a meaningless number (as it would be if I used the ID), so the row number would be ideal.

Anderson Negreli · Jan 12, 2021 go to post

Try use:

##class(%Library.SQLCatalog).GetCachedQueryTableCount("table_name")

This command will return the number of Cached Queries.

So, you can check if all Cached Queries have been purged.