No need to get fancy with extra apps and paid services. You can usually email a text message to a phone using plain old SMTP if you know the provider so you can look up the SMS gateway for them. Here are some of the biggest ones, at least where I am:

• Verizon & Xfinity: vtext.com
• AT&T: txt.att.net
• T-Mobile: tmomail.net
• Sprint: messaging.sprintpcs.com
• Boost Mobile: sms.myboostmobile.com

If your provider isn't on that list, you can most likely find the SMS gateway via a simple Google search. Then you can send an email using the phone number and that domain as the recipient, and it will go to the phone as a text message with a subject line. For example, if you send an email to a Verizon user, the email address would look something like 5551234567@vtext.com. You can even do this from within Outlook or Gmail if you want to test it out. Mind the character limits, of course.

Several of these are already stored in IRIS. When you create or edit a user, you have an option there to select a mobile provider. You can also add new providers which requires a name and the SMS gateway. These are stored in a table called %SYS.PhoneProviders.

If your goal is to set a value on insert, you don't need a trigger for that. You can just declare that property with an InitialExpression defined.

You would probably be better served using XPath instead of the XML reader. When you evaluate and XPath expression, it will recognize the CDATA and parse it correctly, returning either a value or another XML object.

Does the test user account have the right security resources to access the database you're trying to log into? The quick easy way to check if you have a security-related issue is to give the test user the %All role and see if the issue goes away. If it does, you need to figure out what resource/role is missing for the user account. You don't want to permanently leave the %All role on there.

Yes. You can use a variable name starting with ^, like ^MyGlobal, and it will be a global. You will not be able to access it via SQL, but you will be able to see it with the globals in the system management portal. You can also reference globals in a different namespace by using ^|"namespace"|MyGlobal.

The only places I know of are, if it caused an xDBC error, that in the system management portal under System Operation, System Logs, xDBC Error Logs, and if it was a query run through the management portal itself, you'd be looking in the global %sqlcq and for your search mask, use %sqlcq("NAMESPACE","SMPQueryHistory","USERNAME" to see the query history for a specific user. That's where the query history you see in the SQL section of the management portal is stored.

I don't know of anything overall, though.

All we can tell from this is that in the class gen.Custom.HS.Model.OEOrdItem.TabularTextResultsEMR, you have a method called GetData, and on line 872 of the .1 file for that class, you have a variable named rs that is undefined.

The specific issue here is probably that when you tried to set text = type.%Get("text"), the variable "type" wasn't an object because it didn't exist or wasn't a dynamic object/array within the original object. You might want to try:

set iter = identifiers.%GetIterator()
     while iter.%GetNext(.key, .value, .type ) {
        set type = value.%Get("type")
        if$ISOBJECT(type){
            set text = type.%Get("text")
        }
        else{
            set text = ""//Or whatever you wanted to do if type wasn't an object.
        }

You can set this up using your routine mappings. You can have each namespace have a different database for its globals but share a database for the routines. Then they'll all have their own data, but be running off of the same code.

I only have back to Cache 2018, not 2017, but can you try:

set myproc = ##class(%SYS.ProcessQuery).%OpenId($J)
if myproc.ClientExecutableName = "CSTUDIO.EXE"{
    //You are in Cache Studio
}
else{
    //You are not in Cache Studio
}

Here's my small but useful contribution:

Add an "Add Server to VS Code" Option to System Tray Icon

We have had a few people ask for a CSV using a pipe as a separator. If you run into that and need to open it in Excel, you do that by going to the data tab, then click From Text/CSV. It may detect the separator character automatically, but if not there is a place where you can set it. (You may want to right click on the GIF and open in new tab if it's too fuzzy.)