Search

Clear filter
Article
Daniel Kutac · May 3, 2017

InterSystems IRIS Open Authorization Framework (OAuth 2.0) implementation - part 3

.AccessTokenPersistentOAuth2.AccessToken stores an OAuth 2.0 access token and its related information. This is an OAUTH client copy of the access token.OAuth2.AccessToken is indexed
Article
Oliver Wilms · Nov 22, 2020

What else can Feeder do

runs TestProduction, it generates a new Log Index in Unit Test Portal and it increments ^myUnitTests global where data about each Unit Test gets stored. Persistent class
Announcement
Anastasia Dyubaylo · Apr 7, 2022

InterSystems Global Contest Bonuses Results

Data-model implementation Functional index implementation Data Move usage Embedded Python Docker ZPM Online Demo First Article on DC Second
Question
tom whalen · Jun 29, 2022

Measuring Global References

is and there are "correct" indexes, the smaller the GREF and, accordingly, the shorter the execution time. But this is influenced by many factors, not just the above: see InterSystems SQL
Question
Timothy Leavitt · Jan 3, 2023

Putting standard CSP login in front of a web application with a REST dispatch class

and REST itself. And the main cause to do so is that the internal webserver did not accept index.html as default index. So, it required to putting it manually to the URL, or using
Question
Pedro Lopes · Feb 3, 2023

List properties

i - Index j - Projection m - Method n - Constraint o - System method p - Parameter q - Query s - Storage defintion t - Trigger u - Comment text block x - XData Create
Question
John Bland · Jul 24, 2019

Using Relationships

definitions, because when i execute the second SQL on my classes and some random data, it will show the results i expect :(maybe you need to re-index your tables) Also check
Question
Stella Ticker · May 26, 2021

SQL Data Import Wizard with into table with %Library.TimeStamp and %Boolean datatype columns

format: YYYY-MM-DD Time format: hh:mm:ss TimeStamp format: ODBC Format Disable validation? No Defer Index Building with %SortBegin/%SortEnd: No
Article
Eduard Lebedyuk · Aug 9, 2016

Tips & Tricks - Process-private Globals as a class storage

%Persistent { Property Value As %String; Index IDKEY On Value [ IdKey, PrimaryKey, Unique ]; Method %OnNew(Value As %String = "") As %Status [ Private, ServerOnly = 1
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