#InterSystems IRIS

Hi folks!

Consider I need to call a python function which name contains "_" symbol (which is quite often in Python). How it could be called from ObjectScript?

E.g. here is the code:

Hi all,

I'm very new to this ecosystem so please bear with me:

I've startted learning online and have installed everything I need. I have VS code and I have most definitely installed the pack (3 packages) needed for working on it with ObjectScript. Even though this is the case I'm running into 2 problems:

1. when I type "class" I only get 4 option for auto complete. no "class with multiple inheritances" or anything of the sort. In fact, no Class at all, only ClassMethod. ClassResponse etc.

We are running a restore of a mirrored database on the secondary mirror member via the DBREST restore procedure.

Since it is run from an interactive session, if the session times out or the vpn is severed, the restore is affected..... is there a way to run the restore in a background process instead ?

Hello, are there any alternative choices for creating forms with a different tool and then integrating them with Intersystems? I want to use Angular to construct forms and integrate the code with Intersystems. Is there anyone out there who might have an idea?

Hi.

I'm trying to serialize property of type %TimeStamp in SQL statement with JSON_OBJECT, but I get a raw string instead of JSON DateTime format string. %JSONExport method on the same object works fine.

Any ideas?

Regards,
Matjaž

I am trying to write the module.xml for a package that creates a web application associated with the %SYS namespace.

Hi all,

I am using %Library.ResultSet to execute my query which I have something like this.
Query GetABC() As %SqlQuery [SqlProc]{

}

After I execute this query and a resultset it returns from this. Now What I want to know is the SQL statement which will have the values dynamically added into while execution.

Hi community.

Yes, I know that there is other question "VS Code - debugging doesn't work" that is the same issue, but my IRIS instance is not using IIS.

Some times ago, I could debug without problems, but after some updates of Visual Studio, I get the following error

Failed to start the debug session. Check that the Intersystems server's web server supports WebSockets

Is it possible see the execution plan of a SQL sentence in IRIS?

Like this:

explain plan for
select  e.ename,r.rname
from    employees  e
join    roles       r on (r.id = e.role_id)
join    departments d on (d.id = e.dept_id)
where   e.staffno <= 10
and     d.dname in ('Department Name 1','Department Name 2');

That returns this:

Is there a way to add/substract from a pivot variable?

I have this MDX:

SELECT
  NON EMPTY [DateOfSale].[Actual].[YearSold].&[$variable.Year] ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

And with pivot variable Year equal to, say, 2016 it works:

Now I want to add previous year first with one pivot variable and one explicit reference. It also works:

Hi

How to install the WebGateway package without interactive mode ?

I need to install this package in apache container

I have a %Persistent class with properties that are of %SerialObject. I want to add an index to a property of the %SerialObject class.

Is this possible?

Hi Friends ,

I have created inbound DB adapter business service. Now my requirement to trigger this service at 10am daily.

I used scheduler , but I don't know when should i configure for stop. this not suits for my requirement.

Is there any other way , where I need to trigger service only once , in configured times.

Thanks,

Prashanth

I am hoping someone can let me know if I've gone down a dark path or not: