Question Nezla · May 15, 2022 Collapsible or expandable Tablepane Hi Guys, How do I add another tablepane or gridview to make my tablepane look like expandable and collapses back as in the below pic? so basically I would like to add a child tablepane or gridview for each row that populate the related details for it. #Ensemble 0 1 0 200
Question Nezla · May 9, 2022 Convert %CharacterStream to JSON and JSON to %Stream.GlobalCharacter Hi Guys, Can you pls let me how to convert %CharacterStream to JSON and also how to Convert JSON to %Stream.GlobalCharacter? Thanks #Ensemble 0 3 0 1.2K
Question Nezla · May 8, 2022 Handling %GlobalCharacterStream in a Production Service Hi Guys, #Ensemble 0 2 0 278
Question Nezla · May 7, 2022 Cloning a class Hi Guys, we have a class with over 24 million records and despite indexes querying is still slow, so we are looking to create a copy or clone of our current class have an scheduled task that runs every night or month, copy old records this new clone (eg. from last month) and remove old them from our current class. #Ensemble 0 6 0 487
Question Nezla · May 7, 2022 HTTP request using a curl Hi guys, How do I create a make a http request using curl, I've found samples on how to do it from a command prompt but how to create and make a http post request and get a response with ensemble object and functions? I guess somthing like : #Ensemble 0 2 0 590
Question Nezla · May 4, 2022 HTTP post request Hi Guys, How do I do a HTTP post request using a curl and get a response, the response should be a JSON file ? a sample code would be really appreciated. Thanks #Ensemble 0 4 0 448
Question Nezla · May 3, 2022 Resultset to JSON Hi Guys, How do I convert a Query resultset to JSON file ? Thanks #Ensemble 0 4 0 708
Question Nezla · Apr 27, 2022 Maximum allowed System Tasks Hi guys, We have created a utility to allow users to create a System task for a list of items the same way it’s done via SMP (attached below), the problem is that there may items and those systems tasks will grow a maybe exceed a couple of thousands so : #Ensemble 0 1 0 248
Question Nezla · Apr 26, 2022 CAST an average time problem Hi guys, I have a %Time filed with (Format=1) to allow showing hh.mm.ss and the field is showing fine in display mode eg: it should show 00:07:30 but the seconds are cut off from it as below : #Ensemble 0 8 0 281
Question Nezla · Apr 18, 2022 View Globals from Terminal Hi Guys, I know that there a way to view global content from the Terminal rather the SMP but I can't remember the command, I think it's something like D ^Global or something !? Thanks #Ensemble 0 6 0 645
Question Nezla · Apr 15, 2022 Export to Excel problem Hi Guys, I'm using the below code to export to excel and it's working fine for one client but not for another and both clients are running the same version of IE 11. for the second client the code generates an empty xlsx file and when I try to open it it says file corupted although data exits in the resultset, so is there a flag or setting needs be done in the client server or IE? #Ensemble 0 1 0 326
Question Nezla · Apr 12, 2022 Dealing with time format as string Hi Guys, I'm using seconds counter then save those seconds in a field defined as string where eg. I do : S time=30 S time = $zt(time,1) #Ensemble 0 11 0 386
Question Nezla · Apr 10, 2022 SQL query confusion Hi Guys, I'm a bit confused where if I run a query trough SMP I don't get any result which should be true but if I run the same query from a classmethod I get a query result which shouldn’t be even if I pass any gibberish parameter into my class method because I'm sure there should be any data? see attached #Ensemble 0 7 0 309
Question Nezla · Apr 6, 2022 tablePane row selection Hi Guys, I've the below tablePane and for some reason when it's populated always the last row is selected by default, I've many tablePanes defined the same way but none of them has the last row selected when populate, so not sure why this grid is doing this? #Ensemble 0 3 0 257
Question Nezla · Mar 24, 2022 Insert Row by enforcing ID Hi Guys, Can I insert a new row and enforcing my own ID not the default id increment? &sql(INSERT INTO Sample.Person (ID,Name,SSN) VALUES ('205','Swift,Jonathan','111-22-3333')) IF (SQLCODE = 0) { Write "New Person inserted with ID: ", %ROWID,! } else {WRITE !,"SQLCODE=",SQLCODE," ",%msg } #Ensemble 0 1 0 351
Question Nezla · Mar 22, 2022 Import Access database Hi Guys, is there an easy way to import MS Access database into ensemble? Thanks #Ensemble 0 1 0 300
Question Nezla · Feb 15, 2022 Select top field in SQL query Hi Guys, I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field? #Ensemble 0 2 0 389
Question Nezla · Feb 8, 2022 Viewing query string from %ResultSet Hi guys, just a quick question on how get the sql statement that has been executed in a %ResultSet? so basically after the execute command I would like to save the SQL statement generated in a eg, a global and check sql statement? #Ensemble 0 3 0 426
Question Nezla · Feb 3, 2022 Adding Ensemble cube to startup programs Hi guys, I've two Ensemble instances running in a 2016 server but only one of them showing in startup programs. the ensemble cubes doesn't showup in the programs list from the Start button as well so how can I add the cube so I can access it's facilities (Studio, MP,...etc) #Ensemble 0 4 0 265