I have a tablePane that always displays with the bottom row selected. The SQL is executed when the submit/search button is clicked.  See attached.

Does anyone know how to enable row selection but prevent the bottom row being selected after the button onClick event?

<tablePane
  id="workBioTable"
  maxRows="1000" 
  pageSize="6"
  width="1000px" 
  showRowNumbers="false"
  showZebra="true"
  useSnapshot="true"
  extraColumnWidth="5%"
  initialExecute="false"
  sql="SELECT workbio.RequestDate, workbio.SpecId, workbio.Worksheet, %SQLUPPER(wsfbio.

In iknow they are mentioning that Japanese words cannot be used for iknow in CRC and in CC, If one needs to use iknow for Japanese character how does concepts and relation works for them?

Do you need to give additional users access to the Management Portal to help maintain and monitor your system? You may be wondering what’s the best way to:

• Ensure all users have access to the information they need, when they need it.
• Prevent certain users from seeing sensitive information.
• Prevent users from editing something they shouldn’t.

Watch the webinar titled Securing the Management Portal delivered by Shane Rose, a technical trainer with InterSystems.

 I ike to create schema independent DTL to add FTS segment  to the end of a message. The problem that I see if do I need to loop each segment  to find the last segment ? Or is there a better way to do this?

ClassMethod Transform(source As %RegisteredObject, target As %RegisteredObject) As %Status
{

     set target=source.%ConstructClone(1)
     set FTSseg= "FTS||End Of File|"

ERROR
    quit sc
}
 

Is it possible to use an intersect lookup table on a repeating field in a routing rule from management portal.

Using the Data Transformation Builder I see the action if but in my scenario a case statement  would be better. Is there anyway to do a case statement? This way I dont need to build a long if else logic.

Hi All,

I am trying to pass a http request through ensemble production and fetch response. 

Could you please advice us the steps to achieve this. 

Thanks in advance,

Arpitha R

Hello everyone,

I'm doing a REST service for integration between 2 systems. The system that invokes me expects a response object where only one of its attributes changes.

Hi,

We are trying  to feed in HTTP request & get HTTP Response in ensemble production.

From the below link  we got the code for HTTP Request/Response Example. while executing the code we are getting following error: "ERROR <Ens>ErrFailureTimeout: FailureTimeout of 30 seconds exceeded in Test.HTTP.Operation; status from last attempt was ERROR #5922: Timed out waiting for response​"

URL : https://sites.google.com/site/intersystemsensemble/code-collection/exam…

Could you please help us in this regard.

In our last lesson, we implemented a linkage to our WidgetAccessory class, and debugged some errors we encountered along the way.  We now have our data being returned by REST, but what if we want to update or add new data to our application?  

