InterSystems Developer Community is a community of 23,408 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

Visual Studio Code for ObjectScript

https://www.youtube.com/embed/1NuBIXBJYsI
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

5 1
0 751

The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"

is there a SAFE way I can give him access to our database using an intelligent visual user interface.

I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.

0 3
0 292
Hello! I have a question how to parse Library.ListOfObjects to JSON

I send post data like this from client using rest and want parse "templates", after save "codeForm","codeName" in database

{
    "whoIs": "",
    "templates": [{
            "codeForm": "FORM_FIOGROUP",
            "codeName": "operationDate",
            "orderNumber": "1",
            "codeFormat": "YYYY-MM-DD",
            "header": "DATE",
            "dbfFormatType": "Date",
            "dbfFormatLength": "8",
            "valueFrom": "Payment"
        }, {
            "codeForm": "FORM_FIOGROUP",
0 4
0 616

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

InterSystems API Manager: Gummy Bear Factories

https://www.youtube.com/embed/v1Gou1A9gtM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
0 201

Hello everyone!

Some time ago, I changed the configuration in SQL Runtime Statistic to "Turn on Stats code generation to gather stats at the Open and Close of a query". With this change, the CACHE base (cache/mgr/cache/) has grown a lot to reach 198GB.

Yesterday, I returned the configuration of SQL Runtime Statistic to the default which is "Turn off Stats code generation" and the cache base is no longer growing.

My question is?

0 3
0 231

Hello,

I have a quick question regarding TSTART, however not certain if there is an answer.

If I am inside the transaction and I loose connection - I always assumed that transaction would TROLLBACK, however it does not.

Is there anything special I need to set up with my TSTART, in order for this transaction to safely rollback?

*********

As example: Let's say I am inside the TSTART and setting up / altering some data and my VPN connection got disconnected. I kind of expect all the data to be rolled back.

Thank you,

Alex

0 6
0 258

I have a vendor that is sending an HL7 message. But when I asked for more detail about their mapping tables, they told me they typically don't supply that but supply an API for customers to call so they don't have to define tables and it is more dynamic.

So with that being said I am creating my first REST operation. I understand the gist of how a REST operation works in working with other types out Non HL7 Operations (SOAP, SQL) before. You send a request and get a response back, that part I understand.

0 14
2 945

Hi Community, you asked and here they are - badges for translations on Global Masters!

Badge's Name

Rules

DC Translator

Given for 1 translation

2nd Advocate level

Counted translations from English to all other language versions of Developer Community.

  • Positive rating (votes up) or zero votes
  • Posts from the Developer Community Feedback group are not counted.
  • Please note, there are 3-days delay between published translation and awarded badge.

Advanced Translator

Given for 5 translations

3rd Specialist level

Bronze Translator

Given for 15 translations

4th Expert level

Silver Translator

Given for 25 translations

5th Ambassador level

Gold Translator

Given for 50 translations

6th VIP level

2 0
0 154

Hey guys!

I started a project in a ready-made production environment, and when analyzing the components I come across a small icon with the number '' 2 '' in Business Services. As the image below:

I've never seen anything like this, I tried to analyze the code but I couldn't identify the source.

Does anyone know what it is?

0 2
0 203

Hello everyone,

I don't want to believe that Intersystems didn't add a method/process/rule to sort alphabetically a list of names (in array, $ LB or whatever)

I haven't found any documentation about this. I've even tried comparing two strings but have not found a solution.

My cry for help is...

Does exists any command to compare two strings and check if one of them is lower or upper according to aphabet?

Please, give me a light in this dark

Best regards.
Kurro Lopez

1 7
0 1.1K

httpRequest POST file Upload multipart

1. is there a code example step-by-step, how to build each part ?

I tried the demo from intersystems doc's,

I checked it in .Net response, that didnot recognize the File-data part

2. I noticed, there is :

SET BinaryMIMEPart.ContentType="application/octet-stream"

but missing :

SET BinaryMIMEPart.ContentDisposition (as analogue, let say for VBA EXCEL )

or I do it via the:

Do BinaryMIMEPart.SetHeader("Content-Disposition",...) ?

that is not analouge for VBA

3 11
1 2.3K
Question
· Apr 23, 2021
Log (Journal) shipping

I am new to Cache, we are trying to move a 4 TB database over the internet, but this will be take too long to copy the single backup file. In Oracle and MS-SQL Server there is an option of doing log shipping. Is there such an option in Cache?

I want to copy the initial backup file one weekend, then keep sending the Journals (logs) the new location.

Thank you,

Eudoro

0 5
0 346

Hi Community,

See how the new embedded Python feature enables you to write user-defined SQL functions and stored procedures in Python:

Embedding Python in SQL: Write Your Stored Procedures in Python

https://www.youtube.com/embed/S7v4zDn0N1c
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 0
0 313
Question
· Apr 22, 2021
Cache code conversion tool

Hi,

I have a requirement to convert few screens having character based interface built in Cache to a web based interface in Java while still keeping Cache as the backend which means database will remain the same. Wanted to know if we have any tool in the market which can help doing that keeping in consideration that these screens in cache are using mumps code.

If we don't have any tool, would appreciate if someone shares their experience in the manual conversion as well.

0 6
0 382

Hi,

we have a EnsLib.Workflow.TaskRequest wich is been send to an operation. The Task request contains a simple object, for that we´ve extendd EnsLib.Workflow.TaskRequest and added the object as an aditional property. The request is successfully created. But how to access the contents of this object from within the user portal when showing the task.

0 2
0 182

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Developer Tools contest.

And here is how projects collected it:

Project docker zpm Unit Testing Online Demo Code Quality Article on DC Video on YouTube Total Bonus
Nominal 2 2 2 3 2 2 3 16
Config-API 2 2 2 2 2 10
Server Manager for VSCode 2 2 4
Grafana Plugin for InterSystems 2 2 2 6
SSH for IRIS container 2 2 3 7
IntelliJ InterSystems 2 2
gj :: locate 2 2 3 7
helper-for-objectscript language extensions 2 2 2 2 3 11
IRIS REST Documentation 2 2 4
IRIS-easy ECP workbench 2 2 2 2 3 11
zpm-explorer 2 2 2 3 2 2 3 16
Git for IRIS 2 2 2 6
zapm-editor 2 2 2 6

0 9
0 243

Announcing gj :: locate. A simple extension for VS Code that will help you get to the source of your errors.

In VS Code, using either the Serenji extension or the basic InterSystems objectscript extension, this small add-on will open the appropriate class or routine and position you at the exact line where an error occurred.

No more tedious counting of lines to find <UNDEFINED>zCredit+206^Ledger.Invoice.1. Instead, with gj :: locate you can get there with just a couple of clicks.

This 20 second video tells it all:

2 2
2 283