Hello,

I am looking to format my email into a few line breaks etc...is there a tutorial for this I have missed? Thanks!

Eventually, I would like to format like below:

Hi, community

i am defining a new role on my system , i want that this role has access only to my own data base , do you konw which roles can i add to this one ?

thank you

Hi, I'm a student, weak programming. I ask for your help, I write a program in C #, there are two tables, but I do not understand how to organize the connection between them many to many. Table in DataGridView1 from DataSet1 on Form1 key connection in DataGridView1 from DataSet1 to Form3

I do this on Form1

private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) 
{
  if (e.RowIndex >= 0)
  {
    DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
    Form1.IDfor3form = row.Cells[1].Value.

Hi community,

my database (HSAUDIT) is only on the read mode , how can i pass to the Read/Write mode?

thank's

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

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(.

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. The new streamlets are getting attached to the container along with Patient, Encounter, etc.

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 a a.ctrl, then I will have a b.txt and need a b.ctrl.

Using only one EnsLib.RecordMap.

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). This gives us some problems when consuming this email. As a temporary workaround the email server forward the email to itself to remove the signature (which isn´t embedded when emails are forwarded).

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 started with the Atelier Stand Alone.

Now I have moved on to Atelier as a plug-in to Eclipse.

With the Stand Alone I had access to two help topics, the Workbench and the InterSystems Atelier.

Now, as a plug-in I have access to a number of other help topics.

When I do a Help Contents, how do I eliminate those help topics I have no interest in?

Or only do a Help Contents on the topics that apply to me as a Atelier user?

I apologize if you have already covered this, but there is so much to read on Atelier already.

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.

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.