#Caché

Hi-

Does anyone have an example of manipulating Zen tablePane columns programmatically?

Specifically, clearing out the columns and adding a new set of columns.

It would be helpful if you had both a server side and client side example.

Thanks

Documentation here lists the kinds of members a class definition may contain. In summary:

• Parameters
• Methods
• Properties
• Class queries
• XData blocks
• Projections
• (and some that are relevant only for persistent classes):
  • Storage definitions
  • Indices
  • Foreign keys
  • SQL triggers

Later in the same document, a section headed "Class Member Names" contains this warning:

So I'm interested to hear how other DC members handle this.

1. Do you comply (or at least attempt to comply) with this?
2. If so, do you use any tools or naming conventions to assist you?

Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST [HealthShare Modules:Core:12.07.3703 + Linkage Engine:13.04.3703]

Use case: Search an LDAP database from Caché over TLS using Mutual Authentication.

Extract from the %SYS.LDAP documentation:

Hi community ,

i work actually on the access token generation method , i want know where the generated access token are saved ?

My [OAuth2.AccessToken]  tabe is empty , it's logical?

thank's for helping .

Best regards

Hi Guys,

I would to know, I have a drop down list items in my applications. While, am clicking on the drop down bx, there are few numbers of listed items, while am doing mouse over action, I should display the entire text of selected item from that drop down list box, even am not selecting that item. I would like to know about the what is exact text it contains in Zen framework. 

If any lead would be appreciated. 

Thank you in advance. 

New Windows 10 Cache [ TRYCACHE] successfully installed - but unable to log onto the Management Portal . What "User Name" and "Password" are being asked for? No opportunity to specify the sources. Thanks.

Hi,

Is it possible to Save a base64 data string, representing a png, as a binary png file, In Cache?

When I search google , in general , not Cache specifically,  I see such articles:

https://stackoverflow.com/questions/11511511/how-to-save-a-png-image-se…

and this answer:

You need to extract the base64 image data from that string, decode it and then you can save it to disk, you don't need GD since it already is a png.

But I don't know how to implement that in Cache.

Regards,

Nael

Hi,

      Has anybody used /epic/prd/bin/runlevel with different options to bring up or shutdown the cache db. I cannot see any information about it in the manual.

Regards,

Anil

Hi All,

Does anybody has experience with Angular application and have implemented some solution in order to track and record pageviews?

We are interested in to know how to capture those pageviews information and call a Caché REST Api in order to store those data.

Thanks.

My question is actually about IDKEY since Primary Key is the common concept of SQL.

Why do we need IDKEY? In what kind of scenario, the IDKEY would be different from Primary Key?

Thanks.

Hi, 

I would like to set the report headerHeight dynamically based on a group records count.

Example:

If GroupA has 5 records then the headerHeight should be 50mm

If GroupA has 3 records then the headerHeight should be 30mm

Could you please advice the best approach to achieve this?

Thank you,

Rui

Is there an API that would list classes within a given package? I can't find any. I do have a workaround that uses class index, but this query lists all classes available in the namespace and I have to filter those I want. But this is just unnecessary overhead.

If anyone has spotted such API, please let me know.

TIA!

Dan

Hello,

I am using CSP:search and would like to customize the appearance of pop-up search page with CSS.  Any help is appreciated.

Thanks.

Dave

There is an option in Studio (Environment-Advanced) to "Automatically reload documents when it has changed on the server and it has not been edited in Studio".  I want this flag on but every time the re-load happens it adds a blank line at the bottom of the routine.  Is there any way to stop that from happening?

Thanks.

Zen report can create PDF document (https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GRPT_xslfo_pdf_config ). Store your images in the table. Pass session id to the Zen report. Zen report will select images using SQL. The <img> element will insert images to the report:

<img width="100%" src="!@ImageName" contentHeight="scale-to-fit" contentWidth="#(..ImageWidth)#" style="position:absolute" content-type="image/jpg"/> 

Do the following (See the attachment image_to_pdf_using_zen_reports.doc

Currently to check if the class  is mapped I call:

ClassMethod IsClassMapped(class) As %Boolean

{
  set sc = $system.OBJ.GetClassList(.classes,"/system=0 /percent=0 /mapped=0")
  quit $data(classes(class))
}

And it works, but I'm interested if there is a simpler approach out there?

We had multiple failures because of disk space on cache . IS there a script or tool to monitor disk space used by cache which can used by say patrol and  alert us. Thanks for your help in advance. I am looking for something to work on AIX

I am using OnDrawCell for a column in a tablepane. The OnDrawCell triggers the onselectrow attribute of the tablepane. I only want to reformat the data in the column. Is there a way to not trigger the onselectrow? Thank you.

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…

Dave

Hi Guys,

Can you please advise me on how to display the content of the selected item/text from the drop down box listed item in our zen framework.

Thanks in advance. 

Hi Guys,

I would like to know, how to setup a global structure in Cache classes storage type.

I want to set a global like below in Cache classes using Storage methods.

^A("ID1")="Name\Abb\Map"

^A("ID2")="Name\Abb\Map"

^A("ID3")="Name\Abb\Map"

...

If any lead it would be appreciated. 

Thanks,

Arun Kumar Durairaj.

Hi 

I am new to cache and accessing it using odbc (other data sources) from excel. I need to know how to get hold of the number of rows for each every object in my current schema. 

I can find table name using following query but I need number of rows to estimate size of each table.

SELECT *
FROM %Dictionary.ClassDefinition ClassDefinition

Hi. I am learning create Rest service  with Cache. From this repo. https://github.com/intersystems-ru/REST

I created new web application from Web Applications  section in Management Portal. Such as screenshot.  In browser  call http://127.0.0.1:57772/rest/test . But got  "Service Unavailable" 503 response.  Could you please help?

This might be more of a math problem than a Caché question.
I have a SQL query that joins two tables. I want to assign a unique ID to each row of the product table.

1. I could append the GUIDs of the rows in the two tables, but there are a number of clients that expect a maximum length of 50 on this unique ID. Two GUIDs appended make 72 characters.
2. I could append the two GUIDs and then truncate the result, but now I'm worried about collision.

What's the chance of collision if I append the GUIDs and truncate the result to 50 characters? Is there a good way to solve this without updating the clients?

I am trying to write an application that will take some information on the database make a call to the Google API distance matrix and get the information to use with rest of the application without using the ensemble part of the development is this possible and how can I do my communication with the  API from a cache class thanks in  advance

We have noticed in the course of the last 18 days our CACHE.dat has grown by 20 GB. Is there a way we can break down the data in CACHE.dat to see what could be growing in size?

Let me state it another way.....Is there a way to see what space an Operation/Service/Process is taking up within a certain Production?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

As I was going though and trying to figure out why our CACHE.dat has increased in size over the past 18 days, I found that EnsLib_HL7.Message is still retaining messages dating back to 2014 even though we have our purge set to 10 days. Has anyone else experienced this?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

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:

Class SCHED.SchedEntry 
{

  Property ScanSlot as list of TracerEntry;

}

Looking at the documentation expalining the use of client side menus, including the drop down menu.

I was messing around trying to get the "Open", once clicked, to use javascript to open windows file explorer to open/pick a file.

I've got it to partially work... Using keystrokes Ctrl-O will open the file explorer yet clicking on the drop down's File/Open does nothing.

Not sure what I'm doing wrong here.

NOTE:  I had commented out the two &html lines in the Testing Method... and doing a Ctrl-O still work.

Why?

 /// Created using the page template: DefaultPublisherDB.NewClass1