This is the first in a pair of articles on SQL indices.

Part 1 - Know your indices

What is an index, anyway?

Picture the last time you went to a library. Typically they have books sorted by subject matter (and then author and title), and each shelf has an end-plate with a code describing the subject of its books. If you wanted to collect books of a certain subject, instead of walking across every aisle and reading the inside cover of every book, you could head straight for the bookshelf labelled with your desired subject matter and choose your books.

A SQL index has the same general function:

I am experimenting with Relationships, both Parent to Child and One to Many.

I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?

Thank you in advance for any help provided.

Hello Guys,

Can someone help me?

I'm triggering a Rest Services, my JSON is a String variable(Request.JSON), when I pass it on EntityBody.Write, WS returns me the 403 error.
When I pass Obj = {} it responds by saying that no Data has been sent.
So, my problem is to set the "Obj" with the String variable, I should convert it, correct?But how do I do this?My JSON is all in this variable.

MyCode:

        Set Dados = ##class(%Net.HttpRequest).%New(),
            Dados.Authorization = pBearer _ Request.Token,
            Dados.ContentType = "application/json"
 
        $$$TRACE(Dados.Authorization)

Some weeks ago, I was reading a book by Stephen Hawking and Leonard Mlodinow, The Grand Design. At a certain point, trying to define why do we exist? , why do we use the models we use in physics?, ...those kind of things you know... they pointed at the Game of Life example invented by the mathematician John Coward in 1970... Basically he wanted to show that a system with really basic fundamental laws (Physics) could evolve and "live" to become a more complex system (Chemistry) in which "something" (humans) could work out its own model and complex rules to explain its reality… the rules for this deterministic model that he exposed were so basic that I thought it could be funny to implement them in ObjectScript when I had some spare time... there are others implementations in JavaScript and other languages... but not in ObjectScript... and that had to be corrected!!… so here you are!

Hello,

Recently I have been required to work with a method called ExportToStream.

The situation asks me to export a UTF-8-encoded JSON as a XML to be imported on old releases. Here's how I attempted to fulfill this request:

do $System.OBJ.ExportToStream("path/to/my/json/file.json", .stream,,,"UTF8")

The file is indeed encoded as UTF-8 and although the XML header denotes that it has been exported as UTF8:

<?xml version="1.0" encoding="UTF8"?>

The body content seems to differ:

"text": "Condição de pagamento sujeito a análise de crédito: "

I will say it again, the original file is encoded

Hi Community,

We introduced 2 new tags for the posts:

➡️ InterSystems API Manager (IAM)
➡️ IntegratedML

Please check the full list of DC tags.

Leave your requests for other new tags to introduce! 👍🏼

Hi Community!

We are glad to invite every developer who uses ObjectSript and VSCode plugin to the upcoming "Introduction to VSCode-ObjectScript" webinar on April 14, 2020 at 11:00 EDT. 

Speaker: @Dmitry Maslennikov, InterSystems Developers Advocate, CTO at CaretDev.

You will learn how convenient the development process can be already right now and what we are going to do next to make it even better.

Please check the agenda below.

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.

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

Hello all,

I'm new to the Intersystems development world and I've been trying to figure out how to make a REST API using ObjectScript. I found a tutorial that I've been following that has been great and I'm trying to translate what I've learned to live data.

My question is "Is there a way I can set a variable inside of a class so when I call a routine that variable will be recognized?" I'm capable of setting the variable in a terminal session and then calling the routine and everything will be work great!

Hi,

Is there a way to hide a property in Data Transformation UI in Interoperability for IRIS?
I would like the property not to appear in the list of available properties to set.

Thanks,
Blaise

Hi,

Newbie Question.

I have a Staging table i want to populate by running a Stored Procedure  and then query the same table with some sort of SQL inbound Adapter.

is this possible or do i need to create a separate service for this? 

Thanks

InterSystems IRIS latest release (v2020.1) makes it even easier for you to build high performance, machine learning-enabled applications to streamline your digital transformation initiatives.

Join this webinar to learn about what's new in InterSystems IRIS 2020.1, including: 

• Machine learning and analytics
• Integration and healthcare interoperability enhancements
• Ease of use for developers
• Even higher performance 
• And more... 

