go to post Luis Angel Pére... · Jul 8, 2023 UserTable and DataTable are related? I'm guessing that if Condition1 is the relation between the tables you would try this query: SELECT COUNT(CASE WHEN data.a = "Condition1" then 1 ELSE NULL END) as "ValueA", COUNT(CASE WHEN data.b = "Condition2" then 1 ELSE NULL END) as "ValueB", COUNT(CASE WHEN data.c = "Condition3" then 1 ELSE NULL END) as "ValueC", user.id FROM UserTable user left join DataTable data on user.id = data.user
go to post Luis Angel Pére... · Jul 7, 2023 In my opinion the best approach is to create a BO for each database connection and invoke them from a BPL, getting the results and doing whatever you want.
go to post Luis Angel Pére... · Jul 6, 2023 Take a look at this article, it's exactly what you need: https://community.intersystems.com/post/creating-rest-api-jwt-authentica...
go to post Luis Angel Pére... · Jul 6, 2023 InitialExpression is what you are looking for:https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Luis Angel Pére... · Jun 29, 2023 Your would use JMeter to launch multiple calls in a row.
go to post Luis Angel Pére... · Jun 29, 2023 Do you mean the populate library? https://docs.intersystems.com/csp/docbook/Doc.View.cls?FIND=CLASSES+%25L...
go to post Luis Angel Pére... · Jun 29, 2023 You can take a look to this article and the associated Open Exchange application: https://community.intersystems.com/post/creating-rest-service-iris
go to post Luis Angel Pére... · Jun 28, 2023 Are you using an aggregate function in your query? You can see in the documentation that %SQLCODE = 0 is returned for queries with aggregates as SUM or AVG because it's returning a row even with a null value of the aggregation function.
go to post Luis Angel Pére... · Jun 27, 2023 You can send the List by reference to the Python method, populate it inside the method and use the populated list from the objectscript who call it. Something like this: set listOfStrings = ##class("%Library.ListOfDataTypes").%New() do ..TestPython(listOfStrings) $$$TRACE("What a beautiful trace! There are "_listOfStrings.Count()_" element(s)") ... ... ClassMethod TestPython(ByRef listOfStrings As %List) [ Language = python ] { import iris listOfStrings.Insert("One") listOfStrings.Insert("Two") listOfStrings.Insert("Three") return 1 }
go to post Luis Angel Pére... · Jun 22, 2023 It's true! Thank you @David Hockenbroch , I didn't realize that it was deprecated.
go to post Luis Angel Pére... · Jun 22, 2023 for x=1:1:rs.%ResultColumnCount{ //Get the value of each column set colValue = rs.%GetData(x) //Get the name of each column set colName = cols.GetAt(x).colName set colType = rs.GetColumnType(x) Have you tried this code?
go to post Luis Angel Pére... · Jun 22, 2023 You can use the method GetColumnType, here is the url to the official documentation: https://docs.intersystems.com/iris20231/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25SYS&CLASSNAME=%25Library.ResultSet#GetColumnType
go to post Luis Angel Pére... · Jun 16, 2023 If you want something low-code you can create a Data Transformation with a HL7 message as source and as destination a class created ad-hoc with the structure that you need. Take a look to this example: The destination in a class called RestTest.FirstRestObject with this definition: Class RestTest.FirstRestObject Extends (%Persistent, %JSON.Adaptor, Ens.Util.MessageBodyMethods, Ens.Request) { /// Description Property Name As %String; /// Description Property LastName As %String; Property Childs As list Of NestedRestObject; } This object has an SQL representation wich you could use later for your analysis:
go to post Luis Angel Pére... · Jun 9, 2023 If your business service extends from Ens.BusinessService you can use this instruction to get the name of the Business Service: set businessServiceName = ..%ConfigNameGet()
