Hi

Set jsonObject={}.%FromJSON(jsonString) doesn't seems to work and couldn't find %FromJSON in Docs is this available in Ensemble 2014 which I'm using?

thanks

Thanks

Sorry guys for the delay but it has been a busy week.

basically, this is the query I'm using and attached is a file with the classes used:

Select distinct kc.id,MSDS_UI_Serenity_Report.KitContentMissingType16_FindSerialNo(i.id,kc.id,9237,'00007SV3') As SerialNo, CASE WHEN i.Code IS NOT NULL THEN i.Code ELSE ' ' END As Code, MSDS_UI_Serenity_Report.KitContentType3_GetGroupedName(i.Name,kc.GroupFlag,kc.SubGroupFlag) As InstName, kc.Quantity as Qty,MSDS_UI_Serenity_Report.KitContentMissingType12_GetContentRemarks(k.Loc,k.id,kc.id,'00007SV3') As ContentRemarks, kc.GroupCount As GroupCount, g.Name As grp, MSDS_UI_Serenity_Report.KitContentMissingType16_Getpck(i.id,'00007SV3',kc.Quantity,kc.id,kc.kitId) As pck, MSDS_UI_Serenity_Report.KitContentMissingType15_GetDecon(kc.id,5) As decon, MSDS_UI_Serenity_Report.KitContentMissingType16_GetComments(i.id,kc.id) As Comment, MSDS_UI_Serenity_Report.KitContentMissingType16_GetReason(i.id,kc.id) As Reason, MSDS_UI_Serenity_Report.KitContentMissingType16_GetRemarks(i.id) As Remark 
     From MSDS_Serenity.KitContent kc, MSDS_Serenity.Kit k, MSDS_Serenity.InstrumentGroup g, MSDS_Serenity.Instrument i, MSDS_Serenity.CustomInstrument ci 
     where i.active = 1 and (i.IsImplants is null or i.IsImplants!=1) and kc.instrument = i.id and i.groupid = g.id and k.id = kc.kitid and k.Loc = 5 and k.id = 9237 order by kc.Position,i.Name

usedclassesdef.zip  

although all the fields used are indexed but still this sample query takes around 1 min & 40 sec to generate 48 records and some other queries with more records could take around 10 mins.

I noticed, that most time is consumed and heavy processing is in class calls in the query :

Eg. MSDS_UI_Serenity_Report.KitContentMissingType16_FindSerialNo around 40 sec but I’ve created and built indexes for all used fields (through SMP)!?

Thanks

Thanks

Sorry this is just too vague, and sort of result I got from googling around, I'm new to this and I was after a just a quick sample using ensemble objects on how to create a Post HTTP request and where to include my curl, then send the request ..etc

Thanks

I want to use a curl to make a HTTP post request.

thanks

Thanks you very much Vitaliy this worked:

select TO_CHAR(avg(PackingTimeSpent),'HH24:MI:SS') average from MSDS_Serenity.KitlabelAssoc where label='00007IT4'

Thanks

Thanks again Vitaliy but we still going on cycles 😊 as I already you examples and I send you the a screenshot with the result and still not working, maybe I'm missing what you trying to say but I already tried option 1 with Timeformat=1 for the avg and didn't work.

your solution 1 or 2 works fine if querying the required field but not with avg, so eg. select %external(CAST(+avg(166.38) as TIME)) didn't work for me, maybe as you mentioned it's treating as double with floating precision that why it's cutting off the seconds, you mentioned the example above and I'm not sure to which one are youi refering to with so many replies, so can you point me to which one exactly because select %external(CAST(+avg(166.38) as TIME)) wouldn't work?

Thanks

Thanks  Vitaliy, you answers has been very helpful in many ways, but as you can see I've tried options from your simple sample with the queries you provided but it came up empty as attached, could it be the Ensemble version 2014?

Thanks

That's it, Thanks Jean

Thanks Robert but that's not what I'm after, I'm looking for the command that if type in the terminal it changes the prompt from eg. User>  to something like ^G  (I think) where then I browse to any global and check it's content? 

avg trancated the second as before:

Thank you very much the format fixed it:

but the only problem is that the average function brings up the logical mode not display!?

I'm using SMP and it's still not showing the seconds (see below):

and if I set my field to  166 seconds it show 00:02, so for some reason it's not showing the seconds?

Actually I did, but the SQL query didn't pick up the seconds .

this my field def:

then quering in logical mode looks ok:

but on Display or ODBC mode, comes up as 00:00

thanks

Thanks you very mutch Julie you've been very helpfull

Cheers

Thank you very much Julie, your sample is exactly what I was looking for the only thing I need to add is some headings and information that I need to display at the top or the spreadsheet so I guess for that I can use Attributes!? And I also notice that elements aren’t widely supported in other formats ( pdf) and html tags aren’t supported in xlsx.

Thanks

Yes all I need is an output in one sheet.

I've changed the mode "excel" but I got the attached messy output .

Thanks  

I clicked on save as where only two options to save as .zip or all files, so I picked all files and forced .xls extension but the generated file is all over the place.

the purpose of this project is to all the user to view a spreadsheet when clicking the "View Excel Format" or prompt the user to open the generated spreadsheet in downloads, and using Generate method maybe better in my case, so how can I send the generated file to open up in in the browser?

I've seen a sample that uses GenerateReport() but that save a file in a pre-defined path but then I would like to instead send the generated file to the browser for the user to view it, any suggestions?

Thanks

Thanks Julie

Ok if you try exporting and opening a Zen report to Excel in a machine that doesn't have MS excel installed you want to be able to open the exported file.

With Crystal reports for example there a runtime EXE that you can install that have all required DLLs and files that allow the user to view a crystal report without having to install the full version of Crystal (see this link for more info:https://www.tektutorialshub.com/crystal-reports/how-to-download-and-ins…) 

So I'm asking if there is a Runtime EXE for excel or MS Office that I can install to allow users to open & view the generated .csv report?

Thanks

It did work for me when I set the    DEFAULTMODE ="pdf" but didn't with   DEFAULTMODE ="xlsx", I think because the server doesn't have MS office, is there an Excel runtime utility that I can install? 

the other problem is that in all my zen reports the data are presented in a datagrid and changing the defaultmode ='"xlsx" will result in out of whack result (see for example the sample ZENReports.PageLayouts and try to change the defaultmode to xlsx and you will what I mean).

Thanks

Thanks David, I'll try this and let you know.

Thanks

I've seen this sample, but this one will save the file to a specific path, I'm looking for a way to popup and open the file in my screen, or have the option to Open/Save file in my browser, the same way you get in websites?

Thanks

Thanks David