Search

and is in increasing trend at ~ 1GB/day? Is it some sort of bug for IRIS for Healthcare to store more index or globals to enable additional capability and features, especially for AI

. 👉 Direct link to join: https://bit.ly/30UV6xp On the agenda this month: 🗞 News https://community.intersystems.com/post/sql-search-index-json-objects

or alphabetical index depending on how we're hoping to organise the data. eg. s NewData(Data(Key,"Name")) = Data(Key) With object classes or mapped globals we tend to use the sql

, GetAt expects a key rather than a numeric index. For example GetAt("ClientAddr") should work. Hello Marc, thank's a lot! I had hoped and suspected that it must be a small thing. Regards, Martin

moving the index global as well. However, if this is not an option then you probably want to do something like: USER>s sql="select Name from %Dictionary.CompiledClass where

}) ~~~ Unlike the in the mgstat file we used in the first part, the header names are in the first row. We want the first column to define our index (this way we don't need to re-index

(ind '= ""){set row = ^CacheTemp(repid,"MAIN",ind)use filemain write row,!; Get next row index for MAIN reportset ind = $order(^CacheTemp(repid,"MAIN",ind))} close filemain

and not as canonical numbers.We can see both in action with the Persistent class. If you create an index on a %Float property then it will canonicalise the string to ensure that all fractional

from the variable subscripts) Define the IdKey index. Define the Storage Definition: Define the Subscripts up to and including the IdKey. Define the Data section. Ignore

Hello, First of all thanks for your time reading our question, and thanks for your replies and help We would need to know if a patient has less than 65 years old, using

.. An index on reg.mnr and bar.invnum will accelerate this. Ok so this is definetely Centricity Business aka Flowcast and not GroupCast. Generally speaking your query looks

an index for that field.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EEDI_search_tablesFields indexed in the search table are listed in the dropdown box

As %String = "", index As %String) As %String { if $isobject(value) { quit value.GetAt(index) } quit "" } } and then, you can use it in this way

private email, unless of course you wish to address me only.See "Newbie's Corner Index" for an index of all NewBies' Posts Hi, Mike! What about the option of passing an unlimited set

:^Package.ClassNameI for index^Package.ClassNameD for values^Package.ClassNameS for streamsCheck the class's Storage XML discover it's global structure. And what this bill says