How to group records in Servoy table view or list view ?

[ashutoslenka426]

Hi All ,

Is it possible to group records in Servoy table view or list view depending on a table field ? . I want to show some line kind of stuff under each group. Is it Possible ? . Please share your suggestion on this .

[paronne]

Hi, for which type of Servoy client you would like to achieve this ? is for NG Client or for Smart/Web Client ?

[rodney]

Hi

I don't think this is possible in a foundset with a table view but we do this using the table bean plugin and a dataset to get a nice summary line within a table. Table bean is smart client only

screenshot.png (13.46 KiB) Viewed 3696 times

[Bernd.N]

I think it is possible when you add two new fields to the table itself like
sequence (INT)
row_type (CHAR 1) -> G = Group Row, null = Normal Row
Then you can create and show a group line with the information you need, and use a special sort order to put the group row below the normal rows.

The group line could be shown in another color with an onRenderLine() function on each field.

In case you do not want that group line in the original table, you could create a temporary SELECT as you like and need, together with a UNION that adds the group lines, and convert that to a foundset and show it in the table form.

We used this approach to create a report of Top-Five-Sales-of-a-period for each branch of a customer, which had some additional lines below the top-5-lines, not only a summary. Then we just printed everything in the order we needed. Worked quite well with this approach.

[Peter de Groot]

Hi,

Why don't you the solutionModel to create the list/table, I did something similar

2016-05-31_0833.png (21 KiB) Viewed 3578 times

Regards

[patrick]

The table bean really shouldn't be used anymore. It's smart client only and there is no need for it anymore since the introduction of the solutionModel. I have written a replacement for the bean in JavaScript that is available here: https://github.com/Servoy/svyUtils. It's the svyUtils$tableGrid module. That is based on the solutionModel and will work in any client.