Order doesn't seem to be working in a table in App Builder

Baserow Help
,
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I have a strange one that I know must be an oversight on my behalf, but I can’t find out what I’m doing wrong.

I have a data source in the app builder: “List Multiple Rows” and it is sorted by a field “Customer” in alphabetical order (no view selected). However, when I create a table using that data source, the rows are not sorted in alphabetical order.

Even stranger, if I add a user action to sort by “Customer” and then sort it in the front end, it works fine. So I know it can be sorted by Customer. What am I missing here?

Thanks in advance for any point in the right direction.

2

Hi @spook!

There are four ways of sorting records in your list rows data source:

  • A data source with no view selected and data source sorting: you can apply a sorting to this specific data source set.
  • A data source with a view selected and no data source sorting: the rows will be sorted by what has been set up in the database module’s sorting.
  • A data source with a view selected and with data source sorting: the rows are sorted by the database module’s sorting, then the data source’s sorting replaces it.
  • Finally, the external user sorting is available for the fields you selected in “User actions”. These sorts aren’t persisted and just applied on the fly.

With that in mind:

I have a data source in the app builder: “List Multiple Rows” and it is sorted by a field “Customer” in alphabetical order (no view selected). However, when I create a table using that data source, the rows are not sorted in alphabetical order.

When you say it’s sorted by a field, with no view selected: you mean a data source sort has been applied, right? That would be scenario (1) in my bulletpoints above.

I tried this on baserow.io, and it looks okay to me. Is it possible you’re not clicking “Save” after selecting a sort in the data source modal?

Even stranger, if I add a user action to sort by “Customer” and then sort it in the front end, it works fine. So I know it can be sorted by Customer. What am I missing here?

This would be (4) in my list above - it’s an external user sort, applied on the fly and not persisted.

To debug this further, since you’re probably trying scenario 1, would you mind sharing a screenshot of your data source modal with the sort applied?

Additionally, just in case, as you’re a self-hoster, your version number would be great.

Cheers,

Peter Evans

3

Thanks so much for the feedback. Your assumption is correct. I’m doing scenario 1 and it doesn’t seem to be working, yet scenario 4 does.

Here is a screenshot of my Data source:

image
image680×478 20.9 KB

Here is the table after the above sort has been applied. I’ve blurred most if it, but you can see the Customer is not sorted in alphabetical order:

image
image619×716 79.8 KB

However, on the front end, if I sort by company name, it works:

image
image745×620 70.8 KB

I can’t work out why one is working, but not the other.

4

Thank you @spook!

What kind of field type is “Customers”? I’ll try to replicate the scenario today and get back to you.

Cheers,

Peter Evans

5

It’s a link to another table. Could this be why?

BTW I am self-hosted on the latest version