Hi all,

I'm wondering if is possible to get the values of itself to run a query.

I want to create some query to find a value into a %Persistent class but each one use diferent values.

Class Kurro.MyClass Extends %Persistent
{

/// Key of process
Property KeyProcess As %String(MAXLEN = "");

/// Specialist
Property CodeSpecialist As %String;

/// Provider
Property CodeProvider As %String;

/// Center
Property CodeCenter As %String;

/// Date
Property Date As %TimeStamp;

/// IdList
Property IdList As %String;

/// IdProcess
Property IdProcess As %String;

/// Duration
Property Duration As %String;

Query GetInfo(pObject AS Kurro.MyClass) As %SQLQuery(CONTAINID = 1, ROWSPEC = "IdList:%String,IdProcess:%String,Duration:%String")
{
    SELECT IdList, IdProcess, Duration
    FROM Kurro.MyClass
    WHERE KeyProcess = :pObject.KeyProcess
    AND CodeSpecialist = :pObject.CodeSpecialist
    AND CodeProvider = :pObject.CodeProvider
    AND CodeCenter = :pObject.CodeCenter
    AND Date = :pObject.Date
}

}

According to IDC, more than 80% of information it is NoSQL, especially text into documents. When the digital services or applications not process all this information, the business lose. To face this challenge, it is possible use OCR technology. OCR uses machine learning and/or trained image patterns to transform image pixels into text. This is important, because many documents are scanned into images inside PDF, or many documents contains images with text inside. So OCR are an important step to get all possible data from a document.

I am getting the below error while navigating a next page from the list in Management Portal

Must have Java Enabled to use hyperevent call

Unable to locate CacheCSPBroker applet!

I have already enabled Java in Java Control Panel 

Any help is much appreciated

Thanks & Regards,

Sadagopan TS

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.

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",
            "codeName": "rrn",
            "orderNumber": "2",
            "codeFormat": "String",
            "header": "REFERENCE",
            "dbfFormatType": "String",
            "dbfFormatLength": "25",
            "valueFrom": "Payment"
        }
    ]
}

Hello all,

I'm a newcomer in ObjectScript and Ensemble and I would like to ask for any help. 

I have a method which is called inside a BPL in order to create or append some data in a file by an operation. This is the current code:

Method GetSMSText(nhc As %String, servicio As %String, hospital As %String, telefono As %String) As %Stream
{
quit 

Someone have experiences interconecting NonStop SQLMP with Iris ?

I need if possible some references or tips, actually connected with JDBC driver to interconnect and take many assorted problems, like :

Some queries, not to much, have null fetch, works fine but have no content to fetch, and i'm sure select sentence is not the problem.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems API Manager: Gummy Bear Factories

Hello,

Am curious if anyone has a working example of IRIS/Ensemble consuming a CDS file and one or two sample CDS files for reference.
Thanks in advance.

I want to consume external websocket api, URL looks like this:

wss://site.com/ws/v2/?&token=<token>

Checked with external tool (Simple WebSocket Client) that websocket works and I can consume the data.
In Cache the relevant functionality is offered by %IO.Socket class.

set sock = ##class(%IO.Socket).%New()
set sock.SSLConfig = "MyEmptySSLConfig"
set sock.TranslationTable="UTF8"
do sock.Open("site.com/ws/v2/?&token=<token>","443", 10,.sc)

However I get this error:

ERROR #7109: Timed out after 10 seconds trying to open stream '|TCP|443|42881' [zOpen+41^%IO.Socket.1:IOT] 

Hello Community,

I need to create a new menu in the inside viewer to create a ZEN screen to make an external call outside the SDA, how can I do this or configure a new menu by calling a .cls?

Are there any BDD testing automation implementations within Mumps/Cache Objects already in existence?
We are looking at using Cucumber for our Java regression test automation and would like to use similar feature file testing with the Cache code.

Looking to use something existing before building it.
Regards,
-Karl

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?

How to delete this data that was created in the CACHE base (cache/mgr/cache/) and what data I can delete without affecting the system.

Thanks,
Fábio Louly.

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

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.

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

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?

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

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

need any code example link, to execute correctly all the multipart (cache call it MIMEtype)

settings

An interesting thing about data is that we can always discover something new.

And with this concept in mind, we create a new page to show a little bit inside the world of ZPM!

Hey Developers,

This week is a voting week for the InterSystems Developer Tools programming contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote and what's new?

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

In addition to IntelliJ IDEA, it's now possible to configure SublimeText3 to be able to compile code there too. And what you will need is just the language server I did.

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

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.

Let me introduce the support of InterSystems IRIS in IntelliJ IDEA. This plugin adds Syntax Highlighting support for ObjectScript, and auto import and compile on the server after saving a changed file. It uses LanguageServer written in Rust, where was added an ability to import and compile code.

NigelTSalm — Today at 23:45

Hi, I am loading zpm for the first time. I downloaded the %ZPM.Installer xml file and then tried to import it trough the Cache Studio. It threw up 4 errors Compilation started on 04/22/2021 23:41:53 with qualifiers 'cukb /checkuptodate=expandedonly' Compiling class %ZPM.Installer Compiling routine %ZPM.Installer.1 ERROR: %ZPM.Installer.cls(ExtractPackage+2) : MPP5610 : Referenced macro not defined: 'FileTempDir' TEXT: Set pFolder = ##class(%File).NormalizeDirectory($$$FileTempDir) ERROR: %ZPM.Installer.

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.

Our TaskRequest contains an object named Patient with some properties. We´d like to display the contents in the tasks description area. WE´ve created an additional template but have a hard time to access the values of the patient object.

Is it possible execute create table from management portal?

I tried this:

CREATE TABLE SQLUser.Teste(ID INT NOT NULL,  coluna1 VARCHAR(255),  coluna2 VARCHAR(255),  coluna3 VARCHAR(255),  coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))

Error message:

Hi Everyone,

In the previous article, we combine ZPM with Config-API to load a configuration on module loading\install.
It could be useful for small applications, but for a large application, it's not convenient.

You can need to create multiple namespaces and install many zpm modules on different namespaces.
Using the configuration document on zpm load\install is a problem for this special case.
Moreover, even if you need only one module and one namespace, ZPM client is designed to install on the current namespace and it's not possible to switch to another namespace during the install.