[BUDI-7239] Cannot filter by relationship on new SQL datasource

[melohagan]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method: docker single image
  • Budibase Version: 2.6.1 (Introduced, fine on 2.5.9)

Describe the bug
If you create a new SQL datasource after updating to 2.6+ then you can no longer filter by a relationship field in a Table block.

To Reproduce
Steps to reproduce the behavior:

1. Update to 2.6+
2. Create a new MySQL datasource
3. Within a data table, define a new One->Many relationship
4. Go to Design and add a Table block to a screen for the 'One' table
5. Define filters.
6. See that there are no relationship fields to pick!

Expected behavior
As a user, I should be able to filter my SQL tables by relationship in the Design section.

Screenshots
Employees with one->many relationship to salaries:

Table block filter - where are the salaries fields?

_{From SyncLinear.com | BUDI-7239}

[aptkingston]

Had a look into this. Good news is that it's fixed (and permanently fixed) by refreshing your page. This only happens immediately after defining a new relationship. Leaving your app or refreshing your page will fix this. The problem is just that after defining a relationship, we do not immediately update the table schema state, which is used by the filter setting.

I'll downgrade this as it's nowhere near as bad as it first seemed thankfully.

[melohagan]

Brilliant @aptkingston Thanks very much for taking a look - glad to hear it. Explains why it hadn't been flagged up to this point. Have a great weekend!