Syndicate content 0  
 
All time

Say I have a property in a persistent class that stores list of colours and I would like to query that field and return a list and be able to loop that list to get individual colours how will l go about achieving this I have tried something like this but its not working as expected

 &sql(SELECT colour INTO :colourList FROM favouritecolours)
 While (SQLCODE = 0) 
{
 for i=1:1:$LENGTH($P(colourList,","))
 {
 set fvalue=$P(colourList,",",i) 
write "the first"_fvalue,i, 
} 
}
0 1
0 573
Question
· Jun 23, 2017
Ens Alert for Warning Types

I created a Ens.Alert process and set my services Alert on Error as well an my message router. But I would also like to be alerted for warning types. Is there an setting to be alerted for this type?

0 2
0 572

Hi, folks!

When you deploy DeepSee solutions you often do not want grant a User %All Role to work with a particular Dashboard.

Consider a Dashboard 'Dash' with a few widgets where listings are being used.

If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access, grant access to a Dashboard resource (if any) and ... grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets.

1 3
0 571

Hi world, i want to configure my ensemble production that each 24 houres a business service is created and trig a business process wich browse my sql table and generate alert if there is not a new record in interval (24 HOURES).

thank's for help.

0 2
0 572

Quite a few enhancements have appeared over recent months in QEWD for easing and simplifying the creation of REST-based services. It's now even more slick and powerful, allowing you to very quickly create very high-performance, highly-scalable REST (and Web) services that make use of Cache.

I've therefore updated the training presentation deck (Part 31 on developing REST Services with QEWD). It describes all the new features with worked examples. See:

2 1
0 554

Using VSCode in a team.

Classes are edited locally and then saved to server.

Sometimes if we save a change to a class the "version on the server" does not happen or does not function properly and the class gets overwritten.

All the intersystems extensions are updated.

objectscript.overwriteServerChanges is false

This has the potential for serious issues if it happens in a persistent class, but it is difficult to reliably recreate.

0 5
0 568
Hey Community,
Please check out the 2021 Annual Dev Community Article Digest with the most popular and commented articles. Thank you all for your contributions to the InterSystems Community in 2021!
General Stats
✓ 1,687 posts published in 2021:
– 234 articles
– 436 announcements
– 980 questions
– 37 discussions
✓ 2,451 members joined the Developer Community in 2021
✓ 8,930 posts published all time
✓ 10,287 members joined all time
6 7
0 433
Hi Community! Here is a digest of the Most Noticed InterSystems Developer Community Questions for 2019. Please welcome!
Most viewed

7 5
0 473

There are situations where we want to provide immediate feed back to inbound Web Service that a particular business operation is not running (status <> "running"). We don't even want to queue up the message. We just want the webservice to respond with an error stating the business operation is down.

0 4
0 569

Good afternoon everyone,

I hope you are well,

I am currently working on the below opportunity and if anyone here would like to hear more details please feel free to contact me on 01908 886 030 or teo.rusu@identifiglobal.com

Met with the client yesterday, beautiful office in Waterloo London, latest tech available with many benefits including working from home 2 days/w as well!

Intersystems Caché Senior Software Engineer

London

4 0
1 573
Question
· Jan 12, 2022
Convert X12 to SDA/FHIR

Hi

We are embarking on a project that we are injesting raw EDI files 837's to start with into HS.

We have and inbound X12 adaptor to take in the raw *.edi file and we have an business process that is mostly pass thru. we have been unable to find any DTL to map X12 to SDA/FHIR ( similar to the ones that exist for HL7 , CDA,CCD). If anybody has done anything on this front,would appreciate any tips.

Santosh

1 1
0 571

Hi All,

Actually, I'm developing few restful API's. I want to create a authentication tokens and display it on my login restful API. If I'm using CSP sessionId, how can I validate the session Id's in another or continues restful API's. else, is there any other approach to handle this task.

My Primary goal is, I have to integrate 2 different front end applications. One is Zen framework another one is web pages from Python.

If any lead, it would be appreciated.

Thanks,

Arun Kumar Durairaj.

0 1
0 571
Question
· Jun 5, 2018
Cache Can't recognize UNC paths

Hi Guys,

have a file located in \\servername\Myfiles\pull.csv but for some reason my cache routine can't file, but can when using the local drive C:\servername\Myfiles\pull.csv.

FYI I can access \\servername\Myfiles\pull.csv via Win explorer with no problems.

anyway how I can fix this?

Thanks Guys

0 4
0 568

Hi,

I have two namespaces

  1. In the first one, I have defined a class which Extends (%Persistent, Ens.Util.MessageBodyMethods), we'll call it NSOne.Msg.Req
  2. In the second namespace NSTwo, I want to use the previous class with something like SET pInput = ##class(NSOne.Msg.Req).%New()

I mapped the NSOne.Msg.Req package in namespace NSOne. In Atelier, I can see NSOne.Msg.Req in my NSOne. But, when I try to execute line 2 above, it tells me :

0 2
0 569

Is it just me or is the sync mechanism way too slow and too trigger happy to be used for large projects? It keeps "Caching for server connection" which takes a good five minutes!

Has it been tested with a large number of classes and CPSs? I have about 2000 of each.

0 2
0 569