Question Thembelani Mlalazi · Apr 5, 2019 How to compare time I am trying to get the time difference between two time stamps one is recorded earlier to the one happening current but the problem is sql expect string while I have the other stored in a variable and if I do the following I get errors any help please &sql(SELECT {fn TIMESTAMPDIFF(SQL_TSI_HOUR,$ZDT($H,3,1,3),tx)}) please note that tx is a variable holding the time formatted the same way as the one being compared to #Beginner #CSP #Databases #Caché 0 3 0 502
Question Thembelani Mlalazi · Mar 25, 2019 How to create dynamical links in csp I have an application using examples from the lottery example in samples name space how do I create a dynamically link based on the data displayed to add a record id to the link the idea is to loop over the records displays fields and link to edit the shown data at the end of the record in a table format #CSP #Caché 0 1 0 273
Question Thembelani Mlalazi · Mar 13, 2019 what is the Bullet point char value in COS what is the bullet point char value in COS the equivalent of • #ObjectScript #Caché 0 2 0 272
Question Thembelani Mlalazi · Mar 12, 2019 String to date I am trying to convert a string to date but can not get it to work I have function that I would like to take in a date string and covert it to date object here is the ezample so far can not get it to work any help appreciated set p="12/03/2019" w $System.SQL.TODATE(p,"YYYY-MM-DD") <ILLEGAL VALUE>todate+32^%qarfunc if I try this still get the wrong value returned set p="12/03/2019" w $ZDATE(p,3) 1841-01-12 #Databases #SQL #Caché 0 6 0 2.8K
Question Thembelani Mlalazi · Feb 21, 2019 Iris or Cache Database and studio For a solo developer developing web applications what will be the best technology to use IRIS or Studio with cache database and containers for deployment #Cloud #Containerization #Development Environment #Caché #InterSystems IRIS for Health 0 2 0 963
Question Thembelani Mlalazi · Feb 14, 2019 HOW TO USE CONDITIONAL LOGIC IN SQL Is there a way or can it be done to use conditional logic in sql like so Query Q1(formal as %String) As %SQLQuery [ Final ] { SELECT patientnumber,ID, CASE WHEN ID = 50 THEN "The is 50" WHEN ID = 30 THEN "This is 30" ELSE "The quantity is under 30" END FROM Audit.Table WHERE ID = :formal AND EndDate is null} } #Databases #SQL #Caché 0 2 0 338
Question Thembelani Mlalazi · Feb 8, 2019 How to get the length of A Segment In HL7 I am trying to get the values of a PID:3 segment to an array but I will need to know the length of the segment to process .set o = ##class(EnsLib.HL7.Message).%OpenId(458)w o.GetValueAt("PID:3")w o.GetValueAt("PID:3").SegCount This throws an error any help appreciated #HL7 #Caché #Ensemble 1 4 0 885
Question Thembelani Mlalazi · Jan 22, 2019 SQL select to a list I need to select my result into a list and be able to loop through the list when query finished any help appreciated here is where I am ##sql(SELECT %ID INTO :IDArray() FROM MergeHyland.TypeTwoDimesionCollection WHERE GUID = :Key AND EndDate IS NULL) for I=1;1:$LISTLENGTH(IDArray) { w $Data(IDArray),i } #Object Data Model #SQL #Caché 0 2 0 1.2K
Question Thembelani Mlalazi · Jan 22, 2019 Embedded SQL How to return a lIst of data I have this query That I am trying to use in my class when testing on the terminal I expect to get the results printed on the terminal but I am only getting zero printed please can anyone out there advice on what I am doing wrong #Databases #SQL #Caché 1 1 0 360
Question Thembelani Mlalazi · Jan 15, 2019 Why <UNDEFINED> on SQL I have an sql statement that I would like to execute but I get the error "zSearchChanges+5^MergeHyland.TypeTwoUtil.1 *KeyID" and here is my sq l "&sql(SELECT Key INTO :KeyID FROM MergeHyland.TypeTwoDimesionalTable WHERE Key = :Key)" any ideas why #Databases #SQL #Caché 0 2 0 203
Question Thembelani Mlalazi · Dec 11, 2018 How to mimic selenium in cache object Script Is it possible to mimic what selenium does like navigating to a site and logging in and filling out a form then logout in COS.I am trying to do that in COS using %Net.HttpRequest class or should I be using a different class the idea is to be able to call a web app login into it and fill out form and log out #API #Beginner #Object Data Model #ObjectScript #REST API #Testing #Caché 0 7 0 523
Question Thembelani Mlalazi · Dec 3, 2018 Rest return 500 error I have an application which is distributed across maybe 5 servers since it has over a thousand users at a time we had an upgrade to the application last week and I had an integration build that uses the REST service ( ##class(%Net.HttpResponse) but since the upgrade the integration has not be able to communicate with the application tried testing my URL through Postman and all seems ok but if I test direct I get a 500 error anything that I need to check on please or any advice on how to check what's going on. #Object Data Model #REST API #Caché 0 2 0 445
Question Thembelani Mlalazi · Sep 24, 2018 How to use com.intersys.gateway.Service I am trying to work with Java Selenium through Cache my java programme works fine but I would like to pass parameters to the jar file form my Ensemble production. #Beginner #Java #Object Data Model #REST API #Caché 0 2 0 530
Question Thembelani Mlalazi · Aug 9, 2018 Atelier1.2 Not Found. Check the web server configurations. I am having trouble configuring the environment in eclipse have download eclipse for java script and web developers followed the video but could not connect to the server I have my Apache server 7.0 added to the java environment and I can start and stop the server through eclipse IDE but when I fire atelier and add server I get the above error any help please .This is the first time I am trying to use the plug in through eclipse .Just in case There is another installation I need to do please advice but I am guessing something to do with atelier not seeing my configurations or permissions #Development Environment #InterSystems IRIS 1 7 0 707
Question Thembelani Mlalazi · Jul 5, 2018 How to access the Header properties of a message in Code I am trying to write a generic process that will take any incoming message but would like to know where it came from so in my code I would like to do something like this If (Document.Source="some serviceorProcess"). Just to be clear in the route you get these features is there a way of accessing them in code #Business Process (BPL) #Object Data Model #ObjectScript #Caché 0 1 0 627
Question Thembelani Mlalazi · Jun 22, 2018 Custom file pass through Operation writing out unreadable pdf files I have a service that takes a file and pass it through to the production .While I am passing the file through I get the file stream and set it to a variable within my message and the variable is of type %Ens.StreamContainer. But after all processing and I need to write out my file to a pdf format The file gets written but is a corrupt file since I can not read it I have tried this with asimple pass through everything is fine .But here I do not know what I am doing wrong here is the operation code #Beginner #Business Operation #Object Data Model #Ensemble 0 11 0 794
Question Thembelani Mlalazi · May 18, 2018 Customising the SimpleBatch GetBatchheader Method I have a csv record mapper that reads in a batch and my batch has a header and trailer that changes all the time but it is of fixed length so I override the Get Batch Header method from the simplebatch class to something like below but my problem is when the batch is read in It still tries to bring in another empty batch like the picture below any reason why that is here is my code.The red code is the changes made. After several trace logs it is being called twice first time with the batch [1] and[5]is the second call how can I stop that from happening #Business Service #Object Data Model #Ensemble 0 5 1 380
Question Thembelani Mlalazi · May 14, 2018 Getting custom messages from a SQL Procedure I have a SQL procedure that I call into and it does some processing and passes back any data validations that fail. I would like to receive those message in my operation and act upon the message received .The question is how do you get output messages from a stored procedure I am using MsSQL 2012 with ensemble #Beginner #Business Operation #Object Data Model #SQL #Ensemble 0 3 0 329
Question Thembelani Mlalazi · May 10, 2018 Terminal Syntax On How to see the contents of a message I have a batch and would like to see the records in it on a terminalFirst will use .%OpenId(Id) then will want to get the first record something around GetAT(1) with this I get the object reference but will actual need to see the data any help #Beginner #Object Data Model #Relational Tables #Terminal #Ensemble 0 1 0 308
Question Thembelani Mlalazi · May 10, 2018 how to read a batch line by line and write that to a file I have a batch that uses the record mapper class .I would like to have a custom operation that will write this batch to a csv file .My operation has a batch as its request and I would like to read that batch data to a csv.So far here is what I have. #Business Operation #Object Data Model #Ensemble 0 1 0 736