Object Data Model | InterSystems Developer Community

Question

Eduard Lebedyuk · Jun 19, 2017

Hi, Community!

And so I continue with publishing of the tasks for the Final round of InterSystems Contest on InterSystems Caché and DeepSee as a part of IT Planet Student Championship in Sochi. This year we had about 2 000 participants in InterSystems Contest.

One of the tasks for the finals was to crack the black box!

#Object Data Model #Caché

2 7

0 891

Question

Nic Lorenzen · Jun 17, 2017

Working with a list of Serial Objects over ODBC

Hi all,

I have a non objectscript application connecting to a cache instance via ODBC and one column is a list of serial objects. The output from the query contains a lot of special characters and I'm hoping there's a better way to get this data back so I won't have to perform extensive parsing on the application side.

I've tried using the $ListToString() function, but that didn't help much, probably because the list contains complex objects rather than primitives.

Any help will be greatly appreciated!

#Object Data Model #ODBC #SQL #Caché

1 4

0 746

Question

Ranjith Narasimha · Jun 15, 2017

cache program to compare two files

How can i compare two files using cache program, i need this for unit testing purpose

#Code Snippet #Object Data Model #Caché

0 6

0 744

Question

Robbie Luman · Jun 13, 2017

Is it possible to execute a custom class query using MS Excel VBA?

Is it possible using MS Excel VBA to execute and retrieve data from a Cache custom class query? If so, how?

#Object Data Model #Caché

0 8

0 788

Question

Gevorg Arutiunian · Jun 13, 2017

Append a string to the beginning of a file

How do I append a string to the beginning of a %FileCharacterStream in an existing file?

#Object Data Model #Caché

1 5

0 1.1K

Question

Lucas Scarduelli · Jun 14, 2017

Callback of #class CSP request

Hi,

I only use Caché and CSP, I am making a simple request in CSP page with #call method, and I have to define a callback of this #call method, can I do this?

This is my simple request in CSP page (javascript):

PainelBordoResource.prototype.obterIndicador = function(requisicaoParametros) {
let retorno = #call(painelbordo.PainelBordoResource.obterIndicador(angular.toJson(requisicaoParametros)))#;
return retorno;
};

#CSP #Object Data Model #Caché

0 1

0 433

Article

Vitaliy Serdtsev · Jun 14, 2017 3m read

Dynamic row-level security

This is a translation of the following article. Thanks [@Evgeny Shvarov] for the help in translation.

Someone posted a question on DC asking whether it was possible to determine access rights for a particular table row always at runtime, and if it was, how could one do that?
Answer: it is possible and it’s not hard at all.

#Object Data Model #Security #SQL #Caché

3 2

0 460

Question

Rubens Silva · Jun 12, 2017

Populate not working for relationship

Here's my issue. I've been using Sample.* globals and packages mapped to another development namespace to realize unit tests. So when I ran it, I notice that I forgot to start a transaction in order to be able rollback it to it's original data.

I assumed that I should use transactions since I was manipulating it's data but I didn't want it to be persisted.

#Object Data Model #ObjectScript #Caché

0 1

0 352

Question

Scott Roth · Jun 9, 2017

Invoking EnsLib.FTP.OutboundAdpter from Object Script

I have a case where I am creating a PDF file from an Encoded String, and I need to transfer this file over to another server. I was wondering since this is PDF file if I could just invoke the FTP.OutboundAdapter within my Object script that is creating the PDF from the encoded string. Is this possible? Does anyone have an examples of using EnsLib.FTP.OutboundAdpater within their Object Script?

Thanks

Scott Roth

Integration - Interfaces

The Ohio State University Wexner Medical Center

#FTP #Object Data Model #ObjectScript #Ensemble

0 5

0 577

Question

Token Ibragimov · Jun 9, 2017

how add header to request

hello!

how I can add to my request header? if i'm using web service.

#Object Data Model #Caché

0 2

0 496

Question

Evgeny Shvarov · Jun 9, 2017

Caché Classes: How to Make a View on a Class to Manage Property Level Security?

Hi, Community!

Suppose I have class A with properties P1 and P2.

I want to introduce class B, which would have same records as Class A, but only one property - P2.

What is the easiest way to manage it assuming that I would like to use Class A to add records and be available for any operations to Users with Role A.

And I would like to introduce class B for Users with role B for read-only access. Preferably they shouldn't even be aware of Class A and P1 existence .

What is the easiest way to introduce it and manage it?

#Data Model #Object Data Model #Security #Caché

0 10

0 669

Question

Manikandasubramani S · Jun 5, 2017

ZEN - Adding New System Defined Widgets

Hi all,

Is there any way to add more systems defined widgets into the ZEN components ?

Thanks in advance.

Thanks,

#Object Data Model #ZEN #Caché

0 1

0 265

Question

Khalid Saleem · Jun 2, 2017

Issue with error-text of custom error-code

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:

#Beginner #Object Data Model #Ensemble

0 5

0 1.3K

Question

Rubens Silva · Jun 2, 2017

ResultSet / SQL.StatementResult: How to know if a column value is $list'ed

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

#Object Data Model #SQL #Caché

0 6

0 940

Question

Ankita JAin · May 31, 2017

Unit Testing Passed/Failed Status from the Terminal