So far we have only used HTTP GET commands with our REST Services, we now have to implement PUT (which roughly corresponds to an Update) and a POST (which roughly corresponds to a Create.  Author's note: there is a lot of writing online about why this statement isn't entirely correct, I'm not going to go into the detail here).

or "Things are going to break"

We left our application over the weekend, secure in the knowledge that it was returning data from our primary persistent class, User.Widget.  However, Widgets Direct are the premier supplier of both Widgets AND Widget Accessories, so we should really start working on adding these Accessories to our application. 

We should do some housekeeping first though.  Our Page Controlller code is currently sitting in the widgetmaster.js file.

Hi,

In SOAP Wizard, whatever WSDL I pass, I m getting the following error in the SOAP Response. Even If I create my own SOAP Web-Service and pass its WSDL, I am getting the same.

Hi,

Is JMETER compatable with Ensemble production.

Hi - I created a custom extension to the SDA3 Allergy class, but can't figure out how to access the actual data to plug it into the SDA in the OnAllergy method.

The method (in my extension of the HL7ToSDA class) has a method like this:

ClassMethod OnAllergy()
{

  Set cr = $c(13,10)

  do ..write(cr_"<Mode>") 
  do ..write(cr_"<Code>"_"ThisWillComeFromACustomFieldInAL1"_"</Code>")
  do ..write(cr_"</Mode>")

Hi,

I am trying to generate a custom error-code using the following code

Class ISG.CommonBilling.Service.Test1 Extends EnsLib.HL7.Operation.TCPOperation
{
	ClassMethod khalid() As %Status
	{
		Set tSC=$$$ERROR("10001","I am here")
		write $$$GETERRORCODE(tSC)_$char(13,10)
		write $SYSTEM.Status.GetErrorText(tSC)
	}
}

And here is the output:

KINDRED>do ##class(ISG.CommonBilling.Service.Test1).khalid()
10001
ERROR #10001: Unknown status code: 10001 (I am here)

QUERY: Is there any way I can remove the part "Unknown status code: 10001 (...)" in the error-text?

Thanks in advance, Khalid

I'm breaking my head trying to figure how to solve this issue. 

When using SQL, If the column (property) is populated with at least one value and is a %List, then I can check if it's $listvalid and $listlength(column) > 0.
Now let's suppose there's no data inserted for that column on next row.
I can't simply use $listvalid because $listvalid("") = 1. Yeah, empty values is a $list for Caché.
So my question is, how do I discover if the regarding column is indeed a %List independently of being empty or not when retrieving it's value via SQL?

I need to guarantee that a parent AND child rows has been inserted successfully before any other process is able to read ANY of the data.

What is the proper way to prevent DIRTY reads?  Per the InterSystems's documentation I should be able to use ' START TRANSACTION ISOLATION LEVEL READ COMMITTED'.  I have attempted to use these commands in embedded and dynamic SQL calls to no avail.

I have to be able to insert the data via JDBC calls, but legacy Caché (.MAC) may be reading the data, and if the data is read to quickly, I could have processing errors, as all the child rows have not been inserted.

Hi!

During a Caché system management training course today we discussed structural database integrity (a.k.a. physical integrity) and the tools InterSystems provides for checking integrity and fixing problems.

Hi, Community!

Please find the Developer Community video of the week: Human Decision as a Part of Workflow.

This video is a session from Global Summit 2016 which describes:

• The needs of human decision in workflow
• Human workflow and InterSystems Ensemble
• Ensemble Workflow API

Enjoy and stay tuned with Developer Community YouTube Channel.

I'm aware of two ways to get list of files in a dir:

set dir = "C:\temp\"
set rs = ##class(%File).FileSetFunc(dir, , , 1)
do rs.%Display()

and:

set dir = "C:\temp\"
set file=$ZSEARCH(dir_"*")
while file'="" {
   write !,file
   set file=$ZSEARCH("")
}

Yet they bot return only files and directories in a current directory, but not files in subdirectories.

I suppose I call one of these recursively, but maybe there's a better solution?

Is Healthshare a product?.Health share Database how to differ from another Product Database?.Are using any intermediate services for Healthshare DB?.

Is the InterSystems Cache has SQL or Non-SQL concept?

Hello,

is it possible to ZW variables in stack frames above the current one? I am calling a custom logging method, and would like to log variables from the point of call.

Thanks

Jiri

Hi,

Cache Studio's inspector window can show me a Cache class's properties,methods parameters, XDATA blocks, Triggers, Foreign Keys, Queries and more, in a table in the Inspector window. Additionally, for properties, where the property accepts parameters, these parameters are listed together with possible value choices.

       What is the difference between mac and class files and these files are how to converted int file format

Hi, Community!

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

Most viewed

Hacking into Caché  302

Cogs Library  191

Building a QEWD / Node.js / Cache REST Back-end  190

The COS Faker  173

Security Alerts  168

SQL/Non-SQL  165

How do I get a list of files in directory including subdirectories?  155

Managing UTF-8 characters on the database with a REST application 151

Interprocess communication (main< = >job) 129

Globals vs Locals: What Is Faster? 125

 Most voted

Caché Open Authorization Framework (OAuth 2.

Hello,

There is a programatic way to Export/Import the Ensemble System Default Settings?

I know you can use the Production Export Screen and add the "Deployable settings" but I am looking for something more quick and flexible

Thanks

Hi,

I am facing an issue after upgrading from Ensemble version 2015.1 to 2017.1. On 2015.1, I was testing a Rest operation using a https mock-server. But now on 2017.1, the same Rest operation throws me the following exception on testing...

Hi -

In HealthShare clinician user specifications (as well as in the the clinical viewer), there are locations for specifying "proxy" user(s), but there doesn't seem to be anything in any of the documentation that explains what this actually means/enables.