go to post Eduard Lebedyuk · Jun 11, 2018 What's the purpose of a normal index over a text field? I assume user searches by a substring. There are two and a half ways to perform a fulltext search:Define a property of %Text type and use language class. New language classes an be added fairly easily. Documentation. Removed in InterSystems IRIS and therefore not recommended.Use iFind indices. They are highly customisable.Use iFind indices creatively. You can build your own indices based on iFind indices and you can write your own tokenizers, etc. Also it's possible to define your own custom index. Community article on that.
go to post Eduard Lebedyuk · Jun 9, 2018 Yes. I set use locale defaults to true and rebuilt the cube. After that Analyzer started showing localized date values.
go to post Eduard Lebedyuk · Jun 9, 2018 What do you mean? How does it look in config file?In the best case like this: { "storage-driver": "devicemapper", "storage-opts": [ "dm.directlvm_device=/dev/xdf", "dm.thinp_percent=95", "dm.thinp_metapercent=1", "dm.thinp_autoextend_threshold=80", "dm.thinp_autoextend_percent=20", "dm.directlvm_device_force=false" ] } Docker documentation explains setting direct-lvm in detail.
go to post Eduard Lebedyuk · Jun 9, 2018 There are system implementations too: >write $$toRoman^%bi.SWr.FolderTest(124) CXXIV >write $$toRoman^%bi.SWr.FolderTest(1245) MCCXLV
go to post Eduard Lebedyuk · Jun 9, 2018 If you're sure that all your keys are consecutive integers, then use $order to get the last element, which would also be a count of them: write $order(a(""),-1)
go to post Eduard Lebedyuk · Jun 7, 2018 I'd start with setting the credentials in connection configuration. Should be enough.
go to post Eduard Lebedyuk · Jun 7, 2018 If you want to connect to external database, couldn't you just provide domain name and password and authenticate with that?
go to post Eduard Lebedyuk · Jun 7, 2018 KILLdes is a record for kill of descendents journaled as part of a higher-level kill inside of transaction.So it's a Kill command.
go to post Eduard Lebedyuk · Jun 7, 2018 %DeepSee.Utils:%FormatDate offers this optionsFormat a date value (in $H format) according to the format in pFormat. The format string can contain:"y" - Year number (4 digits)."q" - Quarter number."m" - Month number, with no leading zero."mm" - Month number, with leading zero."mmm" - Short name of month (using server locale)."mmmm" - Long name of month (using server locale)."d" - Day number, with no leading zero."dd" - Day number, with leading zero."ddd" - Short name of day (using server locale)."dddd" - Long name of day (using server locale)."\x" - display character "x"" " - space"/" - "/""-" - "-""." - "."Added mm as Time Format and rebuilt cube. Got 01 instead of JAN.Removed mm. Turns out, all you need to do is to use locale defaults in Locale Settings
go to post Eduard Lebedyuk · Jun 7, 2018 Not that Count approach is while easiest, can significantly slower the query down.Extending the adapter so you have an "after all rows" callback has speed advantage and also you wouldn't need to rewrite your queries to add Count().
go to post Eduard Lebedyuk · Jun 6, 2018 Follow these steps:Change superclass from %Persistent to %RegisteredObjectDelete Storage part of class definition.Compile.Table should be gone after that.If you already deleted the class in Atelier (and synced that change with a server) the the table would be gone too.
go to post Eduard Lebedyuk · Jun 6, 2018 Use Send method: Set httprequest = ##class(%Net.HttpRequest).%New() Set httprequest.Server = "www.intersystems.com" Set sc = httprequest.Send("PATCH", location, test, reset)
go to post Eduard Lebedyuk · Jun 6, 2018 Do you wan to do something specific with the last row or do you just want a callback after all rows?If it's the later, you can subclass SQL inbound adapter: Class Project.Ens.Adapter.SQLInbound Extends EnsLib.SQL.InboundAdapter { Method OnTask() As %Status { Set sc = ##super() // all rows were just processed // add your logic here Quit sc } } Other approach is to UNION a dummy row to the end of your query, or add COUNT() property.
go to post Eduard Lebedyuk · Jun 5, 2018 Pinging @Alexander KoblovIsn't it more like anonymous functions?Currently not possible. Check @Gilberto Junior solution - it seems the closest to what you want.
go to post Eduard Lebedyuk · Jun 5, 2018 Like this? write $case(condition, 1:"hello " _ "world", 2:"name", :"!") Hello world is a multiline expression.
