#Caché

Hi guys,

need some help here. How do i use sql to query tables from different database which reside in same server?

Hi,

I am testing some BI tools like Tableau, Power BI and Qlik with Caché using ODBC driver

Is there another way to connect them with Caché?

Hello fellow community members,

I would like to offer my services as an Intersystems Professional and am available to work on projects. 

I have more than a decade experience into  Intersystems stack of technologies including IRIS, Ensemble, Healthshare, Healthconnect, Cache Objectscript, Mumps, Zen, Analytics etc. with companies spread over US and UK  involved in multiple domains.

Can the built-in $System.Encryption.TOTP() function be used in conjunction with Authenticator Apps (e.g. Google, Microsoft, and so on)?

Providing the same secret/key to a variety of authentication apps, they all return the same synchronized value. However, passing the same secret/key to $System.Encryption.TOTP() is generating a different value (with all instances executing at the same time for comparison).

How to implement table splitting in cache

How do you initialise a list of objects of a particular type?

I have tried the following code and I get an undefined when I try to insert.

I can do this and it works but I don't know if it is correct.

Is there any way to do something like this?

Set a= New list of Accciones()

Thank you.

How to access files in shared folder with Healthconnet or Cache？Thx！（Read or write，not local file）大家好，我想请教一个问题，如何在Health Connect实现访问共享文件夹的文件 （对文件进行读取或者写入操作，非本地文件）

I have a ZEN PDF report that prints headers and footers with images correctly but when I try to embed an image into a table it does not print.

Are there examples snippets where a fully url qualified image can be embedded within the <table><item><img> tags?  

HI Community,

Now Intersystems has developers definitely cut-off from Zen/CSP I am looking for sample code how to invoke server-side methods from Angular and PHP, Java client.

I only see some rest/json crud examples, but that is not the whole picture I assume.

Let's say I have a persistent Class with a class method to import or modify data...

I want to invoke this from my Angular App or PHP app.

any examples, suggestions?

Hi Guys,

I'm using the below style and everything looks  good, with my Dynamic Grid width 1300px, but when I refresh my grid the width goes out of whack and the grid is too wide, so how can I re-call my enforce my style to be applied again after refreshing my grid, so basically I'm looking for a line of code that I add it to my refreshing () clientMethod ?   

