Search

Clear filter
Question
david clifte · Oct 5, 2016

How to connect to JDBC database using SQL Gateway

/DocBook.UI.Page.cls?KEY=BGJD_gateway[2] https://community.intersystems.com/product-documentation/intersystems-programming-tools-index%C2%A0%C2%A0%E2%96%B6%C2%A0%C2%A0sql-gateway-connections[3
Question
Rubens Silva · Jun 2, 2017

ResultSet / SQL.StatementResult: How to know if a column value is $list'ed

.%GetMetadata().columns.GetAt(index).colName // and label. Notice that columns must be an instance of %ResultSet.MD.Column. Hi Rubens, Is this what you are after... set rs
Question
Lewis Greitzer · Aug 29, 2017

ad hoc sql service

"it will run every two days"? Or have I misunderstood something? If you have a flag on your database that you set after reading the records, and this flag has an Index, you should
Question
Arcady Goldmints-Orlov · Oct 3, 2017

Querying a list property with SQL

property for it, even though that would make your life easier.First of all, for optimisation purposes, add an index on your list items:Index Bar On MyBars(ELEMENTS); Then use
Question
Jonathan Harris · Jul 7, 2022

Delete first part of HL7 field up to first "(" character

of the last character of the string. This version does not recognize EXTRACT or FIND. Is it possible to do a SubString from an index to the end It seems like they have no function
Article
Sergey Kamenev · May 30, 2017

Globals Are Magic Swords For Managing Data. Part 1

processing works at Visa, according to rumors. However, with globals, we get a structured and indexed storage that you can work with enjoying its high speed and ease of use
Article
Evgeniy Potapov · Mar 18, 2024

Pandas for KPIs in InterSystems IRIS BI

and aggregation: With Pandas it is easy to group data by features and apply aggregation functions (sum, mean, median, etc.) to each data group. Powerful indexing capabilities: Pandas
Article
Dmitrii Kuznetsov · Feb 15, 2021

Four Database APIs

) [ SqlColumnNumber = 9 ]; Parameter USEEXTENTSET = 1; /// Bitmap Extent Index auto-generated by DDL CREATE TABLE statement. Do not edit the SqlName of this index. Index
Article
Lucas Enard · May 3, 2022

Formation on InterSystems' interoperability framework using ONLY Python

FileOperation(BusinessOperation): """ It is an operation that write a training or a patient in a file """ def on_init(self): """ It changes
Article
Tani Frankel · Jan 12, 2017

DeleteHelper - A Class to Help with Deleting Referenced Persistent Classes

:37px;z-index:1;height:0;width:0;animation:gb__a .2s}.gb_wb{border-color:transparent;border-style:dashed dashed solid;border-width:0 8.5px 8.5px;display:none;position:absolute;left
Article
Kurro Lopez · Jun 25

InterSystems for dummies – Machine learning II

Now… training. You already know the command for that: TRAIN MODEL WeatherForecast Be patient! This training took 1391 seconds, wich is approximately 23 minutes!!!! Now
Article
Lucas Enard · Jun 3, 2022

Questionnaire & Forms in FHIR : From creation to usage

](https://github.com/lhncbc/lforms-fhir-app) you can manipulate, as if you were a Practitioner, Questionnaire and Response for each and every Patient on your FHIR server
Question
Aaron Bentley · Oct 23, 2018

Creating complex JSON objects and accessing elements within

is an example of the JSON I'm hoping to model into a class: { "tag": "post", "body": { "patient": { "site": [{ "code": "string
Question
Fabian Pie · Jan 19, 2019

Node.js Iris retrieve

you Robert !!!I want to implement the ClassMethod without having to iterate the whole base, something using indexes and also get sorting. I was taking a look to ObjectScript
Article
Benjamin De Boe · Aug 4, 2016

Creating a domain with the iKnow Domain Architect

exactly is a domain? A domain is a repository for the concepts and their context iKnow produces while indexing one or more bodies of text, made available for querying through the COS