DynamicObject is not in memory thus can't be passed along as a request property
You have to convert to json string and convert it back when you get the request. That's the whole concept of it
If you need any help in implementation, let me know. You can email me directly
If you have team viewer,I can take a look at your code and resolve it.
Thank You Vladimir
However the problem is in FilterQuery param not the table. Table params are working fine.
<column colName="State" colExpression="Home_State" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State"
filterOp="="/>
Just in this we need to add a where clause which takes a page property which is not working
<column colName="City" colExpression="Home_City" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_City FROM ZENDemo_Data.Patient Where Home_State = #(%page.State)# ORDER BY Home_City"
filterOp="="/>
Context dies in the call thus can't be carried forward to next calls. That's why we have request / responses.
Theoretically it's not possible.
Context superclass is if you want to have a class with basic properties you need everywhere, like an Abstract Class
Callbacks are for Stored Procedures which are a part of Database.
What I would suggest is make a minimal view in your namespace 2 and just share that with Namespace1 , if that works for you
Zen stores data in snapshots for pagination. May be its not able to do so by a callback method.
Hey Vladimir,
Apology for a late reply, was tied up in something else.
Pls pardon me if I am wrong , from what I can tell this code and all other codes are filtering the table by state which is like saying Select * from Patient where State = 'CA' . Correct?
My problem is quiet the opposite.
I have picked up this snippet from your own code
<column colName="City" colExpression="Home_City" width="25%" filterType="text"/>
<column colName="State" colExpression="Home_State" width="10%" filterType="query"
filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State"
filterOp="="/>
City needs to be "filterQuery" and query should say
Select Distinct city from Patient where State = this.state
So basically this city filter should only show cities of the state we are working on.
May be rephrase the question.
Also Java and Cache are polls apart.
Well finally I figured it out myself
We have to use DrawFilter and there use resultSet etc and use page property as a parameter.
There seems to be no other simpler way.
If anyone needs any help in ever implementing the same. Pls feel free to ping me nv@nv-enterprises.biz
I am getting this error
0 ´AError rendering: java probably not in path, Use $LOG=1 to checkdRESTARTV:e^zcomputeDirectStatus+2^%SYS.ZENReportExcelExporter.1^14e^zCommonExport+45^%SYS.ZENReportExcelExporter.1^12e^zgenerateXLSXfromXML+11^Utils.XLSX.1^11e^zgenerateFileFromSQL+6^Utils.XLSX.1^1^^Utils.XLSX.1^01E^zgenerateXMLFromSQL+12^Utils.XLSX.1^11e^zgenerateFileFromSQL+4^Utils.XLSX.1^1e^^^0
HI
I am using example 1
and getting this error
X.1^1e^^^0
0 J"Cannot contact server on port 0.
w ##class(Utils.XLSX).generateFileFromSQL("a.xlxs")
Yes that's gone. Had never needed java before.
Now new error. Which I posted too.
How to start that?
Just installing java not enough?
JAVA_HOME was not set. It was directly set into PATH
Now it's running.
Starting ZRExcelServer... Executing: C:\InterSystems\Ensemble2018\lib\ExcelExporter\runserver.bat -port 5005 -numthreads 5 -loglevel 3 -logfile C:\InterSystems\Ensemble2018\mgr\Temp\ -maxlogfilesize 32000 -logrotationcount 100 -numpingthreads 5 -pingport 5006 Returned from execution: CACHEPATH=C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\.. LOCALCLASSPATH=;C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\..\lib\ExcelExporter\excelexporter.jar jun. 04, 2019 8:30:14 A. M. com.intersys.excel.ExcelServer go INFO: Listening on port 5005 jun. 04, 2019 8:30:14 A. M. com.intersys.excel.PingServer init INFO: Ping Server Listening on port 5006 The Excel Server has been successfully started
However the command still shows same error. How to route it to use the above tcp ports?
J"Cannot contact server on port 0.
So you saying we make a static csp file that will display excel. This may be an easy solution but really hard to configure and pass params too and then attach it as an excel in email
HI. I have tried this but getting this error even after giving all rights to directory
set sc = ##class(Converter.LibreOffice).convert("C:\Temp\a.csv", "C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx", ".xlxs")
ERROR #5001: Error moving 'C:\InterSystems\Ensemble2018\mgr\Temp\145158\a..xlxs1C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx' with code: -2
Can you please send it to me as well nv@nv-enterprises.biz
Thank you in advance
Yes, that I was already doing in my business operation that sends the email
Read through some data. Iterate it and display a simple html in tables / rows. It works
Now requirement is to generate an excel file and then attach it to the email itself instead of displaying html table in the email
This does makes an excel and also attaches. But it doens't open in email
Really nice guys.
I do not have a use for it now, but definitely a really good one
JSONStreamToObect should do it.
If you can just paste the exact json, I can write it for you. No biggy
You can use this site to verify if json is correct
Link you have given and the json you have pasted are totally different
If you can put the right json or point to the right rest, should be able to help you out
Also disable win firewall once you do resolve licence issue
No, it is JSON . Just one simple missing bracket. Here is the correct json for the same
{
error:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
],
error2:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
]
}
Json parsers are parsing it.
However I haven't tried to run it by code to see if it works.
Am I reading it wrong? Dont see port number anywhre
2 - Namespace name. For example, %SYS>. The current namespace name is contained in the $NAMESPACE special variable. It can be an explicit namespace name or an implied namespace name.
3 - Config name. The name of your system installation. For example, IRIS2>. This is the same for all of your terminal processes
Pls provide your emailid.
A lovely and very enriching discussion
And if just want to delete. it can be done from Studio as well
Its in the "Other" section