go to post Warlin Garcia · Jul 1, 2022 It is a best data management practice to add restrictions to fields if they have them. So adding the maxlen is "recommended" Adding the maxlen won't result in wasted storage since storage is not reserved based on field definitions. If that were the case, in your particular scenario, you'd be actually saving storage since all string fields are defaulted to maxlen = 50 if you don't specify a value.
go to post Warlin Garcia · Jun 29, 2022 Maybe I'm missing something, but, beyond how nulls are treated, if you want parent to be unique within this definition you must define a unique index on parent (alone). The index you have defined only guarantees that the combination (parent, name) will be unique. Even if you declare the property as required it wouldn't still solve the uniqueness requirement.
go to post Warlin Garcia · Apr 6, 2022 You need to use HyperEvents to accomplish what you want. Use #server or #call. Although if I'm following your use case #server is the right one. In the corresponding javascript function you'll have code similar to myfunction() { ... var myvar = #server(mycachemethod()); //check myvar value // return true or false based value }
go to post Warlin Garcia · Apr 6, 2022 Guessing a typo(copy paste from SetQualifiers?) in the documentation. It should say "...otherwise it gets the default qualifiers for this namespace."
go to post Warlin Garcia · Mar 24, 2022 It depends on table definition. If you define your table with a PK that is not auto-increment (default) then you sure can pass your own ID. You can assign your own ID: CREATE TABLE mytable (field1 INT PRIMARY KEY, field2 VARCHAR2) https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
go to post Warlin Garcia · Mar 14, 2022 Journal files are also exposed as SQL (readonly) tables. In theory, you could write SQL statements to search/filter.
go to post Warlin Garcia · Mar 9, 2022 Few options without knowing much about current setup and the use case (eg. how much involvement you want to have in the process) Synchronizing(shadow) between the 2 instances - Global export/import Global mapping from one instance to another You could merge global from source to target File transfer (traditional ETL) and manipulating the global directly (risky but doable)
go to post Warlin Garcia · Feb 17, 2022 Try looking at this https://github.com/intersystems-community/iris-driver-distribution Even though the driver is listed in maven repos it doesn't download. You need to [manually] include the library in your project.
go to post Warlin Garcia · Aug 5, 2021 Also, any indices on such field would need to be rebuild. Indices on %String properties are expected to start with an empty space thus your queries using these indices won't return any existing (non-updated) rows.