go to post David Hockenbroch · Nov 11, 2024 That also just gives the generic "Sending failed to all recipients" message.
go to post David Hockenbroch · Nov 7, 2024 Is SMTP authentication enabled in the Microsoft 365 account? That setting is turned off by default for new clients. You can check the setting in the Microsoft 365 admin portal under your active users.
go to post David Hockenbroch · Nov 5, 2024 Thank you! I was just trying to figure out this exact issue last week.
go to post David Hockenbroch · Oct 22, 2024 That shouldn't matter since the tasks themselves are not always stored in the namespace in which they are run. They are stored in IRISSYS. Does the user you are logged in as have permission to edit the %SYS.Tasks table in the IRISSYS namespace? And is this a system task? (System tasks cannot be deleted.)
go to post David Hockenbroch · Oct 22, 2024 If you use a dataCombo, the first column of the SQL query is the actual value of the dataCombo and the second column is the display value. So if you defined a dataCombo with sql="select Analyst, Analyst->Name from Analysts" (or whatever your table is) you'll get what you want. In that case, you'll also want to define the sqlLookup property of the dataCombo. That tells the Zen page how to find the correct display value when the value of the control is changed programatically, so something like "select Analyst->Name from Analysts where Analyst=?"
go to post David Hockenbroch · Oct 17, 2024 Does $ZV not meet your needs? I see you used it for your post, and it includes the build version, too.
go to post David Hockenbroch · Oct 14, 2024 Inside your combobox, you can define a displayList and valueList. If you do that, you don't have to also define the options individually.
go to post David Hockenbroch · Oct 14, 2024 Thank you, Guillaume! Lesson learned: make sure you're running pip from the IRIS Python, not the default Python on the PC!
go to post David Hockenbroch · Oct 11, 2024 Performance is number one for us. With properly defined and tuned tables, I've never seen a database run its queries faster than IRIS. Also just a lot of native capabilities. It's pretty rare that we have to reach outside of what comes in the box. And now with embedded Python, when we do need to add something, we have a lot of options. Aside from Python's technical benefits, there's also a personnel consideration. More and more younger developers are learning Python, and according to the PYPL index Python passed Java in popularity among learners in 2018 and is far beyond Java today. That means having Python as an option opens up your hiring pool more than any other language to the next generation of developers.
go to post David Hockenbroch · Oct 11, 2024 Yes, you can do that, but I have another recommendation. You generally want to be careful with what you do in %SYS, and you might not want a user to have permission to access that stuff all the time. You could create a new security role that gives the right permissions to access whatever you're accessing, then assign it in that method, run the code that needs it, and remove it. So let's say your new security role is called MyRole: set $ROLES = MyRole set oldns = $NAMESPACE new $NAMESPACE set $NAMESPACE = "%SYS" // Do your stuff here. new $NAMESPACE set $NAMESPACE = oldns new $ROLES The $ROLES special variable is used to manage roles that are added and removed programatically during the execution of code, but does not affect roles assigned to the user in the management portal.
go to post David Hockenbroch · Oct 9, 2024 If you don't have any other criteria you can use in your where clause, that will happen. Based on the data you've shown us, you'd need either ProvId or ProviderType to get it down to 1 row. If you just want the first row returned and don't really care which one it is, you could do SELECT TOP 1 IdentityId FROM PhysTable WHERE ProviderName = 'DOE, JOE' AND Type = 'NPI' ORDER BY IdentityId But that's only if you always want the lower number, and I doubt that's the case, right?
go to post David Hockenbroch · Oct 9, 2024 I think I'm confused. In your previous comment you said "We do not get the ProvId "8252" in the message, we do get the IdentityId "345678"." So I thought you got the IdentityId in the message.
go to post David Hockenbroch · Oct 9, 2024 What if you just do SELECT IdentityId FROM PhysTable? Do you get a column, or nothing?
go to post David Hockenbroch · Oct 9, 2024 So you get the IdentityId and the ProviderName, and you know the Type, and you want to write a query to get the ProvId?
go to post David Hockenbroch · Oct 9, 2024 Do you mean you want to know how to get just that column? SELECT IdentityId FROM PhysTable WHERE ProviderName = 'DOE, JOE' AND type = 'NPI' AND ProvID = '8252' Or if this is in SQL embedded in ObjectScript: &sql(SELECT IdentityId INTO :IdentityId FROM PhysTable WHERE ProviderName = 'DOE, JOE' AND type = 'NPI' AND ProvId = '8252') That will get the Identity ID and put it into the variable IdentityId for you to use in further code.
go to post David Hockenbroch · Oct 7, 2024 If you test the connection in your System Management Portal, does it fail there too?
go to post David Hockenbroch · Oct 3, 2024 InterSystems Studio is deprecated. IRIS 2024.1 is the last version that ships with the Studio, but it can be downloaded as a separate component from the WRC.
go to post David Hockenbroch · Oct 2, 2024 Neither text nor CSV files support any kind of formatting, just plain text.
