Question Krishnaveni Kapu · Mar 28 get ClassMethod how can I get the classMethod name ?like we get class name using "$CLASSNAME($THIS)", same way I need class Method ? #Caché #InterSystems IRIS for Health #Ensemble 1 6 0 60
Question Krishnaveni Kapu · Mar 27 count(*) from a sql dynamic query I have dynamic sql select query , Set resultset = ##class(%ResultSet).%New() set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'" SET SC = resultset.Prepare(sql) SET SC = resultset.Execute(sql) How can I print/view the count ? #Caché #InterSystems IRIS for Health #Ensemble #InterSystems IRIS 0 8 0 73
Question Krishnaveni Kapu · Mar 5 Enable/Disable a scheduler task Hi , I have a scheduler task and an associated class that works. Class Sample.Util.CreateTask Extends (%SYS.Task.Definition, %Persistent){ Parameter PROPERTYVALIDATION = 1; Parameter TaskName = "Sample.Util.CreateTask"; Method OnTask() As %Status{// Perform the logic} } Is there a way to Enable or Disable the above task "CreateTask()" from an external function/Method/class ? #Ensemble #HealthShare #InterSystems IRIS 0 2 0 55
Question Krishnaveni Kapu · Feb 27 file path in FTP outbound adapter Hi All, How can I customize the file path of my FTP outbound adapter. I have a custom business operation that extends "EnsLib.FTP.InboundAdapter", in which I need to update the file path of my FTP server location. #InterSystems IRIS for Health #Ensemble #Health Connect #HealthShare #InterSystems IRIS 0 2 0 45
Question Krishnaveni Kapu · Nov 20, 2024 Reading values from JSON Hi , I receive below JSON from a https outbound operation { "Link": "www.sample.com", "Practice": [ { "Node": "Record1" } ]} I am able to read Link as - JSON.%Get("Link") How can I read Node value ? #Ensemble 0 2 0 106
Question Krishnaveni Kapu · Sep 26, 2024 CHARSET options for the FTP outbound adapter Hi , I am sending my DTL response (which is an xml stream) to an FTP out location. My XML stream has CRLF , but after sending FTP'ing out , it displays as LF before writing it to FTP At FTP out location What Chatset will do it ? Currently Charset is set as Binary. Appreciate quick response. #Ensemble 0 3 0 72
Question Krishnaveni Kapu · Sep 23, 2024 Large Stream to base64Encoded I have below method , which receives a PDF ; this method throws error for a PDF file of 3MB size <MAXSTRING>zBase64Encode+9 -- logged as '-' number - @' set encodedData = $system.Encryption.Base64Encode(content)' How do I fix this. ---------------- #Ensemble 0 2 0 167
Question Krishnaveni Kapu · Sep 21, 2024 fileName in an FTP out Hi All , I would like to add session ID to the fileName in an FTP out pass thru business operation.How can I do that ? <Setting Target="Host" Name="Filename">SessionID_%f_%Q.txt</Setting> #Ensemble 0 2 0 113
Question Krishnaveni Kapu · Sep 20, 2024 xml attribute in double quotes I am converting a HL7 msg to xml and one of the field is as below - DTL = <assign value='"Message"' property='target.{req.ID.scope}' action='set' /> DTL response = <ID scope='Message'>3</ID> my xsd has -<xsd:element name="ID"><xsd:complexType><xsd:sequence><xsd:element name="SimpleContent" minOccurs="0"/></xsd:sequence><xsd:attribute name="scope"/></xsd:complexType></xsd:element> #Ensemble 0 4 0 89
Question Krishnaveni Kapu · Sep 16, 2024 padding zeros to the desired length I receive a number as input length = ln = 7 if input = 25I need to add zeros to make make it as - 0000025 (a total length of ln) if input = 9I need to add zeros to make make it as - 0000009 (a total length ofln) #Ensemble 1 6 0 174
Question Krishnaveni Kapu · Sep 13, 2024 ..AppendTimestamp in FTP ..AppendTimestamp in FTP what are the different values that can be passed to ..AppendTimestamp in FTP ?Can we pass dynamic values to it ? if so how can we do that ? #Ensemble 0 1 0 74
Question Krishnaveni Kapu · Sep 11, 2024 SQL query to get multiple records I have an SQL table as below (columns - ID and Value) I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID as - if ID = 11 ; QRY output = aaa,bbb if ID = 22 ; QRY output = xxx,yyy,zzz can someone help me with query ID Value----------11 aaa22 xxx22 yyy11 bbb22 zzz----------- #Ensemble 0 2 0 103
Question Krishnaveni Kapu · Sep 3, 2024 $ZDATETIME($h,3,1,3) Hi, I am using this "$ZDATETIME($h,3,1,3)" and getting response as 2024-09-03 12:07:45.000But I need proper values at the end instead of zeros (000) Something like below -2024-09-03 12:07:45.658 #Ensemble 1 6 0 192
Question Krishnaveni Kapu · Aug 23, 2024 String to HL7 format I have a requirement where in I had to read a HL7 message string ( which is a String )from a SQL TBL to my Business Service.and I need to convert that string to EnsLib.HL7.Message format and traverse through the PID segment. I need some inputs please. #Business Service #HL7 #HealthShare #InterSystems IRIS for Health #Ensemble #Health Connect 0 1 1 151
Question Krishnaveni Kapu · Aug 7, 2024 DateTimeDifference in seconds Hi All , I have a dateTime in the format = "2024-08-07 17:58:51.563"I need the difference between current date time and above one I need it in seconds. #Ensemble 0 5 0 169
Question Krishnaveni Kapu · Jul 4, 2024 Convert 2024-07-04 13:21:16.477 to 20240704132116 How can I convert From = 2024-07-04 13:21:16.477 To = 20240704132116 #Ensemble 1 3 1 105
Question Krishnaveni Kapu · Jun 17, 2024 xml object to stream I receive request xml object as pRequest = <getURL><Url1><![CDATA[https://test/cs/icdfg?&RevisionSelectionMethod=LatestReleased&allowInter...</getURL> I need to send this to a stream Set XmlStream = ##class(%Stream.GlobalCharacter).%New() // how do I send my pRequest into XmlStream ?? Do httpRequest.EntityBody.CopyFrom(XmlStream) #Ensemble 0 5 0 176
Question Krishnaveni Kapu · Jun 13, 2024 DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd how do I convert DateTime from yyyy-mm-dd hh:mm:ss.000 to yyyymmdd #Ensemble 0 5 0 255
Question Krishnaveni Kapu · Jun 6, 2024 DateTime from yyyy-mm-dd hh:mm:ss.000 to ISO 8601 UTC I receive a time stamp as = 1988-08-18 00:00:00.000I need this to be converted as - 1988-08-18T00:00:00+01:00 #Ensemble 0 1 0 93
Question Krishnaveni Kapu · Jun 4, 2024 Business process terminating Hi , I receive xml as incoming request , I convert that into HL7 in my business process class as below Set tSC = $CLASSMETHOD("myDTL","Transform", .pRequest,.dtlRes) then , I am sending the dtlRes which is a HL7 message to a router "TEST_ROUTER" in the router , I am checking for HL7.{MSH:9.2} , where I am getting below error : #Ensemble 0 5 0 145