TWebDataGrid bug and questions

WEB TMS WEB Core
1

I really appreciate the introduction of the TWebDataGrid component in Tms Web Core; in fact the lack of a "native" Javascript grid with advanced features is felt, clearly excluding TwebDBgrid (very limited and slow).
In the porting of VCL applications that use advanced grids (TMS, Devexpress, Infopower) you are faced with difficulties that are hard to solve.
The adoption of Ag-Grid via TWebDataGrid seems to give hope, with its advanced features and high speed.
First Point: a complete and direct adapter for datasets is missing (TWebClientDataset, TWebXdatadataset, etc). I think it is extremely necessary because it is immediate, and considering that TJsArray is used by both (Dataset and Grid) I assume it is not complicated to add to the components, also performing the synchronization of the modified/inserted/deleted data in the grid.

Second point: if I use TDGCustomDataAdapter (the only one that works in a generic way), it is no longer possible to perform sort and filter. Is there some bug in the adapter?

Third point: expandability.

  1. We need to use the edit filter to perform "remote queries" and not to filter data locally. Is there a solution?

  2. The edit filter uses "Contains" to filter data. How is it possible to set "Start with" or "Equal" by default via code in columns?

  3. Is it possible to perform groupings and totals in the distributed version?

4 and last) In the case of advanced features, present only in the "professional" version of Ag-grid, is it possible to use this latest version in the component?

Thanks and good work

2

In TWebDataGrid, if I set the event OnCellFocusedEvent, we have a runtime error in Javascript: "FMessage::Unknown property: "OnCellFocusedEvent" FHelpContext::0 FJSError::Error: Unknown property: "OnCellFocusedEvent"
(I was trying to set an event to get an AfterScroll with the arrow keys).
Please test.
Thanks

3

We traced & solved this issue. The next update will address this.

4

Ok, very well.
But I don't find an event that fire when user scroll the grid (with arrow keys), so I want to change the current row. There is only when select with mouse click.
(i need it for select current record in a "parallel" dataset)
Thanks

5

There is an event OnRowSelected, did you try this meanwhile?

6

Hi,
OnRowSelected and OnSelectionChange are activated ONLY by a mouse click on the row.
They are not fired by the arrow keys or PgUp/PgDn.

7

OK, we'll need to investigate what interfaces the AgGrid offers for catching keyboard invoked changes.

8

And seems that OnRowSelected is fired twice, when mouse click...