CSP front page to allow users to alter multidimensional tables

Question

Question

Scott Roth · Dec 20, 2019

#CSP #Frontend #ObjectScript #SQL #Ensemble

I have a case where I have an external table that lives out in MS SQL. Using Ensemble Security functions has anyone created a csp or cls page that acts like a portal to allow users to Update a multidimensional table without knowing SQL? I could clone the EnsPortal.LookupSettings but that was made for LUT which are only 2 columns.

I know its a long shot but trying to see if there was anything off the shelf that I can use to help meet the requirements of this project.

Discussion (4)2

Log in or sign up to continue

Robert Cemper · Jan 7, 2020

Hi Scott!

Happy new year!
You are right ZEN is out but CSP is not.
With ZEN you might have implemented inline editing.
But is rather simpler to achieve an acceptable result (except coloring) if you separate editing from table view.

The generated page has a SEARCH page that should be easy to configure. <CSP:SEARCH>
And if you force the generated page to start with the search page with maxrows=25 you might cover the needs I understood.

This were my changes:
<head>
<title>Cache Server Page - Sample.Person (SAMPLES)</title>
</head>

<body onload='form_search()'>
<h1 align='center'>

and at end:
</form>
</body>

This is the extended CSP:SEARCH tag:

<csp:search name='form_search'
classname='Sample.Person'
where='ID,Name,DOB,Home.City,Home.State' options='clearbtn,sortbox'
PREDICATES="%startswith,=,contains" MAXROWS=25
SELECT = 'ID,Name,DOB,Home.City,Home.State,Home.Street,Home.Zip'
>

I did the example in namespace SAMPLES

1 0

score 1 · Answer 1 · 2019-12-20T14:42:50-05:00

map your MS SQL Table to a class using SQL gateway

in Studio create a new CSP page

<html>
<head> 
<title> Cache Server Page </title> </head> <body>

My page body
</body>
</html>

use Tool / Templates / WebForm Assistant
select your Class and the Properties you need
compile it
use it

score 0 · Answer 2 · 2019-12-20T16:22:49-05:00

here ist lengthy doc to the wizard

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSTD_Start#GSTD_CreateWeb

score 0 · Answer 3 · 2020-01-06T16:14:24-05:00

I am struggling with understanding how to display the table within the CSP page. In reading the document it mentions ZEN, but as we have been told not to use ZEN because ZEN is going away.

So how can I display the SQL table in a table format that could be updated instead of the form document mentioned above? Most of the examples are only 1 or 2 rows. I am looking at a 25 rows x 6 columns table to display and update.

I got the above to work, just trying to make it more friendly.

Thanks

Scott