Search

Clear filter
Question
Mathieu Van Sevenant · Feb 6, 2020

Size Limitation for %ToJSON() with large stream

" = objInObjDoc set httpRequest.ContentType="application/json"do httpRequest.EntityBody.Write(objDoc.%ToJSON())set sc=httpRequest.Post("/index/push", 0) Building
Question
Dmitry Maslennikov · Oct 23, 2022

SQL Query returns sorted Integer ID column as string

an error. FWIW, the reason you're seeing this is that due to the ORDER BY clause we're picking up that id value from the index' subscript rather than from the master map. thanks
Article
Muhammad Waseem · Feb 10, 2023

Getting to know Python Flask Web Framework - Part 2

(to route) in app.py file: from flask import Flask, jsonify, render_template import iris app = Flask(__name__) @app.route("/") def index(): #to render main index
Article
Yuri Marx · Mar 1, 2021

Day 4: Developing with InterSystems Objects and SQL

: user constants or system constants to configure the class behavior; Foreign keys: to referencial integrity; Indexes: to improve performance and do unique values; Triggers
Article
Paul Gomez · Feb 25, 2016

Alert: Incorrect SQL Results

but the problem could happen even if a different table were being changed. Given the following class, User.Test: Class User.Test Extends %Persistent { Index idx
Article
Mike Kadow · May 12, 2016

NewBie's Corner Session 1 Installing Caché

to address me only.See NewBie Index for an index of all NewBie Corner posts. Hi Mike,Might be worthwhile to add a tag for "Newbie's Corner" to make these easier to find. Search does
Article
John Murray · Mar 11, 2016

Using Class Queries - %SQL.Statement versus %Library.ResultSet

should be pretty much the same.If you have a complex query that can't be boosted by adding just another index or by running tune table, you can probably write your own custom logic
Question
Glenn van Bavel · May 4, 2017

SNMP Service can't connect with Caché SNMP agent

:Config port = 1972, SNMP-capable = 116:58:25 : sorted (end) as index[0]16:58:25 :RegOpenKey for mgr dir SOFTWARE\InterSystems\Cache\Configurations\ENSEMBLE\Directory16:58:25 :Open
Question
Nikita Savchenko · Nov 26, 2017

What is the Best Way to Rename Persistent Classes which Already have Data

-null %%CLASSNAME value containing references to old class names. This value is not only in the data global but it will also be present in index globals. Even if you do not rename
Question
Nezla · Sep 4, 2022

System having trouble writing data to disk

, and then after few minutes it is cleared automatically. (e.g. when you rebuild a huge index, or do some data migration process). I would monitor the disk activity for the disk that the WIJ
Question
Scott Roth · Nov 3, 2017

Executing Dynamic SQL as Execute Querry

=query_" (SELECT Patient.Patientkey,ProviderID,RefProv.LastName, RefProv.FirstName " set query =query_" FROM Paceart.PATIENT as Patient INNER JOIN Paceart.PATIENT_PROVIDER
Question
Pradip Patoliya · Jul 7, 2018

Error: CSP application closed the connection before sending a responce

as possible.Thanks in advance. 1. Yes, We have index on PhoneDateODBC2. As i have mentioned that i am using the Intersystem ODBC driver to connect the cache database. And it is failed
Question
Token Ibragimov · Feb 22, 2019

how to convert JSON to object in cache 2010 version

" |%data("expires_in") = 3300 |%data("refresh_token") = "" | %data("scope") = "sms_send" |%data("token_type") = "Bearer" | %index
Question
Goran Stefanovic · Dec 12, 2018

GROUP BY causes NativeError: [10053

by field1This is not the final solution but a way to understand the limits of your server.BTW:an index on field1 might be useful anyhowExampleIndex ff on field1 [ DATA = filed2
Question
Steve Riddle · Nov 9, 2020

Apache RewriteRule on IRIS

; Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted RewriteEngine On RewriteRule "^/foo\.csp" "/bar.csp" [PT] <