go to post David Hockenbroch · Jan 18, 2023 Here's some documentation on the INTO clause. As Robert already said, though, it's a way to do an embedded query and store the result columns into variables in the host language.
go to post David Hockenbroch · Jan 12, 2023 A parameter is a shared, constant value that's available to all instances of a class. It can be calculated when the class is compiled, but it generally can't be altered at runtime. A property is a variable that each instance of a class stores it's own value for, and it can be set changed at runtime.
go to post David Hockenbroch · Jan 10, 2023 Are you sure that's where your problem is? If I do: select MONTH(dateadd(mm,-1,GETDATE())) I get 12. If I create a query with a where clause similar to yours on my data, it works as expected.
go to post David Hockenbroch · Jan 3, 2023 I'm not sure you can do that, but is there any reason you can't define it as two web applications, one with the dispatch class and one without?
go to post David Hockenbroch · Dec 6, 2022 Where is the function func1? If it's in a routine, you'd use do $$func1^MyRoutine where MyRoutine is whatever the routine is called.
go to post David Hockenbroch · Dec 5, 2022 If you have a routine that's saved as MyRoutine.mac, that would be: do $$^MyRoutine If you have a method within the MyRoutine.mac called Process, it would be: do $$Process^MyRoutine(myargs)
go to post David Hockenbroch · Nov 18, 2022 Is that what you want to do, or should you be defining your property as: Property Status As %String(VALUELIST = ",InProgress,Done,Canceled") [ InitialExpression = "InProgress" ]; This makes InProgress the default status when a new CarDealer.Order is created.
go to post David Hockenbroch · Nov 15, 2022 Where are you seeing this error? What's running and trying to connect?
go to post David Hockenbroch · Nov 15, 2022 The only way I can get it to succeed at a test from the SSL configurations setup screen is if I check SSLv3 under the Protocols in the Crytographic settings, then have it test smtp.gmail.com, port 465.
go to post David Hockenbroch · Nov 15, 2022 This might be easier to do with XPath rather than a loop. First, you'll need to create a %XML.XPATH.Document object, maybe using the create from string method: set sc = ##class(%XML.XPATH.Document).CreateFromString(xmlstring,.mydoc) Check that the status you get back from that is not an error. If it isn't, you mydoc should be an XPath document. Then you should be able to use the EvaluateExpression method of that document to get what you want, something like: set sc = mydoc.EvaluateExpression("/Msg/Parties/Party[AgentId=1]/OrgCode","",.value) If that status is okay, the value you're looking for will be in value, unless there are multiple XML nodes that match that path. W3 provides the XPath syntax specification here.
go to post David Hockenbroch · Nov 9, 2022 SQL gateway connections provide a way to make an ODBC or JDBC connection to an external data source. It can be another IRIS instance, but doesn't have to be. So whatever you can do with either of those kinds of connections, you can do with the SQL gateways.
go to post David Hockenbroch · Nov 7, 2022 I've had to do this a time or two in a development environment. Sometimes you can find it under System Operation > Processes and terminate the process. If that doesn't work, you can look at the process ID of the process and kill it at the OS level (the kill command in Linux, or taskkill in Windows). Just be aware that depending on what it's doing and how the task was written, you may end up with some weird stuff.
go to post David Hockenbroch · Oct 14, 2022 This is good work, but there's actually already a built-in function for this in %SYSTEM.SQL.Functions.LASTDAY().
go to post David Hockenbroch · Oct 14, 2022 @Nezla in addition to what Danny mentioned here, if you see a part of a URL that starts with a colon in the url map, that part of the url is going to be passed as an argument to the method listed in Call. For example, I'm working on an API for an ERP system, and I've got an endpoint that can be called to get a customer record. The route in the url map is defined as: <Route Url="/customer/:cust" Method="GET" Call="RequestCust" />The RequestCust method is defined as: ClassMethod RequestCust(cust As %String) As %Status So if a user sends a request to /customer/123456, that gets passed to the RequestCust method with 123456 as the cust argument, and they get customer record 123456. If they send the request to /customer/999999, they get customer record 999999.
go to post David Hockenbroch · Oct 13, 2022 Normally, one user connecting from one ip address uses one license. However, if you have 25 or more simultaneous connections under one license, it starts considering each connection to be a different license. I believe this is to try to prevent people from cheating the license system.
go to post David Hockenbroch · Oct 10, 2022 Others have already explained why you can't use those list functions on a list of datatype. As an alternative approach, though, you could change your persistent class to save the original string that you are using to create the list, then use your $ListFromString etc. on that as you have been.
go to post David Hockenbroch · Oct 7, 2022 Is oneFldLogin.cls the login page for the application? Go to your management portal, System Administration, Security, Applications, Web Applications, and find the web app. At the bottom, under Custom Pages, is that set as the login page? If you open it in Studio or VS Code, does oneFldLogin.cls extend %CSP.Login?
go to post David Hockenbroch · Sep 29, 2022 You could create a new class that extends %ZEN.Component.toolbar, and override the ongetdata property to be a certain method name, then define that method in the class. Then you'd have your own custom tag to use in your zen pages. Here's more information on creating custom Zen components. Inevitably, though, someone is going to come in here and tell you not to use Zen in any new development because it's deprecated, FYI. Which makes me sad, because I still really like working with it.
go to post David Hockenbroch · Sep 29, 2022 Set tSC=##class(Hosiptal.SDA3.DataTrans).Transform(pRequest) Is that a typo? Should maybe be "Hospital", not "Hosiptal".
