Caché | InterSystems Developer Community

Question

sansa stark · Oct 9, 2018

Hi all,By using LDAP cache method ##Class(%SYS.LDAP).GetValuesLen(LD,CurrentEntry,Attribute) we get the list of attributes but in "ObjectSid" attribute have the SID in binary format(objectSid^U¤:c@ãºþÕLCP]). how to convert to the readable format from the binary format in cache side.
Please help us to proceed further

#LDAP #Object Data Model #Caché

0 3

0 324

Article

David Loveluck · Feb 1, 2018 1m read

How to efficiently query collection properties

Here is a snippet that I learned yesterday

You can define an index on a collection property but when I tried to use it, I failed. I was using

     Select ….. where …. :xx %INLIST collproperty

But this will not use an index, but the equivalent syntax

     SELECT .. WHERE ... FOR SOME %ELEMENT(collproperty) (%VALUE=:xx)

will use the index

Check out

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

#Performance #Tips & Tricks #Caché

1 2

1 324

Question

CJ H · Feb 19, 2018

%NOMERGE for query optimization

I don't quite understand the %NOMERGE mentioned in the documentation.

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_from#RSQL_from_nomerge

Is there any specific example provided to illustrate the idea?

Thanks.

#SQL #Caché

0 3

0 324

Question

Smythe Smythee · Aug 17, 2022

$$$LOGERROR

Hi,

When i am using $$$LOGERROR("Message is Discarded") in the class i am getting "Referenced Macro Not defined" error

Can you help me how to use $$$LOGERROR in a class

Thanks,

Smythee

#Error Handling #Caché #Ensemble

1 1

0 324

Question

Paul Riker · Nov 20, 2017

SQL to analyze processes by config

Does anyone know how to return the sys.process table with the corresponding configname item for each process? Also, is there a key for the Job Type field?

#SQL #System Administration #Caché

0 4

0 324

Question

Kishan Ravindran · Jun 6, 2017

iKnow with Japanese

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?

#Beginner #Caché #InterSystems IRIS BI (DeepSee) #iKnow

0 1

0 324

Question

Mohan Kumar · Sep 16, 2016

About Cache 2015.1.0.429 Software

Why $ZF(-1) not workers in Windows 10 ? Is there Any reason for that ?

#Caché #Callout

0 2

0 324

Question

Edward Malin · Jan 3, 2018

Freeze Query Plans on Upgrade from 2015.2 to 2017.1.2 or 2017.2.1

Will an upgrade from 2015.2 to 2017.1.2 or higher freeze the query plans from 2015.2? Is there some minimum source version where this will work?

#SQL #Caché

0 3

0 323

Question

Bharath Nunepalli · Apr 3, 2020

Calling Security.Users class in a script

Hi,

Has anyone tried to call Security.Users class (in %SYS namespace) for creating or editing users from a shell script (or any programming language)?

If yes, can you please share your code?

We are trying to automate some stuff and would like to know how this worked for others.

Thanks,

Bharath Nunepalli.

#Security #Caché

1 7

0 323

Question

david clifte · Nov 18, 2016

How to set a beutiful name for settings field in BusinessOperation

I saw in: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... How to add a Setting to a Host, BO , BS or BP. But, how to set a beautiful name for a setting? Ex for properties: Property foo As %String; Property bar As %String; Parameter SETTINGS = "foo,bar"; I'd like something like: "A foo property" "A bar Property"

#Caché #Ensemble

0 2

0 323

Question

Jenna Poindexter · Aug 12, 2019

write #

Is there any way to control what control sequence is sent to a device when a "write #" is executed?

I have an application that establishes a banner at the top of the terminal window and when we do a "write #" the banner disappears. I need to be able to recreate the banner line as part of the screen clear.

Thanks

Jenna

#Terminal #Caché

0 3

0 323

Question

Anna Golitsyna · Apr 13, 2023

Breaking a string into words

Is there any ObjectScript or a basic function that takes a string and separates it into words + punctuation/spaces array/list? Just not to reinvent the wheel. Say, process "It is a test, after all" into "It", space, "is", space, "a", space, "test", ", ", "after", space, "all". Or something to that effect.

#ObjectScript #Caché

2 9

0 323

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 323

Question

Eduard Lebedyuk · Jun 18, 2018

Filling document templates - what's your approach?

Let's say I have a user-generated document template with placeholders and I want to replace them with actual values.

Values could be:

scalars
tables
...?

