All
Accepted answers
Eduard Lebedyuk · Apr 27, 2020 go to post

You should do that on a client (JS) side and send device info as a part of your POST request.

UserAgent can be retrieved from:

%request.UserAgent

and you can try to map that to device.

Eduard Lebedyuk · Apr 26, 2020 go to post

You can try this to create XLSX files from SQL queries (in the same project there's also XLS exporter).

Another option would be to export CSV and use LibreOffice to convert it to XLSX (among other formats). Here's how.

Eduard Lebedyuk · Apr 26, 2020 go to post

First of all, I'd really like to recommend you to upgrade to InterSystems IRIS.

You can still set query timeout as a part of JDBC connection string if it is available in external DBMS implementations.

Eduard Lebedyuk · Apr 26, 2020 go to post

Call it?

First argument is the statement index and the second is how long to wait in seconds.

I would recommend setting this parameter as a part of JDBC connection string if applicable - it is available in some DBMS implementations.

Eduard Lebedyuk · Apr 24, 2020 go to post

Would be a great language to add.

Are you interested in calling Rust code from InterSystems IRIS or interfacing with InterSystems IRS from Rust?

Currently you can use Callin/Callout functionality for C/C++ and calll that from Rust.

A while ago I was trying Rust and successfully transpiled C callout library into Rust callout library and compiled it as Rust shared lib and it works (callable from InterSystems IRIS).

For this community project to take off two issues need to be solved:

  • Doing something with a lot of generated boilerplate <- Easy part, can probably just dump it into external file as is
  • Generating appropriate ZFEntry table. <-Probably possible but I have not researched the issue so far
Eduard Lebedyuk · Apr 24, 2020 go to post

Easiest way to do that is to add a favorite:

set sc = ##class(%SYS.Portal.Users).%AddFavorite("Community","https://community.intersystems.com")

And your portal now looks like this:

Eduard Lebedyuk · Apr 24, 2020 go to post

Every time you interact with the page your session is extended for session timeout.

If there's no interaction from user after session timeout the session dies and cookie becomes invalid.

You can adjust session timeout parameter in web application settings.

Eduard Lebedyuk · Apr 23, 2020 go to post

VisitTime  (any property really) should be stored before property parameter change.

Can you try to recreate the data?

Eduard Lebedyuk · Apr 23, 2020 go to post

You should set it as your property parameter:

Class MyClass {

Property CreatedOn As %TimeStamp(XMLTIMEZONE  = "IGNORE");

}

In runtime the behavior for your property CreatedOn would be IGNORE.

Eduard Lebedyuk · Apr 22, 2020 go to post

Offtopic but generic JDBC provider for SQLAlchemy has been discussed for years in Python community but nothing has been done.

Eduard Lebedyuk · Apr 16, 2020 go to post

Well, %Collection classes are the implementation of these constructs:

  • Property X As List Of Type
  • Relationships

You can call their methods but do not explicitly create objects of these classes.

Eduard Lebedyuk · Apr 15, 2020 go to post

There is actually. %GetSerial method builds a $lb from %ListOfDataTypes and %SetSerial does the reverse.

Both of these methods are private though. You can subclass %ListOfDataTypes and publish them.

Eduard Lebedyuk · Apr 15, 2020 go to post

I advice solving your problem by tightening security.

Your app user should have access only to the tables needed for the application to run.

If the user doesn't have any additional/admin roles, he won't see any other tables.

Eduard Lebedyuk · Apr 15, 2020 go to post

I think fairly straightforward approach works best

set l = ##class(%ListOfDataTypes).%New()
do l.Insert(1)
do l.Insert(2)
do l.Insert(4)
set lb = ""
for i=1:1:l.Count() { set lb = lb _ $lb(l.GetAt(i)) }
zw lb
>lb=$lb(1,2,4)
Eduard Lebedyuk · Apr 6, 2020 go to post

How do you import an HL7 Schema from ObjectScript?

You can call any method with Invoke.

I'm not aware of anything HL7 specific in %Installer, but maybe HealthShare has something.

Eduard Lebedyuk · Apr 1, 2020 go to post

I suppose I can have one Id column and several col1, col2 ..., colN columns, so losing the names.

Eduard Lebedyuk · Apr 1, 2020 go to post

Thank you for the info, Daniel!

Can I implement %GetProperty instead of specifying the list of properties explicitly?

I don't want to compile a new class for each new table-object.