Hi, guys,

I'm working on zen report to display an examination report for a client.

They stored order information in several tables. Examination findings and diagnosis were recorded in a html page and codes of the page was stored in another table. We need to put them together in one single report.

So far we can only read the html codes from that table which is a whole page since it start from label <html> and have <header>. We know that if we are using javascript we can display the page by assigning the codes to innerHtml property of an iframe object.

0 6
0 481
Question
· Mar 14, 2018
ZEN REPORTS and EXCEL

I have a ZEN report set up to generate a file for loading to into excel (see attached). Even though I have DEFAULTMODE set to "excel" the resulting output file that I get on one CACHE instance is .xml while on another it is .xls. This is even though I run the report from the two instances on the same PC. Can anyone suggest what I am doing wrong? The Cache version is "Cache for UNIX (IBM AIX for System Power System-64) 2013.1.6 (Build 950_1) Fri Jun 6 2014 17:43:51 EDT"

0 4
0 468

Hi All,

Actually, I'm developing few restful API's. I want to create a authentication tokens and display it on my login restful API. If I'm using CSP sessionId, how can I validate the session Id's in another or continues restful API's. else, is there any other approach to handle this task.

My Primary goal is, I have to integrate 2 different front end applications. One is Zen framework another one is web pages from Python.

If any lead, it would be appreciated.

Thanks,

Arun Kumar Durairaj.

0 1
0 465

I need a trick to display the cellTitle for just ONE column in a tablePane with a unique value. Here are the issues:

1. OnDrawCell has access to the cell data for that row/column, in %query(pName), but setting the cellTitle property to a column doesn't refresh the column object

2. Setting showValueInTooltip is good for the entire table, not just one cell

3. ** the column element does not evaluate zen expressions, so I can't say cellTitle="#(%query.Comment)#", for example. That's the crux of the problem.

0 2
0 465

Hi

I have been experimenting with the creation of a set of REST services for an app. The basic GET operation is set to create a %ZEN.proxyObject instance, and then set an instance of a Persistant class as a property, which gives me all of the values I want to return. However, it also gives me some values that I don't want to return over REST (because they are both private, and large registered objects which will bog down performance)

2 3
0 446

I need to open a Windows explorer window by pressing button on a Zen page.

Is this possible.? I

performed a search but I did not find anything.

The command I used in the terminal was D $zf(-2,"START C:\WINDOWS\SYSTEM32").

I am not sure how to use this in a Zen application.

Any help will be greatly appreciated.

0 8
0 442

In our table, we have a column cities, which has a filter which displays the cities of a state depending on the state

For simplicity let's assume we have a page

Property State As %String = "CA"

Our filter should run this query to show all cities of state ca

0 9
0 438

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.

0 4
0 438

There is a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year. The field is represented by a dateText control.

How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ?

0 1
0 436
Article
· Dec 12, 2019 2m read
Creating Portlets in DeepSee

What is a portlet?

The simple answer is: a custom widget. A portlet can exist by itself on a DeepSee dashboard, it can be used along side standard DeepSee widgets, or along side other portlets. The rendering of the custom widget is completely user defined. This means you can embed a web page, create a form to perform any sort of action needed based on the data on your dashboard, use third party charting libraries, or simply display data from outside of a DeepSee cube.

How to get started

6 1
0 436

HI,

I am planning to build a WebApp that will have tons of data to display in tables, ability to add comments on that table rows and may be some few more small features as we move on.

1. It has to be Secure

2. It has to be fast

3. It has to be Non CSP / Non Zen

4. Will have Cache DB to pull records from but should be flexible to do that from any odbc resource

5. Version 2018 Ensemble

My first step would have been to investigate different options for technologies that would make it work and best suited with Ensemble 2018

0 18
1 435

I have been following the online Zen Quickstart Tutorial using the lastest release documentation. In addition to playing around with the styling and making a few minor functionality tweaks, I wanted to add an additional column that shows a count of the number of phone numbers for that Contact (as shown in the image below).

0 4
0 434

Hi,

