Hello!

I'm not really familiar with how and if class parameters can be used during runtime or if it is static.

Class %TimeStamp has parameter XMLTIMEZONE [Constraint = "IGNORE, UTC", Flags = ENUM] = "UTC";

I wonder if that parameter can be changed to IGNORE during runtime and in that case how?

For the moment I have created my own type that inherits from %TimeStamp in order to change to IGNORE

Greetings Michael

0 6
0 340
Question
· Apr 22, 2020
FTP adapter

Hi community,

I am now working with an ftp adapter. I have no problem connecting to the FTP server, but there are problems with interacting with files. Has anyone had any experience with an FTP adapter, such as getting/modifying/deleting files?

2 4
0 625
Question
· Apr 22, 2020
SQL Statement Highlighting

Hey Community,

my Caché Version: 2013.1 and can't update now.

is it possible to highlight SQL Statements like in embedded SQL with all the features from SQL Statements?

Actually I use SQL Statements with a simple string like:

set myquery = "SELECT TOP 5 Name,DOB AS bdate,FavoriteColors FROM Sample.Person"

But when the queries are more complex it will be very cluttered and unstructured.

0 2
0 295

I'm looking for any codes that match my parameter that we have received since 1/01/2020 based on the FromTime, EnteredOn or Status (if both are empty).

(Problem[Problem/Code='%1' and FromTime>"2020-01-01"]) | (Problem[Problem/Code='%1' and (count(FromTime)=0 or FromTime="") and EnteredOn>"2020-01-01"])
| (Problem[Problem/Code='%1' and (count(FromTime)=0 or FromTime="") and (count(EnteredOn)=0 or EnteredOn="") and Status/Description="Active"])

This works like a charm with standard XPATH query tools but HS does not like it.

1 2
1 237

Hello every one,

I am a rookie and i am willing to gain some experience on IRIS for Health by doing some development.

I went through the website and found only an online development environment.

But I want to take it a step further ahead bu downloading the software for my own and trying something new.

But, unfortunately I did not find a link to download the IRIS for Health.

I would be pleased if there is any one who has the link to help me out with it.

Hoping to hear soon.

Regards.

Stay Blessed.

1 5
1 1.6K

- Currently we are receiving one NTE (See Below) from the source system

NTE|1|Result Comment|TESTING:\.br\\.br\This is a test results. \.br\\.br\This test is a Test.

- We would like to create multiple NTE segments and send to destination system by using ".\br\"(Line Break)

NTE|1||TESTING:

NTE|2||

NTE|3||This is a test results.

NTE|4||

NTE|5||This test is a Test.

0 1
0 433

<html>
<head>
<title>LabCorp</title>
<link rel="apple-touch-icon" sizes="60x60" href="app-assets/img/ico/apple-icon-60.png">
<link rel="apple-touch-icon" sizes="76x76" href="app-assets/img/ico/apple-icon-76.png">
<link rel="apple-touch-icon" sizes="120x120" href="app-assets/img/ico/apple-icon-120.png">
<link rel="apple-touch-icon" sizes="152x152" href="app-assets/img/ico/apple-icon-152.png">

0 8
1 1.9K
Question
· Apr 20, 2020
How to customize message view?

Due to bussiness requirements.I want to add some bussiness field on intersystem message view ui .

eg:

1. add new action page to display bussiness detail

2. add new function to do more Fine-grained things.

3. add new database field in message table.

finally, I hope get more detail of messae view due to customize it.

Tks.

0 2
0 223

Hi all.

I working with ORU messages where I'm only interested in routing the message to an operation where any of the contained OBR:UniversalServiceIdentifier.identifier segments contains certain values.

The problem I'm facing is that the OBRs are nested within a repeating ORCgrp, which is then nested in a repeating PIDgrpgrp (although the source only ever uses a single PIDgrpgrp).

Is there a simple way of achieving this without a massive OR for each possible ORCgrp value?

0 4
0 641

Hi all,

I have a class that has been working so far :(

The class extends the EnsLib.RecordMap.Service.FTPService class and add some information for each rows.

Now, when it saves the object it is raising the following error

ERROR #5803: Failed to acquire exclusive lock error

I've seen the other question in the community and I've tried to unlock

1 5
0 1.6K

Hey Community,

my Caché Version is 2013.1 and I can't update now.

I want to serialize a SQL Answer row into an Array filled with objects and then convert it to json.

Actually I use the following, which is very error prone when I have to do that often:

0 7
0 785

I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time.

I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes.

0 2
0 195

hi all,

I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.

I see the connection format is as "

   jdbc:Cache://<host>:<port>/<namespace>

"

What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.

how can I do that? what will be the format

0 4
0 516

If two globals have same structure, how to reuse one CacheSQLStorage-based class to read both locations?

Thanks!

Update:

Let's say we have two globals:

^a(1)="dataa1"
^a(2)="dataa2"

and

^b(1)="datab1"
^b(2)="datab2"

i.e. the structure difference is global name only.

I would like to have two classes TableA and TableB both are inherited from TableAB, and TableAB taking global name as a parameter.

2 14
0 687

Hi, I have installed IRIS community version in my laptop which has Windows 10 OS, also I am already using Healthshare (Cache for Windows (x86-64) 2017.2.1 (Build 801_3_18178U)) in the same laptop. I tried to import objectscript package manager XML file which is downloaded from https://pm.community.intersystems.com/packages/zpm/latest/installer . I am getting below output which installation failed. Please help to fix this. Thanks in advance

0 5
0 328