Hi, 

I was wondering if there is a way to get a copy of Cache for personal usage and development. 

Regards

Kumar 

Has anyone tried adding syntax highlighting to GitHub for Caché CLS files?

Looking at the list of supported languages and extensions...

https://github.com/github/linguist/blob/master/lib/linguist/languages.yml

It looks like Mumps is supported, and there is also an existing language with a .cls extension, which would account for why I see some very odd highlighting going on with some of my code.

There is a page on contributing a new language here...

https://github.com/github/linguist/blob/master/CONTRIBUTING.md

Looks like its possible to use extensions more than once for different languages.

If I can

Hi,

I'm trying to use the IN operator in SQL.

does not work, can anyone tell me why that could be?

for example:

SELECT * FROM TafnitCore_Logistics_TransferPackage_DB.PackageData  WHERE ID IN ('1||1||9852553062' , '1||1||9852553061' ) ORDER BY Building

And I get the following error:

SQL

Regards,

Nael

 What type of tree traversal was we are using in our Cache database?. Please explain anyone.

Thanks in Advance!

sample
    w "Total No.Of Sticks:21"_!
    s sticks=21
    r "enter machine name: ",a
    r "enter dev name: ",b
    w "Display 1 to 21 sticks"_!
    s i=""
    f i=1:1:21{
        w " "_i_" "
    }
user(sticks)
    w !_"User select 1 or 2 or 3 or 4 sticks:"_!
    r "User enter sticks: ",us
    if us>4 {
        w "please select upto 4 Sticks"
        r "User enter sticks: ",us
    }
    s cnt=sticks-us
    s sticks=cnt
    f i=1:1:sticks {
        w " "_i_" "
    }
    s dev=1
    s machine=0
    d:sticks=0 lost(dev,machine)
    d machine(.sticks,us)
    q

I set column onclick event, but it is not working

S col = ##class(%ZEN.Auxiliary.column).%New()
S col.header = "Header"
S col.colName = "Data3"
S col.onclick = "alert('ok');"

D table.%AddColumn(col)

alert Ok is not show

What is wrong?

I have seen three different type of data structure. 

1.^a -> it is global

2. a^ - > It is tree

3. a| -> I don't know what it is.

if any one know as please share your knowledge. 

I am trying to age based on a given date and current date here is my code:

Property DOB As %Date
Method GetAge() As %Integer
{
   if (..DOB="")
    {
  set today=0 
    }
   else
  {
  set today=$ZDate($HOROLOG,2)-$ZDate(..DOB)
  }
  write "Today's==="_$ZDate($HOROLOG),!
  write today
  return today
}

Hi, Community! 

 Check a new session recording from Global Summit 2017:

Can It Be Measured?

First-class function^wiki

In computer science, a programming language is said to have first-class functions if it treats functions as first-class citizens. This means the language supports passing functions as arguments to other functions, returning them as the values from other functions, and assigning them to variables or storing them in data structures. Some programming language theorists require support for anonymous functions (function literals) as well. In languages with first-class functions, the names of functions do not have any special status; they are treated like ordinary variables with a function type.

This post continues the article “Declarative development in Caché”.

[2, 3, 5, 7, 11, 13, 17].forEach(function(i) {
  console.log(i);
});

How to do something like this in Caché using COS?

Below are some exercises on this topic.

Hi Everyone,

I want to get current day name in cache. Does anyone know how to do that?

Hi, Community! 

Please welcome a new session recording from Global Summit 2017:

Building Effective Analytic Data Models

Does anyone in the developer community have experience implementing a customized SDA3 container within HealthShare? There is a course on the learning site (ISC1086) that discusses how to do this, but it's currently listed as "coming soon" and I'm hoping to find some documentation.

I've followed the documentation for customizing the SDA3 container, and my container class with its custom streamlets is working as expected.

I have a process that I am trying to duplicate from SQL Integration Services (SSIS) into Ensemble so that the rest of my team can help support any issues that may happen.

This particular job creates multiple dictionary files, but for each one of the dictionary files it creates, it also creates a control file that tells the vendor what to process.

So example....I have a result set that is written to a.txt but I also need to create aa.ctrl, then I will have a b.txt and need a b.ctrl.

Using only one EnsLib.RecordMap.Operation.BatchFileOperation  for the control files, is it possible to pass the Fi

Is there a way to get one of:

• Struct
• $lb
• Subscripted local variable
• List/array