We maintain a few Zen reports that output in Excel format.

Recently we started to observe that some reports fail and return the following error.

CSP error occurred
Error: Error rendering: OS code =1Use $log=1 to check
ErrorNo: 5001

I have extracted the exception details from the log file

0 1
0 419
Question
· Oct 8, 2020
Report Render Server Error

Hi everyone, i'm using a render server to make pdf output with zen report and everything was fine till recently i've been getting this error message and i have no idea what it means, i'd be very thankfull if someone could help or got into the same situation.

Error message:

ERROR #5001: net.sf.saxon.trans.XPathException: org.apache.fop.fo.ValidationException: "fo:table-body" is missing child elements.
Required content model: marker* (table-row+|table-cell+) (See position 817:-1)

0 4
0 417

Hello,
I have a list of files on disk.
Each record is the fully qualified UNC path and filename.
I would like to send these files to the end users default printer as a document.
I have attempted to build a html page using document.write statements and print using printWindow.print(); command.

I think there must be a better way to send a series of files to the windows print spooler.
I would welcome any and all input.

0 5
0 417

Hi,

I have a Zen Mojo application that haves a tree menu, in this menu I'm loading all records from database (about 1500) and the page is very slow, about 2 seconds to load, I don't know how to get faster.

1 6
0 413

Hi,

we are moving an existing ZEN-Application to a new version of Caché (2017.2.2). It is a rather old application and we need to do some modifications due to the thightend security of ZEN in this and prior release (we came from 2013.1). One of the changes required is to alter a table Name of a ZEN-Table on the server-side. Anyway this gives us a problem, since we receive an error

ERROR #5001: Client modification of protected property ( tableName) disallowed for security reasons.
SOURCELEMENT: %ZEN.Component.tablePane (tpSimilarity)

0 2
0 408
Question
· Aug 25, 2017
Zen Report - ErrorNo: 5540

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

Regards,

Rui

1 4
0 407

Hi,

I want to create a table with a dynamic display of data using the DataGrid.

On the page there dataCombo and the table.

According to the plan, when the user selects an item in dataCombo the table is filled with data. If select another item - data is updated.

But in fact, the data in the table are loaded once when the page is loaded, and when I select value in DataCombo, I receive an error:

0 1
0 399

I'm using FOP 1.1 for ZEN reports and would like to install fonts within the Windows/Fonts directory.

I added the xml tags in fop.xconf but so far I have been unable to get the correct font.

<renderers>
<renderer mime="application/pdf">

<fonts>
<directory>c:\windows\fonts</directory>
<!-- automatically detect operating system installed fonts -->
<auto-detect/>
</fonts>

</renderer>

</renderers>

Any advice would be appreciated.

1 5
0 397
Announcement
· Oct 20, 2018
Looking for work

Hi every body

I hope it's the right place & I'm not offending any body.

I'm a veteran Mumps/Cache/Ensemble programmer . I think my only draw back is my age, although my brain is still young & bubbly.

I'm looking a long time for work without success.

I gathered a lot of knowledge & experience during those long years , developed many projects & i'm ready to do any work only to feel useful.

I'll add my resume, I hope & wish that this post will bring some change as I'm desperate to get some work.

1 0
0 395
Question
· Jul 27, 2021
Method Call

Hi all,
We have a session values in a cache method and need to get those values in a client method (JavaScript).

Eg :
ClassMethod Method1()
{
Set %session.Data("Param1")="Data 1"
}

ClientMethod onloadHandler [Language = javascript]
{
var ret = zenPage.getSessionValues();
}

ClassMethod getSessionValues() As %String [zenMethod]
{
Set Data = $G(%session.Data("Param1"))
Quit Data
}

0 1
0 394

I have a tablePane ZEN Component and I am trying to get a filter running on the Specimen Id / Lab Number. The SQL is fairly complex with 3 UNION ALL statements joining 4 tables and a couple of lookup tables.

How would I get the filter on SpecId to work for my tablePane? It's not automatically applying the filter for me so I think I need code something.

0 1
0 389