go to post Eduard Lebedyuk · Dec 30, 2021 Execute the same query in ObjectScript process and check %objlasterror - maybe there would be additional info. For a given table does this happen on the same row? Same rownumber? Random row? If it's the same row - which one? Calling @Benjamin De Boe.
go to post Eduard Lebedyuk · Dec 30, 2021 Each individual tag can belong to only one namespace. Just add all the tags with their relevant namespaces and it should work.
go to post Eduard Lebedyuk · Dec 29, 2021 Have you followed Setting Up Your Project steps? If so, which step presented challenges? It can be any directory your user has full RW access to.
go to post Eduard Lebedyuk · Dec 24, 2021 To integrate your IDE with Git you need to use Source Control Hooks, for example Cache-Tort-Git UDL (but many others are available, I just use this one). Git in general and it's use as a part of CI/CD pipeline is described in this series of articles.
go to post Eduard Lebedyuk · Dec 24, 2021 New (2016.2+) Dynamic Objects support NULLs: set mynull={"def":null} set mynull2 = {} do mynull2.%Set("def","","null")
go to post Eduard Lebedyuk · Dec 20, 2021 You can set ..HTMLZIPDoc.Filename to any filepath you need.
go to post Eduard Lebedyuk · Dec 17, 2021 You can use %NOCHECK %NOLOCK to speed things up. Work Queue Manager can be used for parallelization.
go to post Eduard Lebedyuk · Dec 17, 2021 Properties are recalculated so it's enough to execute this query once: UPDATE <DOC TABLE CLASS> SET %Doc = NVL(%Doc||' ', %Doc) I'm not sure how to trick SQL engine into updating the value without changing it completely but just NVL(%Doc, %Doc) does not work. Adding empty space after json does not affect it. For DocDB indexed properties are defined as Property firstName As %String [ SqlComputeCode = { set {*}=$$%EvaluatePathOne^%DocDB.Document({%Doc},"$.firstName")}, SqlComputed, SqlComputeOnChange = %Doc ]; So updating %Doc does the trick. Also add: WHERE <NEW PROPERTY> IS NULL to recalculate only for documents where a property value is missing.
go to post Eduard Lebedyuk · Dec 17, 2021 Try it like this: new reader,sc,data,xmlSignature set sc=reader.OpenFile(file) quit:$$$ISERR(sc) sc set document = reader.Document do reader.Correlate("Signature","%XML.Security.Signature") if 'reader.Next(.xmlSignature,.sc) { quit sc } quit xmlSignature.ValidateDocument(document) From docs.
go to post Eduard Lebedyuk · Dec 17, 2021 Note that it requires that you're the only writer on the system during that update.
go to post Eduard Lebedyuk · Dec 16, 2021 There are two options: Use SQL Gateway to create Linked Tabled from Oracle (if there are a lot of tables it might be better to create a linkage with a view). After that query Linked Table same as any normal InterSystems IRIS table using the code snippet above. Write a service with the EnsLib.SQL.InboundAdapter to query Oracle database. In that case you need to implement a CSV writer.
go to post Eduard Lebedyuk · Dec 13, 2021 Use three repos: dbLib, dbA, dbB. Add dbLib as submodule to both dbA and dbB.
go to post Eduard Lebedyuk · Dec 6, 2021 Only if the property becomes calculated after being stored which I don't see happening that often.
