Search

Clear filter
Question
Scott Roth · Mar 12

SQL Query not transforming into class structure correctly

Persistent [ DdlAllowed ] { Parameter USEEXTENTSET = 1; Property CostCenter As %String(MAXLEN = 15) [ SqlColumnNumber = 2 ]; Property ID As %String [ Required, SqlColumnNumber = 3 ]; Index
Question
Mike Minor · Apr 13, 2018

cache sql insert into external database

SPECMN_COLLECTION_DATE ];Property SPECMNRECVDATE As %TimeStamp(EXTERNALSQLNAME = "SPECMN_RECV_DATE", EXTERNALSQLTYPE = 93) [ SqlColumnNumber = 58, SqlFieldName = SPECMN_RECV_DATE ];Index
Question
Alexandre Mosselar · Jul 11, 2016

How to calculate the percentage of higher level

I'm trying to calculate the percentage of the top level with the SUM function.But I don't understand the PARENT behavior.It does not work in any way!
Question
Ramil TK · Aug 3, 2022

Working With Date and Time

For this type of data, you can make your own indexes for different parts and/or combinations of them: a separate date, a separate time, a separate year, a separate year and month, etc
Question
Timothy Leavitt · Aug 18

Is there a way to drop/remove an inherited setting (from the SETTINGS class parameter) in an interoperability business host?

This query was helpful to identify settings behavior in built-in interop classes: select parent,_default from %Dictionary.ParameterDefinition where name = 'SETTINGS' Include the setting
Question
Krishna Jasti · May 10, 2017

Atelier Intellisense Not Working

Eclipse-based application.I don't know if the current 1.1 beta fixes this issue, nor if it will require a version of Caché greater that the current 2017.1 release in order to solve it (or indeed
Question
Eduard Lebedyuk · Jan 14, 2020

Getting dynamic object from iterator

I get this error on access: <PRIVATE PROPERTY> And the property is indeed marked as private. _sighs_ I should have expected that much. Which version are you using?
Question
Anna Golitsyna · Jul 24, 2024

Undocumented RoutineList features

Is that indeed so? After some system files reading, I discovered that you can EXCLUDE certain routines with ', by using the 'ABC or 'ABC* syntax.
Question
Laura Cavanaugh · Jun 12, 2017

Possible to view the contents of a process private global?

I know the process ID< and I know the global name: ^||testing(index).
Question
Nezla · Apr 10, 2022

SQL query confusion

Host Variables You can also try rebuilding the Index Table or clearing Cached Queries.
Article
Robert Cemper · Apr 25, 2020

Static WHERE Conditions

It is built on by iFind and this older (but worthwhile) community article on custom spatial indices, although in both cases it works hand-in-hand with a custom index (using %FunctionalIndex
Question
Mathew Lambert · May 23, 2018

##class( autocomplete for classnames

With a large codebase, it takes longer to index prior to cache existing, and that is why you encountered the performance hit.
Question
Vivek Ranjan · Mar 12, 2018

Persistent table with %GUID As property

%%GUID" FC381F94-277E-11E8-82F0-005056B479AA The ^OBJ.GUID index that this creates can be accessed via %ExtentMgr.GUID.
Question
Ephraim Malane · Oct 13, 2022

How to convert xlsx to csv

ClassMethod XLStoCSV(source As %String = "/data/sample.xlsx") As %Status [ Language = python ] { import pandas as pd read_file = pd.read_excel(source) read_file.to_csv(source+'.csv', index