Search

the property FullSize in a SQL statement: SELECT ID FROM EnsLib_HL7.Message WHERE FullSize > ? Take care because this is a calulated proprety and doesn't have a index. As others have

, Transient ]; Index PMKey On (Subscript1, Subscript2) [ IdKey, PrimaryKey, Unique ]; Storage MainStorage{<SQLMap name="MainMap"><Data name="Data"><Delimiter>"$c(31)"<

first return to the level of a single index. To do this, use the SetSubscriptCount() method with parameter 1. And further, using the Set() method, simply add subscripts

, this defines their position as arguments.Methods that support a variable arity imply on using three rules:1 - Argument variable must contain the arity size.2 - Argument index starts

{ set tName="*** no file ***",index="" } elseif $D(^ImportFile(file,-1)) { set tName=$O(^ImportFile(file,-1,"Class",""),1,index) } Else { set tName=$g(^ImportFile(file

, please respond through the InterSystems Developer Community, don't send me private email, unless of course you wish to address me only.See "Newbie's Corner Index" for an index of all NewBies' Posts

specific stuff.setup an index on those calculated properties to find your record.With this approach you keep the origin as you get it and get te indices you may require.It's pretty

? We had a similar issue at a site and it turned out the routine index was corrupt, recompiling all routines solved this. Hi, I'm having a similar issue but with purge queries

finishes executing on the server. Query 1 fails because you have to do a join on the two large tables and your only where clause is against a property that is not indexed. Query 2

article here Given that SQLCODE is 100 (in other comment thread), might you have an index on %ConfigName that has not been built? What do you see from the following queries

("Local") = "16@%ZEN.proxyObject" | %data("produto") = "CHP0001" | %index = "" +----------------------------------------------------- https://docs.intersystems.com/latest/csp

of the corresponding properties in your class.Add an index on Root, Lft, Rgt Index TreeIndex On (Root, Lft, Rgt); Compile your class How to use Use %New(), %Save

: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

=> "SELECT * FROM AEADOCTOR " }}output {elasticsearch { hosts => ["localhost:9200"] index => "cachesql"}stdout { codec => rubydebug }} Values looks correct

Extends %Persistent [ SqlRowIdPrivate, StorageStrategy = MyGlobalStorage ] { /// Index Index KeyIndex On (year, key) [ IdKey, Unique ]; /// first key Property year As %Integer