XData Style
{
<style type="text/css">
body {
    padding: 5px;
    margin: 0px;
    height: 100%;
    background-image : url(images/bkground.gif);
}

Have any idea for add default page to web application in csp menu

&?

So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.   

There's only one problem:  You've never used Angular, and don't know how to make it talk to Caché.

This guide is going to walk through the process of setting up a full Angular stack which communicates with a Caché backend using JSON over REST.  

Is there a method I can utilise to check if a particular method has been called and perhaps log the args it was called with?

We are currently trying to expand out Cache Unit Testing processes and were wondering if there is an existing method that would capture this or how  such a method could be structured.

Thanks
Adam

Hi all,

Over the next few months I'm going to be setting up continuous integration via Jenkins for some Angular UI's.  The goal is to, on each build:

1. build the code

2. run the unit tests and get a report

3. get a code coverage report

Just wanted to poll the community in case someone else has already worked with any of this before.  All ideas are appreciated.

Cheers,

Johnny

What is the correct syntax when passing values on a zen method after ifexpression?

 <pagebreak ifexpression="%report.PageBefore('Graph',1)=1"></pagebreak>  ????

.....

Method PageBefore(Table As %String = "", p As %Integer = 0) As %String [ ZenMethod ]
{
if Table="" quit 0
if p {set x=+$g(^||Page("PageFlag","Table",p))}
else {set x=+$g(^||Page("PageFlag","Table"))}
if (x=1)||(x=3) quit 1
quit 0
}

This gives me an error "<SYNTAX>zIfCommon+2^%ZEN.Report.Display.controller.1"

I have swapped the double quotes to single but it still errors

I have a client that no longer wants to use sftp to transmit their data file to me.  Instead they want me to pick it up via a web service.

Email from client:

Here is the postman collection and mocking service to start your development. The API has only one URI parameter {id} for which you need to pass UniqueIdentifier(will let you know exact value later).

https://anypoint.mulesoft.com/mocking/api/v1/links/03a74865-d7fb-4318-a310-7ad2b95361f6/v1/receivables/{id}

attachments: ssrg-exp-api.postman_collection.json, IB006_Response.json

Hi,

How can I define  composite primary key in Cache?

Thanks

I create a object.

SET nlsoref=##class(%SYS.NLS.Locale).%New()

So I want to verify if the attribute 'test' exists in the object, I tryied use $data

write $data(nlsoref.test)

But show this message:

<PROPERTY DOES NOT EXIST> *test,%SYS.NLS.Locale

Someone can help?

Best regards, Flávio.

Hi,

Every time I have to enter password in Visual Studio Code. Is there any why to save the password in VSCode?

Thanks

Hi, I need to assert that a string is a certain value.

d $$$AssertEquals("String value", "Value expected", "Should return correct value")

When running this I get an INVALID OREF error.

Is there any Assertion method I can use where the first parameter can be string like above, rather than an instance of a class as I can see on the documentation?

Thanks,

Andy.

I want to add time slot and category metadata to complete my cinema application.

I am following the documentation of the cinema application "https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=TWEB2…" and in that,

I was trying to add theater and time slot. But I was not able to do that.

I was also trying to filter the records as per the ratings and category selection on the search bar. but this is showing some error.

I also want to know that how to add bootstrap in cps page?

Thank you

Hi Community,
This post is to introduce one of my first project in COS, I created when started to learn the language and until today I'm keeping improve it.

The CosFaker(here on Github) is a pure COS library for generating fake data.

cosFaker vs Populate Utils

So why use cosFaker if caché has the populate data utility?

Ok the populate utility has great things, like the SSN Generator for example, but what to do when you have a field with a long description of a product? How to check if that table will list the emails or if that calculated property will count the days of the last user interaction.

As you know the $ZUTIL method is deprecated and I'd like to replace this calls for the corresponding ones.

In my case I'm looking to replase $ZUTIL(12)  by ##class(%Library.File).NormalizeDirectory("")

But the response is not the same while $ZUTIL points to mgr folder NormalizeDirectory points to my Logic Databse Folder.

Is there a way to proper do this replacement?

Thanks a lot

Hello, first of all thanks for your time reading this question,

We would need some help, we would need to delete a %GlobalBinaryStream which is a variable called "pOutput" which is being sent from a REST Service to POSTMAN

Currently we have tried:

Hi,

How can I insert data through trigger in InterSystems Cache DB table?

Thanks

Hi Guys,

how can I call a client method inside %OnAfterCreate method?

thanks

Currently have an SFTP server setup to deliver a CSV file to a company "Company XYZ"

Failed to move '\\dir-01\files\Company XYZ\Outbound\To Be Processed\Company XYZ data v1.csv' to Archive file '\\dir-01\files\Company XYZ\Outbound\Archive\Company_XYZ_v1.csv'

The Business Service File Spec : Company XYZ v1.csv

archive path same as listed above

Is it the File Spec that needs to be changed for this to prevent erroring out? 

Why do I upload files faster with webservice than with csp?

The soap protocol used by webservice has to go through http protocol. csp directly handles http, no xml encapsulation, so it should be faster.

After testing, for a 1M file, csp is about 0.1s slower. After the gateway connection to 1972, there is a stall of about 0.1s, not sure why.

Is there any way to make the file upload speed of csp faster than webservice?

webservice用的soap协议也得走http呀。csp直接处理http，少了xml的封装，按理来说应该更快。

经测试，1M的文件，csp慢了0.1s左右。在网关连接到1972后，有0.1s左右的停滞，不知道原因。

有什么办法能够使csp的文件上传速度比webservice快吗？

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

##class(%ZEN.Auxiliary.jsonProvider).%ObjectToJSON(objTest,,,"aeoqtw")

It doesn't show the items from %DynamicObject just show this:

Currently we're using InterSystems Cache Studio Client 2017.2.2 Build 865

I'm currently going through training and one of the videos mentioned using Control+Space to bring up the content assist window.

It's in reference to Atelier IDE, but I'm curious if Studio also might have a tool similar to that?