Recently I was asked by a customer with this question. In MS SQL Server, there is a function called host_name() that will return the work station name.

Here is how I would do it in Caché :

With default SQL schema name, in my case SQLUser in SQL (which is equivalent as User in Caché class definition), I have a class called User.dummy, I added a classmethod called hostname and expose it as SQL function host_name:

/// 
Class User.Dummy Extends %Persistent [ ClassType = persistent, DdlAllowed, ProcedureBlock, SqlRowIdPrivate, SqlTableName = dummy, StorageStrategy = "" ]
{
Property f1 As %Library.Integ

Hi, Community!

We've launched Twitter for InterSystems Developer Community!

Follow us to be in touch what happens on InterSystems Developer Community. Find valuable postings, hot discussions and best practices links there. You can also retweet and like what you find significant!

See how it looks:

Join! 

I have a ZEN page with buttons, text boxes and a tab group. The tab group contains a single tab which I use to display an image(src). When the user, uses the browser zoom capabilities to reduce or enlarge the image, the other controls are reduced or enlarged as well. How can I reduce or enlarge the tab src alone? Thank you for any and all input.

NewBie's Corner Session 6 If and Kill commands

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out the commands.

As in other computer programming languages, the If command is the primary decision makes.

If command with numeric operands

Set X=12

If X=12 Set X=13

Write X

13

If command with alphanumeric operands

Set X="ABC"

If X="ABC" Set X="XYZ"

Write X

XYZ

Whenever alphanumeric data is being referenced, quotation marks are required.

Kill command

Thus far, we have learned how to set a variable to a value

Hi all - I'm running a Zen page that inherits from %Zen.Component.page, and I'd like to step through code and debug it.  Is this possible, and how?

I've tried to attach to a process that I think is mine (it has my internal IP address) but is using "Unknown User".  Any ideas on where to start debugging the page  -- this page calls lots of other pages.  I'd thought I'd start at the home page.  

Perhaps I need to navigate to my page that I want to debug, and attach at that point.

Any info on the debugger in this atypical use is appreciated.

Thank  you,

Laura

What would be the easiest or best way to filter the options presented by a filter control?

For example, suppose that I create a query using HoleFoods that uses a named filter to filter the product categories according to some criteria. When I display the query on the dashboard, I would like to provide a filter control that will allow users to further constrain the product categories. However, a simple filter control will display all the product categories available in the cube many of which are irrelevant to the current query.

Thanks for your help!

I have a homeTemplate and ExamesTemplate page. When I'm in ExamesTemplate and make a resfresh (F5 browser), the page back to the HomeTemplate. I need the page ExamesTemplate not return HomeTemplate.

I'm using ZenMojo with Bootstrap

Can someone help me?

Thanks.

Developer Community was refreshed on May 30th with the following new features and fixes:

1. Formatting of postings in My Collaborations and My Content has been improved

2. Browse by Tag now has filtering options for New, Highest Rated and Unanswered posts

3. Full paging is back on the home page

4. Browse by Tag now includes child tags. Example - posts tagged only with "MDX", which is a child tag of "DeepSee", will appear when using Browse by Tag and viewing DeepSee content

5.Browse by Member is now available.

Hi,

I am working on a DataGrid based upon ZenTest.Datagrid.cls

I want to save data after changes on a row.

The existing samples do not explain how to save changes on data in a grid.

I have tried something like zen(‘json’).save

Does anybody has some sample code?

I have a production system that has a large dataset of about 2 million rows. I need to create an index on a property but don't want it available to queries until the index is fully populated. Is there a way I can create the indexed, fire off the build, then "activate" the index so queries can use it.

The problem I face is the minute I create the index queries start returning zero rows because it starts using the index.As I start building it starts returning qualifying rows for those it has indexed but misses those not yet processed.

I am just trying to make a quick hand off HTTP production.I have the class built and compiled onto the server and the production is running as a service.When the production is called (by an inbound job) I can see that the HTTP.InboundAdapter is being used successfully and the stack continues all the up to ProcessInput where OnProcessInput is called in Ens.BusinessService.

Hi!

Here is the digest of  the most interesting and valuable posts on Developer Community published in May 2016.

Here we go!

News and Events

Caché and Ensemble 2016.3 field test now available

2016.2 Field Test Kit 2016.2.0.665.0

2016.3 Field Test Kit 2016.3.0.628.0
InterSystems Developer Community Twitter

Announcing New InterSystems Product Documentation UI (beta)

Most viewed

Writing better-performing loops in Caché ObjectScript

Installing Caché Applications Using Projections

Announcing New InterSystems Product Documentation UI (beta)

Caché and Ensemble 2016.3 field test now available

Announcing EWD 3:

Currently if I accidentally rate article as 4 I cannot change my vote.

Personally I'd prefer just +/- under the article.

There is thin line between 3 and 4 for the article or 2 and 1. Like/dislike is better in my opinion.

Ability to view content by particular member is a great feature.

I'd like to propose some enhancements to this:

• Member content should be accessible from member page. For example, under separate tab.
• There should be possibility to follow member. For example, I want to be notified every time Evgeny Shvarov posts something.
• On member content page we should be able to filter by comments/posts/all content.

UPD: I found separate topic for first item of my list: https://community.intersystems.com/post/show-users-posts-user-page

Hi,

Assume an architecture where an ECP Database Server is connected to by one or more ECP Application Servers inside a firewall.The application server hosts the web application that web users connect to.

The Web servers are outside the firewall, and, (using the CSP gateway/server mechanism) issue requests over the SuperServer port and into the application server.

I know that the traffic between the Web Server and the ECP application server can be encrypted using HTTPS, and access to the CSPServer on the Application server is username/password secured.

Q1: In order to bolster security, is it

This article is about DeepSee Listing Groups, a new DeepSee feature that was introduced in release 2015.2.

DeepSee Listings have always been a part of DeepSee.  DeepSee Listing Groups provide increased flexibility by allowing you to create new DeepSee Listings without modifying the cube definition.

Hello,

is there any API available that would return an MDX query string for a given saved pivot name? I could not find anything except for pivots with manual MDX. But that's not my case, I need to get MDX for any pivot.

TIA!

Dan

Hi ,

In HSBUS we have out of box operation HS.IHE.XDSb.Repository.Operations to route CCD's from HSBUS to Edge gateway.

Earlier it was working fine, but for maintenance we have to rest the DEV environment, Now its throwing below error. I have verified all registry configuration and the CCD feed is also same, nothing is changed except reset. Can someone help me, where to look for this problem or what I am missing here.

[ERROR #6248: SOAP response is a SOAP fault: <Fault><Code><Value>SOAP-ENV:Sender</Value></Code><Reason><Text xml:lang="en">Badly formed SOAP Message</Text></Reason><Detail>
<error

I have a tool I absolutely love for HL7 v2 analysis and manipulation. It's called 7edit.  I'm wondering if there is anything similar for HL7v3/CDA/CCD.  I know it is considerably more complex, but I still have hope.

So far the best resource I've found is http://www.cdapro.com/.  I'd love to hear anyone else's tips for tools or resources.

We are receiving XML documents and storing them. When we click to go into the clinician portal and again to view a patient, we can see the documents but none of the data is mapped to their respective buckets, i.e. allergies or medications.

I am thinking that I need to build an XSLT parser and change the format to SDA3, is this an appropriate approach? Or would using the Data Transformation (Ensemble -> Build -> Data Transformation) be a better idea? Lastly, if the XSLT idea is preferred, where would I call it within the stack?

Hi community!

Does anyone know if it´s possible to override a property name to generate a JSON message based on the instance of object?

Thanks,

José Sampaio

Learn the basics about HealthShare Information Exchange, the architecture and common ways it is used.

Hello,

I am not certain where to post this, but I am seeking to hire consultants with Intersystems Caché DBA experience.  Is there a source for qualified professionals?

Thank you!

Brian

Hello there Intersystems Developer Community,

This year while at the Global Summit, I came to learn of a component that Stephen Morrison of Intersystems had written that was capable of infusing SVG content into a PDF document.  Apparently Stephen was approached about this and was amenable to sharing the code with us as we have recently encountered a similar need.  I'm hoping this post will lead to the sharing of this utility code, so that we can determine if it will indeed suit our need.

It is my impression that this code is maybe that being used to perform the print operation on a given widget

Hello friends,

Does anyone know how to make the default checked for the 'Open as read-only' setting in Caché Studio version 5.0?

Find out about the various ways you can learn Caché. 

Steve Glassman is on vacation today so in his place I wanted to announce the availability of a new kit for the 2016.3 Field Test. The kit details are: 2016.3.0.628.0

Most of the changes are related to DeepSee, DocDB data models and dynamic objects. You can find a complete listing here:

https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/FieldTe…

Bill McCormick

Director of Product Management

Java Business Services and Operations

In Ensemble 2016.3 ‘Java Business Hosts’ provides the means to create new Business Services and Business Operations using Java without need for any ObjectScript coding. There are two major reasons to use this capability:

•  Add new protocols to Ensemble using available Java libraries.
•  Allows Java developers to create custom business services and operations without needing to learn Caché ObjectScript..

At Global Summit there were two sessions and an experience lab covering Java Business Hosts that got a lot of attention and a very positive reaction.

Maxim

If I have a cache.dat file from a Windows 2012 (64-bit) machine and I want to mount it on a Caché instance running on RHEL, will it work? Assume the versions of Caché are the same.

Hello, I'm new to Ensemble, and my first task is to become familiar with the Production and create a basic outline of it for the users to view (which servers, where are the input files, where are the output files, how many records...).  What are the Production tables?  I'd like to start there.

Thanks,

Laura