Is there any methods/ways through which will get to know whether any of the Unit Test cases is/are failing in the Terminal with status as either 0 or False in case of Failure & 1 or Ture in case of Test Passes (we are getting an url of the csp page with the report which has the passed failed status) as we need to send this failure status to Jenkins for the Build to Fail (where in we have acheived this part in making the build failure/success based on harcoded boolean)

#Beginner #Continuous Integration #Object Data Model #Terminal #Caché

0 2

0 689

Question

Ranjith Narasimha · May 30, 2017

JSON to XML

Hi,

I am trying to input JSON file in ensemble production and get XML output file is there any way to achieve this or any cache program to do so?

#Beginner #Object Data Model #Ensemble

0 4

1 1.5K

Question

Token Ibragimov · Feb 6, 2017

<ENDOFFILE> zOutputToDevice %Library.FileBinaryStream.1

Hello!

I'm getting error <ENDOFFILE> zOutputToDevice %Library.FileBinaryStream.1 when sending XML request to Web Server. How I can avoid this error? Can anyone help me?

#Object Data Model #Caché

0 3

0 432

Question

Evgeny Shvarov · May 26, 2017

What Is the Best Object Callback for Insert Operations: %OnBeforSave(), %OnAddToSaveSet(), %OnAfterSave()

Hi!

I'm saving object instance using RestForms.

RESTFormsUI calls %Save() for me, which is great. But I want to set the property CreationDate with the current date for every new record being inserted.

So object callback implementation seems as a reasonable option. I did the following:

#Code Snippet #Object Data Model #ObjectScript #Caché

0 15

0 825

Question

Evgeny Shvarov · May 24, 2017

Storage Schema in VCS: to Store Or Not to Store?

Hi, colleagues!

When you export the Caché ObjectScript code to VCS (Git, SVN, Perforce, etc) do you export the Storage schema for persistent classes? If so, what are the Pro/Contra?

Thanks!

#Beginner #Change Management #Git #Object Data Model #ObjectScript #Caché

0 20

0 1.9K

Question

Nicholas Chimera · May 24, 2017

How to set process "Client Aplication Info" ?

Hi -

In Management Portal I can view Processes and their details.

I have a long running job and would like to set the "Client Application Details" -> "Info" indicator in my code so that I can monitor the process.

Does anyone know how I can set that string in my COS code?

TIA

#Object Data Model #ObjectScript #Caché

0 1

0 248

Question

Rubens Silva · May 12, 2017

Interprocess comunication (main< = >job)

Hello.

I would like to know if there's a way to batch a certain amount of writes done inside a job and display it sequentially on the main process.

My idea is to prevent the main process from freezing while displaying the batched data. The main process's device could be

the terminal or the Studio output.

#Object Data Model #Studio #Caché

1 11

0 607

Question

Stefan Cronje · May 19, 2017

XML Import validation to not return on the first error

Hi,

I have an XML file with many repeating elements to validate.

The structure of the file looks like this:

#Beginner #Object Data Model #XML #Caché

0 3

0 269

Question

Kishan Ravindran · May 10, 2017

Examples of using FHIR With InterSystems Caché

Is there any simple code in Cache using FHIR to understand the relationship between them? If so can anyone provide some example.

#Beginner #FHIR #Object Data Model #Caché

0 1

0 772

Question

D Sun · May 12, 2017

Need to find a way to get the columns in a query from Query object.

Recently I have encounter an issue to get the columns out from a query without execute it.

For example:

I have a Query looks like below. How can I get the 'col1,col2,col3,col4' or the text of the query("select col1,col2,col3,col4 from mytable") back?

#Object Data Model #Caché

0 2

0 333

Question

Stella Ticker · May 12, 2017

Using multiple processes to process a single file

It is taking several hours to read a large text file because the while loop uses ReadLine() ! Is there some way in Cache to process a single file using multiple processes. Something comparable to this:-

http://stackoverflow.com/questions/11196367/processing-single-file-from-...

#Object Data Model #Ensemble

0 7

0 732

Question

Laura Cavanaugh · May 12, 2017

Need to good way to convert objects to array in 2014

I was looking at the OrefToArray^%occRun in the %CSP.ErrorLog page in version 2016. However, we're on version 2014, and that method does not seem to exist yet. I would love a good way to swizzle out the info in the %request, %session, %response objects for the error log for my own error page, in version 2014. I don't want to have to go through and get all the properties manually, but I will if I must. Any other good way already written?

Thanks,

Laura

#Object Data Model #Caché

0 9

1 541

Question

Alex Kogan · May 12, 2017

Calling list.FindOref(<object from indexOpen call>)

Hello All,

I have a question / issue regarding the calling list.FindOref(<object from indexOpen call>)
Here is a simple way to reproduce the issue:
2 classes: Utility.contacttypes and Utility.person
*************************

Class Utility.contacttypes Extends %Persistent
{
Property description As %Library.String(TRUNCATE = 1);
/// Index for property description
Index descriptionIndex On description [ Unique ];
}

*************************

#Object Data Model #Caché

3 5

0 346

Question

Ruslan K · May 10, 2017

Mapping globals to classes

Is there any good book where is described process of mapping globals to classes? And book about Storage?

I didn't find much information about these questions in documentation :-(

#Globals #Mapping #Object Data Model #Caché

0 3

0 641