Hi everyone,

Im new  in cache, i came from Java and im missing some features that i couldn't find in the documentation,  I hope you can help me with this questions.

Just a brief introducction: 

- Im in a project with old cache version, so saddly i can't use Eclipse + Atelier, so im using Studio.

- Currently im in a project with persistent classes, we want to turn apart the globals and focus on tables. 

The questions:

Is there any way to make something like hibernate for cache %Persistent classes? For example, if i want to get all the records for a table in Java+Hibernate+Criteria i'll do something like this:

myListOfObjects = myPersistentClass.list(); // Equivalent to SELECT *

In cache i have to  create a %SQL.Statement, put the query inside and get the recordSet, iterate it and then get a list of %Persistent objects, for every object i want to use it.

Last answer 8 hours 11 min ago Last comment 1 hour 58 min ago
0   0 5
65

views

0

rating

Hi,

recentley we started to work with Atelier & VSTS in our organization .

we are looking for a way to use the VSTS as Our Version/Source control system .

I have read the article about "Continuous Delivery of your InterSystems solution using GitLab" & now trying to find a way to use a similar metodology with the VSTS that we have in our organization.

It Apeares that it is possible to Create a Git Repository in the VSTS but i'm not sure how are we to use it from the atelier.

The main questions are

Last answer 6 hours 36 min ago Last comment 2 hours 53 sec ago
0   0 3
94

views

0

rating

In our table, we have a column cities,  which has a filter which displays the cities of a state depending on the state

For simplicity let's assume we have a page

Property State As %String =  "CA"

Our filter should run this query to show all cities of state ca

"SELECT Name FROM City WHERE State= "_%page.State

<tablePane>

Last answer 3 hours 19 min ago Last comment 3 hours 20 min ago
0   0 3
71

views

0

rating

Hi all,

I wonder how to sync my server code to my local code using Visual Studio Code.

Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.

I thing i shouls opening the ObjectScript: Explorer and select the code directaly, and right click -> Import and compile current file (Ctrl + F7)

If I use this command, the ouptut window shows

Last answer 1 days ago Last comment 8 hours 28 min ago
0   0 3
41

views

0

rating

Hi Everyone,

We have previously implemented CI/CD for Ensemble using GitLab hooks where we had One Production file - MyProduction.xml in all branches (Dev, Test, Prod) but developers merged Items that they built (new Business Services , Processes etc) into the Production class from another branch (for ex - Dev branch to Test Branch production class) and commit taking the changes to the higher branches. I have also seen customers having Three production classes in the names of the Servers eg  - Dev.xml, Test.xml , Live.xml under production folder in Studio. And run only on production on each Server based on if it is Dev or Test or Live Server . This gives access of these files to all Devs so they merge changes under one place and keep it in all Branches. 

My Questions are -

0   0 1
0

answers

0

comments

8

views

0

rating

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

  • Git 101
  • Git flow (development process)
  • GitLab installation
  • GitLab Workflow
  • Continuous Delivery
  • GitLab installation and configuration
  • GitLab CI/CD

In the first article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software.

In the second article, we covered GitLab Workflow - a complete software life cycle process and Continuous Delivery

Last comment 9 hours 2 min ago
+ 2   0 5
652

views

+ 2

rating

Hi, 

Most of my development experience is with HL7v2 interfaces and I don't have a background in web development and I'm very weak with javascript.

I'm looking for suggestions of learning resources to learn FHIR  and 'SMART on FHIR' (JavaScript, OpenID connect, OAuth2) for developers like myself who mostly do HL7v2 integrations - but see FHIR as the future - and want to develop their skills!

I've found these 

Please respond if you found any resourses that helped you in learning FHIR and SMART on FHIR (javascript/FHIR/OpenID Connect/OAuth2)

TIA

Last answer 10 hours 19 min ago
0   0 2
0

comments

22

views

0

rating

We at George James Software are pleased to announce that our acclaimed code debugger and editor Serenji is now available as a Visual Studio Code extension.

As well as supporting the latest InterSystems IRIS platform Serenji also works with earlier platforms, including versions lacking the server-side Atelier API support required by other VS Code extensions.

Serenji connects you directly to the code in your namespaces, resulting in an experience more familiar to existing Studio users. No need to export and import classes and routines.

We believe Serenji is the first extension to bring VS Code's powerful debugging features to ObjectScript developers.

Last comment 16 hours 42 min ago
+ 4   2 6
397

views

+ 4

rating

Hi All,

I have two tables LB_TestSet and LB_Transfer

LB_Transfer has a list if TestSet row IDs, so i am doing the following join

SELECT 
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSet 
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' AND  '2019-05-10'

 

Without the date filter the query returns data, but if i add the date filter no data is returned

I also tried using %INTERNAL, %EXTERNAL TO_DATE('2009-01-01','YYYY-MM-DD')

if i filter by RowID for example the filters work.(this is to make sure that the where clause is working)

Only the date filter fails.

Any Suggestions

Last answer 18 hours 11 min ago
0   0 3
0

comments

98

views

0

rating

We have a business service that extends Ens.BusinessService and uses  EnsLib.File.InboundAdapter.

This service polls for json files in a folder.

Method signature is like this:

Method OnProcessInput(pInput As %FileCharacterStream, pOutput As %RegisteredObject) As %Status

And inside that method it tries to read the content like this:

Last answer 2 days ago Last comment 1 days ago
0   0 3
96

views

0

rating

Hi everybody,