So far I wrote a simple find/replace tool that works with RTF format (because it's not a binary format), here's how it works:

#Caché #Ensemble #InterSystems IRIS

0 2

0 322

Article

Mike Kadow · Jun 11, 2016 2m read

NewBie's Corner Session 7 True and False

NewBie's Corner Session 7 True and False

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 these commands.

In COS, a 0 is false and any other number (positive or negative) is true.

#Terminal #Caché

0 0

0 322

Question

Nicki Vallentgoed · Mar 7, 2016

2016.2.x windows cache studio; cannot delete package

In studio when I right-click a package there is no option to delete it.

Also how do I upload an image to this post without linking to an external site?

#Beginner #Caché #Development Environment #Studio

0 7

0 322

Question

Fabio Goncalves · Dec 14, 2015

Zen Mojo - Disable button on JQM Plugin

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.disableItem('button',true,0);

#Frontend #ZEN #Caché

0 2

0 322

Question

Tamer Rajab · Apr 3, 2017

Weekend

how to exclude weekend(Friday) in sql statement i trade use select datediff(WK,date1,date2) but not working even i chose (Dialect mssQL)

Thank You

#Caché

0 1

0 322

Question

Virginia Rogers · Jan 29, 2018

Guidance on modifying class definitions and switching my application to the new definitions

Hello,

I have a property which I need to move from one class definition to another as follows:

Old definition:

Class SCHED.SchedEntry
{
  
  Property Experiment as %String;

  Property ScanSlot as list of TracerEntry;

}


Class SCHED.TracerEntry
{
  
  Property Tracer As %String

}

I want to move the Experiment property to the TracerEntry class so that there is a different Experiment allowed for each ScanSlot, like this:

#Databases #Frontend #Testing #Caché

1 2

0 322

Article

Rubens Silva · Oct 8, 2019 2m read

Frontier: An abstraction layer for rapid REST development: Part 5 - Errors

Hello again and welcome to the next tutorial on this series: Part 5 - Errors. Here we are going to learn how Frontier handles unexpected errors and how we can force them.

#JSON #REST API #Caché #InterSystems IRIS

Open Exchange app

1 0

0 322

Question

Orlando Lagman · Jan 14, 2021

Saving image data from csp

I created a csp that will capture image data from a html canvas element. I created a button element to save the contents as a dataURL string from jpeg and make a server call.

the string is too long

I would appreciate any suggestions in saving the data into the server, currently just a global.

#CSP #Caché

0 2

0 322

Article

Mihoko Iijima · Aug 31, 2023 1m read

How to rebuild index by ID

InterSystems FAQ rubric

By specifying the start and end values of the IDs for which you want to rebuild indexes in the arguments of the %BuildIndices() method provided in the persistent class (=table) definition, you can rebuild only the indexes within that range.

#Indexing #Object Data Model #Relational Tables #SQL #Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health

5 0

0 322

Question

Richard Roeder · Jun 10, 2019

Force Indice

How to force a specific index in SQL?

#SQL #Caché

0 3

0 322

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 321

Question

CM Wang · Jul 20, 2017

What is the most efficient way to store/retrieve the data into/from global

Type 1:

^global(key1,key2,key3,val1) = ""
^global(key1,key2,key3,val2) = ""
^global(key1,key2,key3,valn) = ""

Type 2:

^global(key1,key2,key3) = $lb(val1,val2,.....valn)

the number of val may be just dozens, but also possible to 10K

Thanks.

#Caché

0 1

0 321

Question

Eduard Lebedyuk · Jul 14, 2017

How can I determine if a query is an SQL or an MDX query

I have a query text that I need to execute and return results as xml.

It may be an SQL query or an MDX query. Is there some easy way to determine which one is it?

Any ideas?

#InterSystems IRIS BI (DeepSee) #MDX #SQL #Caché

0 2

0 321

Question

Francis Galiegue · Apr 18, 2016

Is there a table somewhere of deprecated classes/added keywords/etc and _when_ these changes took place?

Hello,

For CachéQuality I'd love to be able to create issues when the programmer uses classes which are deprecated for this or that version of Caché... But short of reading all the changelogs of all versions, I can't really tell when a command appeared (for instance RETURN; I know now that it appeared in 2014.x, but it took me some time to realize that), or when a (set of) class(es) became deprecated (for instance %GlobalCharacterStream to be replaced with %Stream.GlobalCharacter -- I don't even know since which version this is true :/).

#ObjectScript #Caché

2 2

0 321

Question

Patrik Spisak · Dec 2, 2020

Update object from XML

Hi guys,

I have this method to create object from XML

#XML #Caché

0 1

0 321

Announcement