Syndicate content 0  
 
All time

Hi Developers,

We're super excited to share with you the new awesome functionality of the Online Analytics Dashboard for every Community member 🔥

From now on, you can see your own detailed statistics for the current week, month, and all time, including:

  • number of views, likes, comments, followers
  • timeline graphics of views, likes, actions with your posts, comments
  • a table containing info about views, comments, and likes for your every post

      11 1
      0 551
      Question
      · Aug 15, 2022
      Security Scans

      We are looking for a 3rd party application that can scan our IRIS based Cache Object Script code for vulnerabilities or coding weaknesses. There are many, many applications/vendors out there that do code scanning but none seem to support Cache Object Script or scanning the IRIS environment. If anyone is aware of a company/product that can scan our code / IRIS environment, I would love to hear about it.

      Thanks in advance for the help.

      Mike

      0 3
      0 568

      Hello everyone,

      I created a Class with this 3 properties

      Class TestDynamic Extends (%RegisteredObject, %XML.Adaptor)
{

Property number As %xsd.string;

Property exam As %xsd.string;

Property result As list Of %DynamicObject;

}

      I'm adding objects to list normally

      set objTest=##class(TestDynamic).%New()
set objDynamic={"field":"value"}
do objTest.result.Insert(objDynamic)

      But when i use this method to convert to JSON

      0 7
      0 564

      Hi:

      I have an sql outbound adapter. Sometimes we have trouble connecting to the database.

      The timeout in develpment is set to 15 seconds in live it is 150 seconds as it is an always connected Buisness operation.

      I thought adding E=S or/and X=S would suspend the message. Why does it not?

      Is the only way around then adding something to the buisness operation itself/ creating a customised SQL buisness operation rather than EnsLib.SQL.OutboundAdapter?

      Thanks

      Mark

      0 5
      0 566

      hi all,

      I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.

      I see the connection format is as "

         jdbc:Cache://<host>:<port>/<namespace>

      "

      What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.

      how can I do that? what will be the format

      0 4
      0 567
      Question
      · Apr 15, 2018
      Indexes in Cache Objects

      Hi-

      I have the following objects

      Class A

      Property P1 As B

      Property P2 As %String

      Property P3 As %String

      Class B

      Property P1 As %String

      Can I create an index in Class A based on P1.P1. Basically I want an index of class A by property P1 in class B

      I tried creating the following but got a compile error

      Index I1 On P1.P1

      Thanks

      0 2
      0 569

      Is anyone using Atelier with 3 environments (instances with multiple namespaces) (DEV, TEST, PROD) using GitHub as the source control.

      I would be interested in how its all setup. So for example;

      Would you have three branches for the code or 3 repo's.

      Would you have three projects in Atelier to communicate with the environments and GitHub?

      I have 3 existing environments that I wish to put under source control and also provide the ability to promote code between the environments in a controlled manner.

      0 4
      0 567

      Hi

      I have been experimenting with the creation of a set of REST services for an app. The basic GET operation is set to create a %ZEN.proxyObject instance, and then set an instance of a Persistant class as a property, which gives me all of the values I want to return. However, it also gives me some values that I don't want to return over REST (because they are both private, and large registered objects which will bog down performance)

      2 3
      0 568
      Article
      · Mar 29, 2023 1m read
      Named Parameter In SQL with Python

      Quick Tips: Total Productive Maintenance

      Named parameters can be achieved with SQLAlchemy :

      from sqlalchemy import create_engine, text,types,engine

_engine = create_engine('iris+emb:///')

with _engine.connect() as conn:
    rs = conn.execute(text("select :some_private_name"), {"some_private_name": 1})
    print(rs.all())

      or with native api

      from sqlalchemy import create_engine, text,types,engine

# set URL for SQLAlchemy
url = engine.url.URL.create('iris', username='SuperUser', password='SYS', host='localhost', port=33782, database='FHIRSERVER')

_engine = create_engine(url)

with _engine.connect() as conn:
    rs = conn.execute(text("select :some_private_name"), {"some_private_name": 1})
    print(rs.all())

      6 0
      0 570

      Hi,

      I have installed Visual Studio on my PC and connecting to IRIS on my Linux server.

      I have installed the InterSystems extensions.

      I click on the InterSystems icon on left->Click on "Choose Server and Namespace" -> Pick my server myTrak.

      However I get this error:
      request to https://mytrak:52773/api/atelier/ failed,
      reason: write EPROTO 18648712:error:100000f7:SSL routines:OPENSSL_internal: WRONG_VERSION_NUMBER:../../third_party/boringssl/src/ssl/tls_record.cc:242:

      0 2
      0 568
      Article
      · Jan 16, 2021 3m read
      Creating and listing XData definitions

      Hi InterSystems Community!

      The ObjectScript language of InterSystems IRIS has the ability to extend classes using a very interesting feature called XData.

      It is a section in your class that can be used to create custom definitions to be used within the class itself and also externally.

      To create one or more XData definitions for your class is very easy, see the example:

      2 2
      0 530

      Hey Developers!

      Do you want to reap the benefits of the advances in the fields of artificial intelligence and machine learning? With InterSystems IRIS and the Machine Learning (ML) Toolkit it’s easier than ever.

      Join InterSystems Sales Engineers, @Sergey Lukyanchikov and @Eduard Lebedyuk, for the Machine Learning Toolkit for InterSystems IRIS webinar on Tuesday, April 23rd at 11 a.m. EDT to find out how InterSystems IRIS can be used as both a standalone development platform and an orchestration tool for predictive modelling that helps stitch together Python and other external tools.

      3 1
      0 550

      Hi,

      I need to route a message synchronously to multiple targets using a routing rule.

      In IRIS I built a general routing rule set, made up of a couple of rules. For one Rule in particular, and based on a common condition, I want to send the incoming message to 2 different targets. (no transformation is used)

      I can select, in the single SEND action, multiple target names, or, I can create consecutive SEND actions, one after the other, each sending to their specific target.

      1 1
      0 569
      Question
      · Jun 14, 2017
      SQL Query for Range

      Hello,

      I have a question related to running an SQL query for range of data.

      I am running a query like:

      Select A,B from table_name where A>=12345 AND A<=12390

      - Where A and B are my two of the properties under the mentioned table/class definition

      - A is an integer property

      Question: The result of the above query does not return me all the values between the mentioned range of integer though I do have all the values in that range. I see that some of the values are missing in result.

      0 9
      0 561
      Question
      · Mar 4, 2017
      Calculated Fields

      1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

      2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

      Thanks!

      0 3
      0 567

      Currently, namespace Alpha is configured to use database AlphaDB as its global database. How would we go about having namespace Alpha configured to use database AlphaDB for its global database except where global ^Customers(CustomerId) has a CustomerId greater than 10M, which we would like to have it redirected to database BetaDB.

      In other words, ^|"AlphaDB"|Customers contains all customers between 1 and 10,000,000; and ^|"BetaDB"|Customers contains all customers greater than 10,000,000. Any help would be appreciated.

      0 4
      0 566
      InterSystems Official
      · Jan 27, 2016 1m read
      OpenSSL 1.0.2

      At the end of this year support for OpenSSL 1.0.1 will end. InterSystems has started the process to move to OpenSSL 1.0.2 and use the 1/28/2016 release (1.0.2f) for verification and product inclusion. I will update this post once InterSystems decided which versions will receive support for OpenSSL 1.0.2.

      0 1
      0 550