after importing an XML schema from xsd into Ensemble I´d like to add it to my Studio-Project but can´t find the imported schema in the namespace view. For example when working with custom hl7 schema, I could easyly add it to my project under namespace view schemaname.hl7. Is this also possible with xml schema? If so where can I find it on an component level?

kind regards,

sebastian

Last answer 4 days ago Last comment 1 days ago
+ 1   1 1
52

views

+ 1

rating

Hello,

Need some technique to solve an issue about zen page table.

- "xyz" table exists in all my namespaces.

I have a simple Zen page  in "USER 1" namespace. It has a tablepane which pulls data from "xyz" table.

OnLoad of the page i want the  zenpage to pull the data from "USER 2" namespace with same "xyz" table name.

 

Zenpage has to be in  "USER 1" namespace

 

I tried to use the server side callback handler %OnAfterCreatePage()  and do a ZNSPACE "USER 2" but still it is not doing the job of pulling data from another namespace.

 

Any suggestions will be appreciated.

Thanks,

Jimmy Christian.

Last answer 4 days ago Last comment 4 days ago
0   1 3
71

views

0

rating

Hi all. Today we are going to upload a ML model into IRIS Manager and test it.

Note: I have done the following on Ubuntu 18.04, Apache Zeppelin 0.8.0, Python 3.6.5.

Introduction

These days many available different tools for Data Mining enable you to develop predictive models and analyze the data you have with unprecedented ease. InterSystems IRIS Data Platform provide a stable foundation for your big data and fast data applications, providing interoperability with modern DataMining tools.

Last comment 4 days ago
+ 5   1 3
415

views

+ 5

rating

Hi all,

I have a class that I want to serialize to JSon. So I'm using the object %ZEN.Auxiliary.jsonProvider)

set myClass = ##class(myapp.myclass).%New()

set myClass.property1 ="value 1"

set myClass.property2 = "value 2"

set myClass.property3 = "value 3"

do ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tStream,myClass ,,,1,"ed")

write tStream.Read()

By definition of myclass, all properties are serialized, that's fine. But I want not serialize the property3. I think is using a XML attribute in the property, or something about. But I didn't find anything about.

 

Anyone can help me?

 

Last answer 4 days ago Last comment 4 days ago
0   0 2
73

views

0

rating

The last time that I created a playground for experimenting with machine learning using Apache Spark and an InterSystems data platform,  see Machine Learning with Spark and Caché, I installed and configured everything directly on my laptop: Caché, Python, Apache Spark, Java, some Hadoop libraries, to name a few. It required some effort, but eventually it worked. Paradise. But, I worried. Would I ever be able to reproduce all those steps? Maybe. Would it be possible for a random Windows or Java update to wreck the whole thing in an instant? Almost certainly.

Last comment 4 days ago
+ 8   4 5
137

views

+ 8

rating

here is my trigger:

CREATE TRIGGER "SQLUser".SYM_ON_U_FOR_SYM_CHNNL_125123 AFTER 
UPDATE
   ON "SQLUser"."sym_channel" REFERENCING OLD ROW AS OLD NEW ROW AS NEW FOR EACH ROW 
   DECLARE @var_row_data VARCHAR(16336);
WHEN
   (
      1 = 1 
      and 1 = 1
   )
   -- I will use OLD/NEW alias here set @var_row_data = ''; LANGUAGE sql insert into mytable (id, data) values(1, @var_row_data);

here is error message

Last answer 5 days ago
0   0 2
0

comments

42

views

0

rating

I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show the percentage  (100*number of rows for that member/all rows) .It should not matter what dimension is being viewed. Ex

There are a total of 100 rows in the source class.

For dimension columnA which returns value in  ColumnA column in source class, 10 rows contain "A" the rest contain "null". When viewed on the analyzer, with columnA as a row and PercentOfAll as a measure, the cells values should be:

"A"       10%

"null"  90%

 I can achieve this using an expression that would be specific to columnA dimension Ex columnA. CurrentMember/columnA.[All columnA].%All

But I do not want to have to define meausure for each and every dimension. I just want to have a measure that will be used for all dimensions. Ex

Last answer 5 days ago
+ 1   0 1
0

comments

34

views

+ 1

rating

I am building a cube based on a source class, which I  will call,  Family.Dad 

In the class definition for Family.Dad, there is a relationship, offspring  As Child  [ Cardinality = children, Inverse =  father]

In the class definition for Child, there is a relationship called father As Dad  [ Cardinality = parent, Inverse =  offspring]

In the actual data, a dad can have many children, but a child can only have 1 dad.

Using DeepSee, I am trying to analyze to answer questions such as how many dads have children called Joseph ( Ex dad.offspring.GetAt(x).Name) etc .

Last answer 14 April 2019 Last comment 5 days ago
0   0 1
63

views

0

rating

Is there a way to have a context property be available across 2 or 3 different business processes? For example if I am setting a value in a context property within one business process and want to use the same context property in a second business process, is this possible? Is this something that can be done with the "Context Superclass"?

Last answer 6 days ago Last comment 6 days ago
0   0 4
76

views

0

rating

Hey Community!

The latest webinar, recorded by InterSystems Sales Engineers @Sergey Lukyanchikov and @Eduard Lebedyuk, is already on DC YouTube Channel! Please welcome:

"Machine Learning Toolkit (Python, ObjectScript, Interoperability, Analytics) for InterSystems IRIS" 

 

Last comment 6 days ago
0   0 2
108

views

0

rating