Search

question "INSERT OR UPDATE" here. Did you check my answer there? Does the class shown above (looks truncated) has a column that contains a unique constraint? Can you provide the rest of your class, in particular index definitions and the INSERT OR UPDATE statement you are using?

. 👉 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

contest. In this webinar, we’ll show you how to deal with Globals to implement different data models and sophisticated indexes. As always, our experts will answer the questions

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

- Application Errorby Scott Roth Bulk FHIR DataLoaderby Ron Sweeney Compile for a previous version of Health Connect?by Adam Lees Restoring a backupby William Caldwell Indexing

].index('-')]): docSer1 = str(roman.fromRoman(params[i][:params[i].index('-')])) secPart1 = '-' for elem in params[i][params[i

:^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

the methods DisplayToLogical/LogicalToDisplay and/or LogicalToStorage/StorageToLogical. Use %MVR For example:Class dc.test Extends %Persistent { Index ibar On bar; Property bar

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

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

.. 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

INDEX FOR TABLE bidata.ObservationsStg") do $system.SQL.Execute("UPDATE bidata.Observations set p.IssuedTime = s.IssuedTime, p.ObservationCategoryCode = s.ObservationCategoryCode