As per title, is it possible to print from meditech to an ensemble interface directly and has anyone done it?

I see meditech has a port and host option for setting up a printer, so I'm curious.

Hi Community,

New reward available on Global Masters Advocate Hub! Please welcome: 

⚡️ Your Webinar supported by InterSystems ⚡️

Would you like to hold a professional webinar for developers and tell about your solution/tool and your company services? 

Redeem this prize for 3,000 points and we will help you to organize it! 

Hi Developers,

Please welcome a new video on InterSystems Developers YouTube Channel:

⏯ Machine Learning 201: Deep Learning

Hi,

There is a way to start and stop production from command line ?

I know you can configure auto-start on the web interface but I need to start specific production on a shell script.

Thanks!

Hi Community!

Enjoy watching the new video on InterSystems Developers YouTube and learn about IntegratedML feature:

⏯ What is IntegratedML in InterSystems IRIS?

Hey Developers,

We're pleased to invite you to the upcoming webinar "Best Practices of In-Platform AI/ML" by InterSystems on April 3rd at 10:00 (UTC+3, Moscow time)!

Hi Community!

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ Managing the Transition from On-Premises to Cloud-Based SaaS

Hi everyone,

Are there any tools to check the code coverage and to do a lint check for cache object script? Developers will be working with HealthConnect (IRIS based)

Thanks.

Hi, this might be a silly question, but how can I start a job in ensemble? I am getting the update button, and my business service is not restarting.

it says 1 new job to be started, but where can I start the job? Would appreciate your help on this

I have Mac OSX and Docker Desktop 2.2 (Engine 19.03).

I have a REST service running on my localhost (Mac) and I was trying to consume it from IRIS running in a Docker container.

If you try something like that don't use localhost as HTTP Server setting (using a Business Operation for example).

You have to use host.docker.internal.

Hi All,

i searching for a sample, how to create a CSP Page in cache 2017.2, witch show a Tables result in a grid.

To someone knows a tutorial, or a documentation?

THX an 

BR

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

Hello, everyone, 

InterSystems Certification has designed another certification exam and we need input from our community to help to validate its topics.  Here's your chance to have your say in what makes an expert in system administration with InterSystems Caché or IRIS. And, yes, we'd like to hear from you Caché admins!

Here's the exam title and the definition:

InterSystems IRIS System Administration Expert

An IT Professional who:

• designs, installs, and maintains complex InterSystems IRIS environments, and
• ensures data security, integrity, and availability. 

So, how can you help?

Full-Stack JavaScript development allows you to create state-of-the-art applications with Caché. With any (web) app you build nowadays, one has to make a lot of architectural decisions and you want to make the right ones. With the Node.js connector available for Caché, you can create a very powerful server side application server, allowing you to use the latest JavaScript technology and frameworks client- and server-side.

With all these new technologies, the most important is to integrate them in the most efficient way and to create a very productive development experience. This article willl get you started step-by-step with Node.js technology.

In Episode 7 of Data Points, product manager @Carmen Logue joined the pod to tell us all about InterSystems Reports — the new reporting feature of InterSystems IRIS! Take a listen to hear about its capabilities, use cases, and how it fits into the existing set of analytics technologies.

I'm happy to announce the release of the interface to Julia programming language for InterSystems IRIS. Execute Julia code and more from InterSystems IRIS. This project brings you the power of Julia right into your InterSystems IRIS environment:

• Execute arbitrary Julia code
• Seamlessly transfer data from InterSystems IRIS into Julia
• Build intelligent Interoperability business processes with Julia Interoperability Adapter
• Experiment in Julia Shell, right inside your InterSystems IRIS terminal

Julia Gateway is a community project, available on OpenExchange. Julia Gateway is available on Windows,

I'm having trouble trying to navigate XML files USING the %XML.TextReader. I have read https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GXML_textreader#GXML_textreader_creating_method
but I still don't really understand. 

I have the following block 

while textreader.Read()
    {
       
    set practices= practices_textreader.Name_":"
        If textreader.Value'="" 
        {
            set practices= practices_textreader.Value_" "
            }
            else{ set practices= practices_"NOVALUE" _" "}
            
        }         write practices

The xml for all intents and