servoy / aggridcomponents Goto Github PK

Please see screenshot

Would it be possible to add MasterDetail option to AgGrid?..

See the 'Customer's orders' example on demo.servoy.com: remove the default grouping and then group on zipcode: some records have an empty zipcode and when grouped, agrouping line is added for these (I guess) at the top, but the + button to expand the group row doesn't exist, so you cannot get to the actual records

Note that on the other Grouping Grid example it does seem to work

I have tried to align the AG Grid headers with the content that is in the grid columns but I have not been able to. I can however align the column data easily by setting a css style class to the the column. When I apply a similar css styling to the header style class it does not align and it seems that this is because the label is contained in ag-cell-label while the header style class is altering ag-header-cell. Is there any way to align the column headers to match the column data?

I am trying to remove a column from the grid on load depending on the user. Whenever I try to delete a column that a user shouldn't see all the columns seem to get reset and the column is not removed from the view. The columns array seems correct but the view is not reflecting those changes.

I tried to remove the column onShow and onLoad and both seem to do the same thing. Is there something I am missing?

Can we add the ability to get the Column Name or Header Text similar to how you can get it from the servoyextra-table ( table_1.columns[columnindex].headerText ).

AG-Grid already seems to have functions that get you that information in the Column API: https://www.ag-grid.com/javascript-grid-column-api/#gsc.tab=0

