Question Derek Day · Dec 15, 2015

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. SELECT DISTINCT KEYS____ FROM ____ .

1
0 599
Question Fabio Goncalves · Dec 14, 2015

Hi All,

I am trying to disable a button on a JQM application.

I started the button as disabled according to this code: {type:'$button',caption: Button',key:'button',disabled:true}

However, I would like to enable or disable the button via JavaScript code . I have tried the following, but it don´t have the same behavior and style as the code above.  

var view = zen('mainView');
              view.

2
0 410
Question Amir Samary · Dec 14, 2015

Hi!
I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns:

Set tSC = oMDX.%PrepareMDX(tMDX)
Quit:$System.Status.IsError(tSC)

Set tSC = oMDX.%Execute()
Quit:$System.Status.IsError(tSC)

What could be causing %Execute() to take so long to run while Analyzer is responding fast?

I can see that the process that is executing the %Execute() method is on HANGW state. I am assuming that it is waiting for another process.

2
0 419
Question Jenna Makin · Dec 2, 2015

A client stated to me that they are trying to eliminate SMTP servers from their network and want all email to be sent through their Microsoft Exchange Server.  Admittedly I am not very knowledgable of the workings of Exchange Server.

Are there customers sending email notifications through Exchange Server?  How is this accomplished?  Does Exchange Server act as a SMTP server allowing use of the Email adapter or is there some other mechanism that must be used to communicate with a Microsoft Exchange Server?

2
0 696
Question Derek Day · Dec 8, 2015

There seems to be little point to journal audit db updates; why rollback an audit entry for an attempted update?

I’m working on some auditing code and I have a few questions (feel free to respond regarding 2016.1 or later).

  1. I’ve noticed that there is little point of journaling updates to an audit database, as the Audit log is essentially an additional journal. Is there any reason not to disable journaling for audit log updates?
  2. I’d like to audit even transactions that get rolled back, preferably with information that the rollback occurred (this could be a second audit entry).
5
0 549
Announcement Joe Gallant · Dec 10, 2015

Welcome to the DeepSee Group.

The Developer Communty has a lot of DeepSee content including all the DeepSee documentation and over 50 videos.

Please use the Developer Community to asks questions, share your experience, and learn more about DeepSee.

I look forward to your participaton in the DeepSee Group of the InterSystems Developer Community.

Joe Gallant

Senior Product Manager

0
0 286
Question David Reche · Dec 2, 2015

There is any mean to use different fonts? For example "Courier New" for code text, or different colors? To work only with HTML is too hard

1
0 210
Article John Paladino · Dec 7, 2015 1m read

I'm very proud of the Worldwide Response Center - an excellent group of men and women - and I am interested to hear from you about your experience using the WRC.  There are always better ways for us to serve you.   

I'm also very excited about the Developer Community which we're bringing to you to give you an opportunity to connect with groups and individuals in the InterSystems community.  Let us know what you think and how we can improve it in order to serve you better.

0
0 269
Question Jenna Makin · Dec 1, 2015

Hello-

I am working on an Ensemble demonstration that involves workflow.  Over the course of testing I have cleared out the Ensemble message store several times.  This has left several workflow tasks that no longer can be assigned, accepted or rejected.

How do I clear the Workflow Tasklist which is found by going to Ensemble -> Manage -> Workflow -> Workflow Tasks in the Ensemble Management Portal?

Thanks in advance

Ken

1
0 324
Question Ben Spead · Nov 20, 2015

I am using &html<> to output some CSS to my page (which is a class-based and not a tag-based page), and the selectors contain the '>' character which the compiler chokes on.  How can I escape the '>' so it still displays as such in the web page source but doesn't trip up the compiler?

This is for 2012.2 btw.

8
0 565
Question Chip Gore · Nov 11, 2015

Hi -

If you have Cache installed on a Cent OS machine, and you want to switch the OS to Red Hat 7, and your Caché is installed on a non-OS drive, do you need to reinstall Caché?

I don't think so, but I wanted to check

2
0 406
Question Chip Gore · Nov 10, 2015

Hello DeepSee'ers -

How hard is it to brand a dashboard to a login?

The situation is, I have a Partner that is looking to create common Dashboards in a SaaS model where the Partner's Clients would want to have their individual views of this common dashbaord be branded (logos, color, styles, etc.) to match the Client's branding. This my Partner's Client's End Users will see this common dashboard as the dashboard from the "Client" and not the "Partner" (and certainly not ISC branding)

ie.  ISC -> Partner -> Client -> End User

2
1 373
Article Brendan Bannon · Nov 9, 2015 1m read

The attached zip file contains a bunch of examples of Cache SQL Storage mappings that I have done over the years.

If you have existing globals and want to expose them via Objects or SQL you need to setup Cache SQL Storage mapping.  If you do not see an example that helps with your case send me an example and I can help you out.

0
0 1198
Article Daniel Kutac · Nov 9, 2015 3m read

Tip dvacátý šestý: objekty a concurrency 2 - swizzling

Když tento seriál před několika lety začínal, byl jeho první díl věnován zajištění izolace instance objektů pro exkluzivní přístup a popisu příslušných API funkcí. Nedávno se mi ale stalo, že mě tento díl dostihl. Jeden ze zákazníků začal mít problémy v aplikaci, přestože důsledně používal exkluzivní zámky pro editování instancí svých objektů.

0
0 361
Article Developer Community Admin · Oct 21, 2015 1m read

Abstract

The European Space Agency (ESA) has chosen InterSystems Caché as the database technology for the AGIS astrometric solution that will be used to analyze the celestial data captured by the Gaia satellite.

The Gaia mission is to create an accurate phase-map of about a billion celestial objects. During the mission, the AGIS solution will iteratively refine the accuracy of Gaia's spatial observations, ultimately achieving accuracies that are on the order of 20 microarcseconds.

0
0 449
Article Developer Community Admin · Oct 21, 2015 1m read

Abstract

A benchmark of a real-world application, which loads data into a data warehouse for subsequent analysis, was performed. To conduct the benchmark, one module of the Oracle-based application was replicated in Caché ObjectScript. Only about 40 person-hours of work was required to duplicate the functionality of the original module in Caché.

The time required to complete certain tasks was measured running the Caché-based module, and was compared to existing data.

0
0 333
Article Developer Community Admin · Oct 21, 2015 2m read

Introduction

The lack of visibility across data silos — data sources that are not integrated with enterprise systems — is a threat to business efficiency and profits in many industries. In financial services, front-office silos may develop where operations are segregated by product and region without coordination on data model design. Mergers and acquisitions may result in additional disparate silos, or regulations may require that data in one arm of the firm be inaccessible to another.

0
0 204
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

Experts estimate that 85% of all data exists in unstructured formats – held in e-mails, documents (contracts, memos, clinical notes, legal briefs), social media feeds, etc. Where structured data typically accounts for quantitative facts, the more interesting and potentially more valuable expert opinions and conclusions are often hidden in these unstructured formats. And with massive volumes of text being generated at unprecedented speed, there’s very little chance this information can be made useful without some process of synthesis or automation.

0
0 327
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

Tying quality of care to reimbursements has been proposed in the last few years as a solution to increase the efficiency and quality of care and replace the costly and ineffective fee-for-service model. Provisions within the Affordable Care Act of 2010 have given accountable care organizations (ACOs) the foundation upon which to build real-world, value based care models.

0
0 115
Article Developer Community Admin · Oct 21, 2015 3m read

Providing a reliable infrastructure for rapid, unattended, automated failover

Technology Overview

Traditional availability and replication solutions often require substantial capital investments in infrastructure, deployment, configuration, software licensing, and planning. Caché Database Mirroring (Mirroring) is designed to provide an economical solution for rapid, reliable, robust, automatic failover between two Caché systems, making mirroring the ideal automatic failover high-availability solution for the enterprise.

0
0 337
Article Developer Community Admin · Oct 21, 2015 1m read

InterSystems has implemented a broad set of MultiValue extensions for its Caché multidimensional database. These extensions enable the migration of MultiValue applications to Caché and bring the full range of Caché object and SQL development technologies to MultiValue developers. The result: your existing MultiValue investments are preserved, you gain a broad spectrum of highly scalable deployment options, and your developers can combine the best of MultiValue, object, relational, and technologies to extend existing applications and build new ones.

0
0 345
Article Developer Community Admin · Oct 21, 2015 1m read

Introduction

Impedance mismatch is a term commonly used to describe the problem of an object-oriented (OO) application housing its data in legacy relational databases (RDBMS). C++ programmers have dealt with it for years, and it is now a familiar problem to Java and other OO programmers.

Impedance mismatch arises from the inherent lack of affinity between the object and relational models.

0
0 371
Article Developer Community Admin · Oct 21, 2015 2m read

Information Sharing Enables Health Plans to Leverage Data and Analytical Assets to Deliver Sustained Value

Executive Summary

The shared-risk payment models that are central to health reform all require tight coordination among payers, providers, and patients if they are to succeed. As payers and providers enter into more and more such agreements, they need to enhance success by communicating and collaborating more effectively with their partners and actively engaging, supporting, and empowering their members.

0
0 228
Article Developer Community Admin · Oct 21, 2015 2m read

Introduction

By now, anybody working in the technology sector will have heard of Cloud computing. But the concept is increasingly being paid attention to outside of IT departments, with growing recognition among boardlevel executives of the potential of this range of innovations. Frequently, senior personnel are hearing stories about how the Cloud helps organizations reduce costs, boost efficiency and expand their operations, so they’ll be excited about what the Cloud can do for them.

As a result, Cloud is one of the fastest-growing parts of the IT industry.

0
0 238
Article Developer Community Admin · Oct 21, 2015 2m read

Introduction

Australia's recent launch of the Personally Controlled Electronic Health Record (PCEHR) - a significant step towards establishing a national e-Health infrastructure - has simultaneously provided a boost to shared Electronic Patient Record (EPR) projects and delivered a wake-up call to healthcare providers about their readiness for connected care initiatives. In countries around the world, the era of connected care is here.

The PCEHR has increased both the push and pull factors that will lead to widespread shared EPR adoption.

0
0 200
Article Developer Community Admin · Oct 21, 2015 2m read

Executive Summary

InterSystems HealthShareÆ and InterSystems EnsembleÆ both provide a rapid integration and development platform with built-in capabilities for the high-speed processing of HL7 messages. For the purposes of HL7 v2 message routing the two products are equivalent in performance. For brevity, this document will just say Ensemble in many places but it should be taken to apply equally to both products.

We have recently completed a performance and scalability benchmark of Ensemble version 2015.1, focusing on HL7 version 2 messaging.

0
0 565
Article Developer Community Admin · Oct 21, 2015 2m read

Providing a reliable infrastructure for rapid, unattended, automated failover

Technology Overview

Traditional availability and replication solutions often require substantial capital investments in infrastructure, deployment, configuration, software licensing, and planning. Caché Database Mirroring (Mirroring) is designed to provide an economical solution for rapid, reliable, robust, automatic failover between two Caché systems, making mirroring the ideal automatic failover high-availability solution for the enterprise.

0
0 609