As a return type from callout call?

And related question: is there a way to return several values (which may contain commas) from one callout call.  Or rather what's the best approach when doing that?

Hi All,

       Am getting  the following error while try communicate with one ensemble from another ensemble using SOAP Adapter

             ERROR #5002: Cache error: <TRANSLATE>zRead+195^%Net.HttpRequest.1

      Any suggestions on this?

Thanks,

Dinesh 

Hi, community

i've a problem with my production , it works since two months ago , today i can't start it , i don't know where is the problem !!!!

I enclose here screenshots  for my production configuration .

thank's 

Hi,

a Customer of ours comes up with a requirement to improve an existing email business service within one of his ensemble productions. The services fetches emails from a mailserver on a daily basis and extract attached files from this email and send them along with some meta information through the production.

The sender of the email uses email signatures (which is embedded as smime.p7s).

Hi, Community!

In the second part about DeepSee Web, I’ll describe what customization options you have with DSW.  

There are two types of customizations: widget customization and dashboard panel customization.

Example of dashboard customization on Developer Community analytics.

I have a HL7 schema listed within Healthshare that is marked as 'Standard' however this doesn't appear to not a standard schema and more of a custom one created (there are very specific Z segments within it) that has somehow been marked as a standard. Is there a way to change it from a Standard to Custom? I realise that this cannot be completed within Healthshare but is there a way to change this within Studio?

Thanks

We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it.

Hi guys,

is there a way to get the Call-Parameter in an UrlMap to call a method that lies in another class?

Example:

I have a generic class 'RestApi' where I define all my routes for the different Rest-Services I offer - in order to get the same URL for every service.

<Route Url="/checkUID/:uid/:supplierid/" Method="GET" Call="checkUID"/>

This way the checkUID-Method has to be in the class 'RestApi' where my routes are defined. If I dont want to have all methods implemented in the same generic class, is it possible to get the Call-Parameter to call for example the method 'checkUID' in the class 'U

Hi, Community!

Consider you move data from one server to another or make a deployment with persistent data. What do you do with index globals?

Is it always better to rebuild them or there are some cases when it worth to take them too?

Hi, Community! 

Please find a new session recording from Global Summit 2017:

Building Durable APIs: New REST Tooling

Hi Guys,
Can you please guide me to get rid of this issue. Please find the image files with this post.

Please let me know, before we are developing an API what are all the setup/Configuration(Apache/web server) need to do in my machine. 

If any lead would be appreciated. 

I don't know, in XMLNamespace parameter which URL need to use.  

.

Thanks,

Arun Kumar Durairaj.

DB Intersystems size = 635 gb, while backup size = 669 gb. Cache version is 2013.1 

I am using cache for Cobas infinity IT solutions for medical lab information system.

Any idea why is this happening? When the DB was smaller, the backup was less in size. but later I noticed this issue

thanks

Yasser

Hi All, Can you please tell me how to get the Size of the Global Subcript. In Cache 2016 - they are using ##Class(%GlobalEdit).GetGlobalSizeBySubscript() For Older version how to get the GlobalSize of the Subscript. Because the method is not exist in Older Versions and all.

Hi, folks!

Suppose you have a Caché class with %String property which contains relatively large text (from 10 to 2000 symbols).

The class:

Class Test.Duplicates Extends %Persistent 

{

Property Text As %String (MAXLEN = 2000);

}

And you have thousands of entries.

What are the best options to find entries which are duplicates on this property?

Hi, Community!

This post is a digest of the Developer Community postings in November 2017.

Most viewed

Announcement: Atelier Is Only Available as an Eclipse Plugin  376

Advent of Code 2016 Day1: No Time for a Taxicab  194

Where is the equivalent of INSPECTOR in Atelier ? See !  164

How to find duplicates for a large text field in Caché Objects?  160

Atelier 1.1 Beta Updates – October 2017  144

DeepSee Web: InterSystems Analytics Visualization with AngularJS. Part 1  133

What are all the ways an Object Property can be expressed?  127

The 'unlimited' UNIQUE index  126

Global Time Management  125

How to get the Size of the Global Subscript  124

Software-Defined Storage and Containers  104

Summary on Local Variable Scoping  100

How long does it take to encrypt a database?  96

Advent of Code 2016 Day2: Bathroom Security  90

How to convert from your standalone Atelier?  90

... but let’s first look at error handling.