Hi, I miss the function newColumn like in the Table Bootstrap Component..
I don`t know if it is possible to develop this in this component.

Thanks.

Juan Ramírez

Using the function getColumnState() you would get a JSON string which would save the width, position, etc.. for the columns in a table. This JSON string can be used as a parameter in the function restoreColumnState so the grid's columns would return to the state saved in the JSON string. After the most recent update the restoreColumnState() function works as long as there is no parameter, but once you pass in a parameter the function keeps returning false and not changing the state of the columns at all anymore.

Grid having multiple columns, user is perform sorting with different column by clicking on sorting icons
then some time, grid is going to hang stage and only display loader

We have a search layout that uses the aggrid to display results. If the user searches for something that doesn't exist, the aggrid doesn't clear. You can still click on the records, but this shows up in the Servoy Developer console:

ERROR org.sablo.websocket.WebsocketEndpoint - Error: null

I've tried doing a foundset.clear() before the search, as well as elements.groupingtable_28.myFoundset.foundset.clear();. I tried elements.groupingtable_28.refreshData() and that clears the data for the records, but the rows themselves still show up and produce that Error: null message when clicked.

I am using the AG Grid component and the sorting is not working correctly on the calculated fields. I have even checked the Servoy Admin Logs and was not able to see any error over there. The only error which I am able to get is in the console which says "sort column promise resolved". Please let me know if I am doing something wrong here. I am attaching the screenshot of the calculated field and it can seen where 50LB BAG is between the BULK .

Regards Panth

It would be good if elements.fsGridDG.myFoundset.foundset.getSelectedRecord(); worked when row is grouped.

When we try to access the relations in a record from the onCellClick() event we just get an undefined.

/**
 * Called when the mouse is clicked on a row/cell (foundset and column indexes are given).
 * the foundsetindex is always -1 when there are grouped rows
 * the record is not an actual JSRecord but an object having the dataprovider values of the clicked record
 *
 * @param {Number} foundsetindex
 * @param {Number} [columnindex]
 * @param {JSRecord<db:/nphs_fsms/resources>} [record]
 * @param {JSEvent} [event]
 *
 * @properties={typeid:24,uuid:"25F231E7-4B37-4813-933D-2AB9066FB9D5"}
 */
function grdResources_onCellClick(foundsetindex, columnindex, record, event) {
	application.output(record);
	application.output(record.resources_to_resource_booking_types);
}

We need functionality to export the data in grid to csv file with additional parameters we may need to pass like column separator, etc

We would like to add the ability to enable or disable sorting and the menu column on specific columns. Since it's currently not possible to sort on Calculated Columns, we would like to completely remove the ability of the user to click on the column header to sort the column.

Also, we would like the ability to hide the menu button on a specific column (so that they do not see the grouping option).

Hi,
the process onCellDoubleClick have 4 arguments the third argument says that is a JSRecord but is not , is an object. the problem is when we are using de svyNavigation in the process "scopes.svyNavigation.open" we are doing tricks things to change to a JSRecord .
I was wondering if the right way, shouldn't it be to return a JSRecord?

Un Saludo

Juan Ramírez

Hello,

In case of lazy loading option, Display counter for respected group (means group count) before expand any group.

For example, below SQL query
select Order_Id,Count(Order_Id) from order group by Order_Id

Please suggest technical implementation in AG-Grid grouping component

Thank you

Could we include the expanded group view in state restore.
So If you have a grouped row and expanded to show grouped records, after columnStateRestore the groups are contracted.

I just upgraded to lastest ngGrid, but all my grouped rows in powergrid show 'undefined' at each column

The datagrid currently supports column options in order to specify columnDefs.
This feature is missing from the power grid, can this be implemented?

The ag-grid has no tooltip for the headers. If the header is small and if the header title is long then it is pretty hard to read and fit that text. If there is a tooltip then it would be easy to include more columns and the header title can be kept long.

Would it be possible to add a option to set the Datagrid to readonly and override all columns edit definitions, or is there a current way of doing this?

Servoy NG Grid method getColumnState() does not return correct column state of grid always. Only first call returns correct column state, further calls return default grid column states which were set initially.

For example, if we hide some columns and call getColumnState() method (for first time after hiding columns) we get correct column states. But if we make call again, we get default grid column states i.e. all columns will be visible.

Trying to find out a way to increase the height of the header row of the table. Tried using CSS but cannot seem to find a good way to increase the height from the default 25px.

if we add a column that has no dataprovider connected. (for use with a button) ,
the data in other columns disappear.

Hi,
reading your wiki for Grid Height in Responsive y follow it and it works perfect.

Adding a table in a flex-content layout and setting the table responsiveHeight property to 0, let the table grow up to 100% height of parent element (see more on flex-layout here).

But if that form I try to show in an another responsive form through a tabPannel (Bootstrap Components) it does not show the related form.

What I am doing wrong?
What the proper way to solve that situation?

Thanks in advance

Un Saludo

Juan Ramírez

Getting the following error in servoy-admin when grouping a column. Note that this works in developer without any issues, but when deployed it gives this error and it doesn't group:

org.mozilla.javascript.EcmaError: TypeError: Cannot read property "0" from undefined at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3772) at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3756) at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3777) at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3793) at org.mozilla.javascript.ScriptRuntime.undefReadError(ScriptRuntime.java:3804) at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1456) at org.mozilla.javascript.gen.C__tomcat_webapps_WebClient_aggrid_groupingtable_groupingtable_server_js_9._c_anonymous_1(Unknown Source) at org.mozilla.javascript.gen.C__tomcat_webapps_WebClient_aggrid_groupingtable_groupingtable_server_js_9.call(Unknown Source) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:406) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3204) at org.mozilla.javascript.gen.C__tomcat_webapps_WebClient_aggrid_groupingtable_groupingtable_server_js_9.call(Unknown Source) at com.servoy.j2db.server.ngclient.component.RuntimeWebComponent.executeScopeFunction(RuntimeWebComponent.java:150) at com.servoy.j2db.server.ngclient.NGFormServiceHandler.executeMethod(NGFormServiceHandler.java:411) at org.sablo.websocket.WebsocketEndpoint$5.run(WebsocketEndpoint.java:333) at org.sablo.eventthread.Event$1.run(Event.java:100) at org.sablo.websocket.CurrentWindow.runForWindow(CurrentWindow.java:77) at org.sablo.eventthread.Event.execute(Event.java:90) at org.sablo.eventthread.EventDispatcher.dispatch(EventDispatcher.java:125) at org.sablo.eventthread.EventDispatcher.run(EventDispatcher.java:89) at com.servoy.j2db.server.ngclient.eventthread.NGEventDispatcher.run(NGEventDispatcher.java:55) at java.lang.Thread.run(Unknown Source)

The Grid is located in a responsive form.

Can this be implemented?, or is already possible..
https://www.ag-grid.com/javascript-grid-for-print/

I was trying to display data in the powergrid coming from an Oracle database, which will return all column names in uppercase.
It took me some time to realise that setting the dataprovider with the exact same name in lower case, was actually the issue why my data wasn't displayed.
This is kind of an exception on how Servoy is handling dataproviders everywhere else. Is this something that can be changed?

I have a simple orders_to_orders_detail relation.

My setup has two aggrid tables one for orders and one for order_details.

When I do a simple record selection in orders I expect the data to update and reflect in order_details. It does not and instead it shows nothing. This is working for other tables/components.

With some of the new changes functionality was added to be able to navigate the grid using the arrow keys but there is no way to focus on the grid or change focus to another element after clicking on the grid. The tab key does not do anything when focused on the grid.

Feature request: navigate to the selected record when the foundset's selected record is changed.

Support question to ag-grid for such feature: https://ag-grid.com/forum/showthread.php?tid=6223

For a number of projects I am involved in the transition from smart- to NG client.
As a replacement for the datasetgrid (servoy-plugins.de), the power grid is used.
The datasetgrid however could handle text wrapping where the rowheight was expanding with the number of text lines.
The AG grid seems to have this possibility by using 'autoheight', but this is currently not possible in the power grid.
Could this be added as an option?

Will like to have a double click event handler on column level.

I am using the datagrid web component for related line item data extensively im my solution, but since updating to ver 2.2 I am getting the following error

ERROR org.sablo.BrowserConsole - D9A64A7:2|D830997D-E1C4-4251-A20C-181A067FDE0C||Uncaught TypeError: Cannot read property 'columns' of undefined
http://localhost:8090/aggrid/groupingtable/groupingtable.js:4323:55
TypeError: Cannot read property 'columns' of undefined

I can work around it by saving the columnState & restoring manually through an onHide onShow method, but I dont really want to do that everywhere.. on tables that forbid user sorting, grouping etc.

Currently the row data starts in the same column as where the expandable/collapsable grouping keys are located.

There is already a 'groupUseEntireRow' option, but that puts ever grouping level in it's own column, which looks ugly.

It should be possible to have all the grouping keys in the same column (without column heading text), with each level slightly indented, like can be seen in this AGGrid example: https://plnkr.co/edit/kpHZaH1qBHIXMarbSh9V?p=preview

Changes to foundset columns are also done to the db as usual, but there is no onDataChange event for related columns to attach a saveData. The only way I found is to add a button to saveData but this can cause multiple changes to be lost if the user does not click that button. I tried to run that method under onColumnDataChange event but it is not fired.

What is the best way to write related column changes into the db using Data Grid?

Hi,
I am trying to use Grouping Table API "getGroupedSelection" an it give me an error.
when I launch elements.mygrid.getGroupedSelection() it return :

"Error during evaluation:Unexpected: Incorrect return value (0 - not even null/undefined) from client for message (could be due to a close/exit cancelling all pending sync req. to client). Content: []"

What I'm doing wrong?

Un Saludo

Juan Ramírez

I feel this would be a great addition to the AG grid component.
The current styleClassDataprovider/calculated icon workaround works, but it would be much more efficient to have it as a default feature bound to a field. Thanks for considering this!

Hi,
I have a Grid that I change the height through the gridOptions when the ColumnStateChanged.
It works but I have to get out of that forms and return to it.
Does any function for refresh the view when you change the gridOptions?

I sow that in the ag-Grid Documentation:
https://www.ag-grid.com/javascript-grid-refresh/

Un Saludo

Juan Ramírez

Hi,
Is there a way to get the displayed Dataset from a powergrid, it would save running the query again to use the data somewhere else..
Something like..
elements.mypowergrid.getDataset..

Hi,
Is there a example of how to use groupRowRendererFunc?, I would like to show some additional column information on the grouped row.

This is an issue of the enterprise row model of ag-grid.
Created related issue
ag-grid/ag-grid-enterprise#143

Is it possible to save user entered column filter values, as part of the getColumnState function?, I am using both the Powergrid and Datagrids in conjunction with the sidenav webcomponent solution.

I am trying to show edit and delete icon on the hover of the ag-grid. I am trying it by using css and applying it on styleclass in a column of the ag-grid. When I do this the ag-grid gets disappeared.

this is the snippet of my css

.ag-table .ag-cell > tr:hover .row-edit > div:before {
text-align: center;
font-family: FontAwesome;
content: "\f040";
}

Hello Everybody
We tested the grouping grid with our key users and they all liked it very much!!!
But...
In our 'real' world we drill down over 3-4 grouping levels and still find several hundreds of records.
(For example: SAP time feedback for bigger SAP projekts)
Our users wanted the typical SQL group informations (sum(time), count(feedbacks) goup by... )
Then they would only open(drill down) nodes with large, small, unusual values. Most of the time they will be satisfied with the summary informations on node levels and will not look at singel records.
So if it would be possible to mark some columns with wanted aggregation functions (sum or count) you
could expand your group by querys with these funktions?
And then we have a powerfull analysis tool :-)
(and not a drill down that leads to 500 records with individual informations)

Best regards
Albert

I´m extending a form with a dataGrid with three columns.

In the form extended, I add a new columns in the first position.

The new column hides the first column of the principal form and add an empty column.
But if I move the new column to the last position It show the four columns with its data.

I don´t Know if it´s a bug or if I must to put in the principal form all the columns and in the onLoad event put visible that column

Servoy 2020.3.0

Is it possible to have the path to the selected record saved in columnState?, so if the user expands on groups to find a record, they can return to the same record and selection on refresh of the grid.