All
Accepted answers
Matthew Giesmann · Jun 23, 2025 go to post

My other thought would be to (carefully!) take out and release the oddDEF lock for the class

//adjust timeout
lock +^oddDEF(class):5
//check $test and handle timeouts appropriately
write $test
1
//make sure this happens
lock -^oddDEF(class)#"I"
Matthew Giesmann · Apr 23, 2025 go to post

Hi Ali,

I can imagine cases where you'd want to deploy just the built artifact, but we've had success building on deploy. We use an angular CCREventHandler class that detects ng changes in a deployed itemset and kicks off all the needed build steps.

Matt
 

Matthew Giesmann · Apr 1, 2025 go to post

This has been our workaround - its sufficient for the immediate case, but its not something that we could recommend generally.

Matthew Giesmann · Mar 31, 2025 go to post

Thanks Ali,

I don't think I can do that for just the current process, so it'd be a pretty big risk to turn off even temporarily.

Matthew Giesmann · Jul 3, 2024 go to post

GenerateAfter can help here.

///do ##class(Test.GenerateHelper).Generated()
///Hi there!
Class Test.GenerateHelper
{
  ClassMethod Generated() [ CodeMode = objectgenerator, GenerateAfter = Helper ]
  {
    set text = ..Helper()
    do %code.WriteLine(" write """ _ text _ """")
  }

  ClassMethod Helper() As %String
  {
    return "Hi there!"
  }
}
Matthew Giesmann · Jun 5, 2024 go to post

Is it a ZEN Select component rather than just an html select?   If so, maybe set the displaylist and value via the ZEN helpers? 
From memory (and it has been a long time), something like:
var select = zen(zenIdOfSelect)
select.diplayList='one,two,three'
select.setValue(3)
select.refreshContents()

Matthew Giesmann · Mar 28, 2024 go to post

Quick note on one thing has come up a few times - the new view page does have a link to the home page. 

From any page, clicking the "I" icon in the top bar goes to the CCR home page, and the top option in the hamburger menu is "Home".

 

Matthew Giesmann · Aug 1, 2022 go to post

Hi Michael,

This isn't a straight answer to the problem of extracting business logic from CSP pages - but if you haven't already, check out the isc.rest project. Its an open source release of the framework we've been using to migrate our CSP and Zen apps to REST (Angular front end). 

If nothing else, it provides a uniform, safe and easy to maintain way of creating a REST API from an existing application. 

My process has generally been to copy CSP business logic to a class method in the relevant persistent class and expose it as a REST Action there (see Defining Actions in isc-rest user guide).  Its possible to expose any method in this way, so depending on your situation, it could make sense to point an action endpoint to the class methods in CSP directly, or use a wrapper method.
This recent presentation is a great place to start: https://learning.intersystems.com/course/view.php?id=2102

git hub: https://github.com/intersystems/isc-rest

Matthew Giesmann · Dec 17, 2021 go to post

Thank you, @Robert Cemper and @Eduard Lebedyuk!
I did not know about MANAGEDEXTENT, assuming there was no way to use the same storage in another class.  Ed's warning is relevant though, I can't ensure that there wouldn't be other concurrent writes.

Here is my working solution.... Subclassing of the record class with Setters for the 2 properties seems to work.  Simply overriding the 2 properties without [ SqlComputed ] did not change the computed behavior.

Class Audit.HistoricalRecord Extends Audit.Record {

Method LastModifiedTimeSet(value As %String) As %Status
 {
    Set i%LastModifiedTime = value
    quit $$$OK
 }

Method LastModifiedUserSet(value As %String) As %Status
{
    Set i%LastModifiedUser = value
    quit $$$OK
}

}

My migration routine can now create and save objects of the HistoricalRecord class

Matthew Giesmann · Oct 22, 2019 go to post

Hi David,  thanks for this suggestion.  File names that include full version strings are now visible prior to download.

Matthew Giesmann · Oct 7, 2019 go to post

While using &SQL without a CURSOR will always only execute once and return one row, the SQL optimization is still dependent on the specific query - so while the cost of the non-top query is much higher, what really matters here is cost to first row.  For the example query, that will be minimal, but could be much higher in a more complicated case.
 

Matthew Giesmann · Aug 15, 2019 go to post

I haven't tested to see if it matters, but I see that CreateCoffee() isn't returning a %Status. 

Matthew Giesmann · Aug 14, 2019 go to post

From the docs on the SQL Gateway
"All the tables listed in the FROM clause of an SQL query must come from the same data source. Queries that join data from heterogeneous data sources are not allowed."
https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…

You might be able to use a sub query to work around this:
select * from tableusers u JOIN (SELECT * FROM  tablelogentries) e ON e.userid = u.userid

I would contact the WRC if the above workaround doesn't cover all of your use cases.

Matthew Giesmann · May 8, 2019 go to post

Hello Luk,

I have seen "Error Condition: Failed to read posted content from the client" due to a quirk in how IE resends some requests after a network timeout. This discussion on stackoverflow describes the IE behavior I saw that resulted in these messages:

https://stackoverflow.com/questions/4796305/why-does-internet-explorer-not-send-http-post-body-on-ajax-call-after-failure

I would try to isolate what CSP requests are causing the messages.  

Matthew Giesmann · Jan 18, 2019 go to post

Hello Dhaval,

I don't believe that there is a clean way to access the property you are looking for, though you may be able to finagle the data you need in SQL with the $list function.

On the first array level (Employee), Cache projects the property as a table, allowing for easy SQL access.  However, because Employee is not Persistent, it cannot project its address array property as a table.  Any SQL access will have to deal with the $listbuild that the second level array is stored as.

If possible, I would make Employee a stand alone table, maybe as a Relationship rather than an array.  

Matthew Giesmann · Jan 3, 2019 go to post

I recall seeing this work before, but I believe it took a good amount of extra javascript work to get the ZEN drag and drop mechanisms (see doc) working nicely with the cells of tablePane. 

Matthew Giesmann · May 24, 2017 go to post

In general, "list of ___" properties don't play well with SQL.   Looks like we just present the list as a string.

Using the Generate CREATE TABLE statement feature of WinSQL for Sample.Person gives:

    FavoriteColors VARCHAR(4096)

Matthew Giesmann · Nov 10, 2016 go to post

Hello Mikhail, Good question!

I think of block count as a rough estimate of the disk size of a table or index (an "SQLmap").  The SQL optimizer uses this to get an estimate of how much disk I/O could be involved in scanning that map.  Block count mostly matters in proportion to other block counts (similar to ExtentSize).  

I am not certain how to interpret 2K reference in the documentation, perhaps someone else will chime in - my guess is that the "units" don't matter, so the original 2K block size is still used as a base unit for measuring the disk size of a storage map.

Block Count can be extremely important for tables that have child tables, or that otherwise share a storage global with other classes. The row count might be relatively small, but because the global nodes are spaced out, more disk I/O is required.  With the block count taken into consideration, the SQL optimizer may be pushed toward an index or different starting table.

Matthew Giesmann · Oct 31, 2016 go to post

It is possible that a query can skip the master map completely, but only if all fields being selected are in the index and in the same form as in the master map.  

Even if all fields are in an index, indexed fields are typically stored in SQLUPPER, required for SQL comparisons, but the query must get the fields in their original form for output.  So for a SELECT *, the query will almost always need to go back to the mastermap.