I would like to share a weird behavior occurring with a group by view.
In some cases (I didnt manage to understand exactly when), some groups are separated in two (sometimes more) parts as shown in the following screen in which the group of the items having both Team and EGQ tags is divided into two parts (one with 5 items and the other one with 2 items). The overall count is fine (7 for both).
Hi @asan, I suspect that this actually a bug. Would you be able to give us more insights into your data? We would need to be able to reproduce the scenario to figure out what’s going wrong specifically?
Hi!
How can I help? What insight would you need?
I created a fake table and I can’t reproduce that behavior.
Howver, exploring what’s happening on my actual table, I realized that it could come from the filter (and not from the group by) because when I filter on my field, I get this result:
I’m not really sure why this is happening based on the screenshot. Would you be able to share the view in Baserow publicly, and share that with me? It can also be shared privately. Then I can take a look at the raw data. Thanks!
Hi,
Yes, we still have this problem on our self-hosted Baserow. We are still in 1.23.2, do you know in which release you have fixed this bug?
Thanks,
asan
Hi,
We have just upgraded our self-hosted Baserow to version 1.27.2 but still have this problem. The same problem still occurs if I create a new field on which applying the Group By. I also face weird behaviors (rows moving up and down) when I change the value of both the Group By field of others. @bram I have shared some data, did you find anything?
Thanks,
asan
Hey @asan, in that case I don’t think it has recently been resolved. I suspect that there is a difference between the backend and web-frontend sort of the multiple select field. Do you have a way of reproducing this problem? Ideally steps like: create a table, create a multiple select field, create 10 rows, set the following data, and apply a sort/group, or something like that. If we can reproduce it, then we should be able to fix it relatively easy.
I’ve tried to reproduce it but I could not find a way: if I duplicate the table, the Group By works well, if I create a new table from scratch, the Group By works well.
I did export the table as a .csv but there is no weird value…
When I create a new field to apply the Group By with same values, rows are moving when I add the value: for instance, the row 5153 was in the first block Team and EGQ but when I added the values on the Test field the row moved in a new block (the third one) with tag Team and EGQ whereas I did not change the value of the field on which the Group By is applied. Howerver, when I refresh the page, it gets back to the two initial blocks.
I tried to find a way to bypass this issue only manipulating the existing table but I could not. The solution of creating a new table would work but it would mean to have a new link which is hard to manage because it is used in many different ways (short links, n8n automations, etc.).
Hey @asan, in the 1.29 release today, we’ve released improved sorting abilities for the single and multiple select field. This can be directly related to the problem you had. Would you mind testing if you still have the problem?
