Caché | InterSystems Developer Community

Question

Scott Beeson · Feb 8, 2016

Can I run .mac routines from Zen or CSP?

I'm planning to have a web-based management and deployment interface. For now I have started writing some .mac scripts. Will I be able to call these from a web page? Or do I just need to start with Zen?

#Frontend #Caché

0 5

0 306

Question

Eduard Lebedyuk · Feb 17, 2016

Basic queue handling

Let's say the user need to execute some heavy code (build a report, or extensive calculations etc.). So, of course it needs to be asynchronous, and we possibly need to store some data about execution status. How?

#Object Data Model #Caché

1 6

0 705

Question

Fabio Goncalves · Jan 20, 2016

Ordered Collection/Relationship

Does Caché support a relationship property ordered according to a specifc value?

What shoud be the best approach?

#Beginner #Caché

2 6

0 511

Question

Joel Solon · Feb 18, 2016

Variable Number of Arguments to a Method

This morning on the old Caché Google Group, someone posed the following question, which I've decided to answer here, because it's interesting!

Is there a way to iterate ClassMethod's params, and get param's names and values?

The first answer I can come up with is: it's not easy! In any method, you could try to write code like this (where methodName is the name of your method):

#Languages #Object Data Model #ObjectScript #Caché

7 1

0 1,264

Question

Tiago Ribeiro · Feb 18, 2016

Message Error - CSP.Page

The cache has error messages default, for example , " -139 SQLCODE : Competition impairment on the update: row versions are not the same. "

How i can exchange it for a more friendly to the user's message? I use the CSP.Page and form_save ( ).

What is best practice for this situation?

#Caché #Frontend

2 3

0 903

Question

Dmitry Maslennikov · Feb 18, 2016

XData MimeType anything other then just xml

XData blocks in Caché classes has a MimeType property, and dcoumentation says

MimeType — The MIME type (more formally, the internet media type) of the contents of the XData block. The default is text/xml

#Languages #ObjectScript #Caché

3 1

0 313

Question

Rich Taylor · Feb 8, 2016

Looking for complex LDAP schemas

In preparation for a presentation I need a real-world LDAP schema that has been customized a bit beyond the basics. Perferably this would be based on an OpenLDAP system which would make it easier to merge into this presentation.

If you have such a schema you would be willing to share please respond or contact my directly at Rich.Taylor@InterSystems.com

Thanks in advance.

Rich Taylor

#Security #Authentication #LDAP #Caché

0 1

0 266

Question

Scott Beeson · Feb 16, 2016

Concatenate columns in results with GROUP BY?

Here is my original query:

SELECT EventType, InitiatedAt, COUNT(*) as cnt
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE EventType = 'LOGIN'
AND LocalDateTime > '2016-02-16 11:00:00'
GROUP BY EventType, InitiatedAt

This gives me data like this:

#Code Snippet #Databases #SQL #Caché

0 3

0 5,545

Question

Eduard Lebedyuk · Feb 7, 2016

Best practices to store user information/settings in Caché

I'm interested in different approaches on how to store user data in Caché. I'm assuming that application uses Caché security/Caché users and not a self-made authentication system.

Several approaches, I'm familiar with:

#Caché #Security #Authentication #Users

1 2

1 906

Question

Timothy Leavitt · Feb 11, 2016

Merging two %Objects (2016.1/2016.2)

I'm revisiting some older projects that can benefit from the new JSON support and dynamic object capabilities in 2016.1 FT / 2016.2 FT. (Particularly, some of the really new features in the latest 2016.2 FT.)
For the particular thing I'm working on, it would be very handy to be able to merge objects, similarly to https://api.jquery.com/jquery.extend/. The closest thing I've found so far (in 2016.2 only) is:
Set o1 = {"a":1,"c":2}, o2 = {"b":1,"c":1} Write "o1: ",o1.$toJSON(),!

#Caché #JSON

0 1

0 452

Question

Timothy Leavitt · Feb 9, 2016

Property with SqlComputed and SqlComputeCode, but not Calculated or SqlComputeOnChange

Looking at a property defined as follows:

#Object Data Model #ObjectScript #SQL #Caché

1 4

0 523

Question

Scott Beeson · Feb 8, 2016

Variable scope in .mac routine?

Given the following code:

#Code Snippet #Caché

0 11

0 477

Question

David Reche · Feb 8, 2016

Log csession in Linux

Hello,

I am trying to log the output of csession in Linux. I try this command:

csession cache | tee myoutput.log

Although it works each new lines at screen output doesn't appear at row 1...

Any tip?

#Beginner #Platforms #Caché

0 5

0 909

Question

Scott Beeson · Feb 8, 2016

Force or determine case?

I've searched the ObjectScript reference for any instances of Upper, Lower or Case and the only thing is a case/switch statement. In all the documentation I can only find SQL and Cache Basic references for things like UCASE.

So how do I do this in ObjectScript?

#Beginner #Languages #ObjectScript #Caché

0 2

0 249

Question

Rich Taylor · Feb 3, 2016

Creating separate thread in Cache

Has anyone come up with a way to create a separate thread of processing that can achieve shared access to a set of objects created from the initials process? The situation is this. There is a large complex set of objects representing a business process. Some of these objects are in-memory only. The desire is to spin off a separate thread that could do some ancillary processing on this data set without slowing down the main process. Any thoughts?

#Caché

0 6

0 955

Question

Alexander Koblov · Feb 8, 2016

Kerberos authentication support for Atelier

Hi!

Are there any plans to support Kerberos authentication in Atelier to Caché connection?

Thank you.

#Caché #Development Environment #Atelier

0 2

0 246

Question

Blaise ZARKA · Feb 4, 2016

