I have an a Ens.Request subclass (Invoice) that has a relationship property to another persistent class (InvoiceItems), with properties of its own and the inverse relationship defined referring back to Invoice.
When building a DTL with these classes, the Relationship’s inverse relationship (Invoice, within InvoiceDetails) is displayed.
I am working on a setup using the iris docker image (iris:2020.4.0.547.0). I need the timezone to be a different timezone than the host. Is there a way to do that by passing in an options / variable?
When creating a service with DOCKER SERVICE CREATE we cannot pull from the intranet/local image repository. Both PULL and PUSH can be handled from the intranet repository.
Hello, I'm currently working on a custom version control implementation. I'd like to show differences between a copy of a previously saved routine as a merge of the ^ROUTINE Global and the current version of that same routine.
I've found legacy Documentation for %RCMP which does the trick in the terminal but I'd like a similar result stored inside a variable. I also want to show differences, not only see if they are the same or not.
The management portal has that exact feature, so maybe someone can direct me to the function that is being used there.
How would you recommend us to filter in the message viewer to find inside a property called "mensaje" of type " %XML.GlobalCharacterStream" which is inside a class called" Mensajes.Request.Laboratorio.peticionER7Request", the text "24642"?
The company I work for has one software application that uses an IRIS database, with almost all the others using SQL databases.
On a SQL database, we can create local tables and create views. These are invaluable when it comes to reporting, and everyone here is quite up to speed with using SSMS to create functions, stored procedures, etc.
Can you please guide me on how to programmatically write objectscript task to export audit log to a directory and what type of task should I set it to.
I want to achieve the same behaviour on the code as seen below
I need to create strong random password including letters and integers. Does Cache Object Script has methods to generate password or I have to create my own method ?
Hello, First of all, I apologize if I got the topic wrong. But I'm also looking for the 2007 cache version for Windows x86 / x64. If anyone else has it, or can help me. Thanks
I am having trouble formatting %Time to a JSON format. I have tried configuring the parameter "FORMAT" of my property but that didn't work. For some reason, it keeps putting a Z and the end of the time.
I am still trying to track down orphaned messages and have noticed that when we have Business Rules that send to a Business Process that some times there is an orphaned message that is generated as result of that send.
Is there a way to find the median in Intersystems Cache SQL? I know it is not available as an aggregate function. Also in SQL Server I could try something like:
SELECT
(
(SELECT MAX(Score) FROM
(SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
+
(SELECT MIN(Score) FROM
(SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median
However, there is no PERCENT Keyword in Cache as well. Any suggestions?