How to export SQL errors to a text file?

Hi,

Do you know how to export SQL errors to a text file from a terminal session in Caché?

Thanks

#Caché #SQL

0 3

0 278

Question

Scott Beeson · Feb 2, 2016

Architecture question: Where do you put your complexity?

I'm designing a workflow for PHR via FTP. What I've done is create a single FTP adapter to pick up files from multiple customers. A router then accesses a lookup table and determines if a particular customer is allowed to send a particular message type to the state. If not, the message doesn't go out. It seems like everyone is against this approach (other than my CEO, thankfully), including Intersystems:

#Beginner #Caché #FTP #Frontend #Ensemble

0 5

0 281

Question

Jack Abdo · Feb 2, 2016

IFind french and stemming

Hi,

I created with Studio a persistent class with the following field and index:

#Beginner #Development Environment #Studio #Unstructured Data #iFind #Caché

1 2

1 206

Question

Benjamin De Boe · Jan 28, 2016

Can we map CSP pages from another namespace?

Is there a possibility to map a CSP page residing in namespace ABC to a namespace XYZ so you could access it as if executing from XYZ: http://localhost:57772/csp/xyz/MyPage.csp ? Some odd cocktail of web application and package mappings that could make this happen?

The idea is to keep the CSP page in sort of a read-only namespace that only contains code, with the data residing in another namespace. This works for zen pages, but not for CSP.

#Mapping #Frontend #CSP #Caché

0 6

0 434

Question

Scott Beeson · Jan 21, 2016

[QUESTION] Will I still be able to use these methods from business rules without the [ Final ]?

I'm working on some custom utility functions that I can utilize in Business Rules as well as other places. I saw this line in the docs:

For each function you wish to define, add a class method to your new function set class. There is no support for polymorphism, so to be precise, you must mark these class methods as final.

#Ensemble #Business Rules #Caché

0 2

0 185

Question

Steve Shaw · Jan 21, 2016

Can Zen Report <pageheader> include information from a <body> group?

Hi,

I'm trying to create a Zen Report that, when rendered to PDF has a header on every page that includes some items from the group that I'm iterating over in the <body>. I can't use <header> as that only displays once for each iteration, even if that spans more than one page, but <pageheader> seems to be independent of <body> so again doesn't work.

Cheers,

Steve.

#Beginner #Frontend #ZEN #Caché

0 4

0 256

Question

Chris Stewart · Jan 20, 2016

Nested Tabs on ZEN component

Hi

I'm starting to play around with dynamically creating tabs and panes from query data, and was trying to do the following, with nested tabs.

Tab Group

High level tabs

Sub Tab Group

Sub tabs from the High level tabs.

#Frontend #ZEN #Caché

0 2

0 299

Question

Pravin Barton · Jan 20, 2016

Use an array as a SQL parameter for a Zen tablepane?

I'd like to have an array as a parameter for a SQL 'WHERE... IN' statement. The array would be modified in javascript on the browser. Here's a simplified example:

#SQL #Frontend #ZEN #Caché

1 2

0 349

Question

Fabio Goncalves · Jan 14, 2016

Override JQuery Mobile Theme

Is it possible to override JQuery Mobile elements´styles (buttons, lists, font size, color, etc) or an existing theme with a separate custom css file?

I am really interested in an official or elegant way to do it.

Thanks.

#Frontend #ZEN #Caché

0 2

0 373

Question

Scott Beeson · Jan 13, 2016

Best way to retrieve specific record?

New to CSP and Zen. I've been going through tutorials and have made some progress. Using the "Contacts" tutorial as an example, I'm trying to create a "ViewContact" page. I want this to be linkable so I'm using URI Parameters, which I understand. However, what I'm not sure about is how to retrieve a specific record. Should I use a SQL statement? If so, how?

#SQL #Tutorial #Frontend #CSP #ZEN #Caché

0 5

0 238

Question

Scott Beeson · Jan 13, 2016

How to create content for child pages of a template?

I created a Zen page with a header. All is good. I then created a new Zen page and during the wizard specified that it was a "subclass of a template page". So now I have Class Custom.App.HomePage Extends Custom.App.TemplateMaster. If I visit HomePage.cls I see the header from the template. However, the HomePage class has no XData Contents section so I have no idea how to actually add content. I tried adding the section but once I do then I don't see the template content anymore.

#Frontend #ZEN #Caché

0 2

0 223

Question

Fabio Goncalves · Dec 17, 2015

Zen Mojo - JQuery Mobile Define Charset

I am trying to define the charset for a JQM Application and it is not working. I have tried the following options without success:

#Frontend #ZEN #Caché

0 1

0 282

Question

Steven LeBlanc · Dec 17, 2015

API equivalent to 'Recreate a database' option in ^DATABASE routine?

Hi,

Is there any API equivalent (within Config.Databases class, or elsewhere) that has the same functionality as the 'Recreate a database' option in the ^DATABASE routine?

This option was added to ^DATABASE (according to internal Devlog CFL1263):

#Databases #System Administration #Caché

1 2

0 286

Question

Derek Day · Dec 15, 2015

SELECTING distinct keys from a collection

Is there a way to select distinct keys from an field that has a collection index? I have a field defined as follows: Property data As %Library.String(COLLATION = "EXACT", MAXLEN = "", TRUNCATE = 0); Index data On data(KEYS) [ Type = bitmap ]; And I define a build value array method that parses my data outputs an array in the format array(KEYS)=VALUES. This is very useful because I can query my data using criteria such as WHERE FOR SOME %ELEMENT(data) (%KEY='param') My question is whether there is some way to select distinct key values, e.g.

#Caché

0 1

0 388

#Caché

Social networks

InterSystems resources