Filtering a Data Provider on a Relationship _id does not work

[LukiWasTaken]

Checklist

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

Hosting

• Cloud (Newest Budibase Version - 3.10.5)

Describe the bug
When using the given field RelationshipName.ID - Equals - (_id of a row or a comparable binding) I get 0 rows returned when there should be 1 or multiple valid rows.

To Reproduce
Steps to reproduce the behavior:

1. Create a new App with 2 internal BB-DB tables with some simple Text Fields in both of them
2. Create a 1 to many relationship field between the 2 tables
3. Add a Data Provider to a screen fetching data from the "many"-part of the 2 tables
4. Add a filter on the relationship fields row_id (e.g. screenshot)

Expected behavior
All rows that have a relationship with that one row should be returned.

Screenshots

The _id I'm using is a valid row_id with multiple relationships set.

App Export
If possible - please attach an export of your budibase application for debugging/reproduction purposes.

Desktop (please complete the following information):

• OS: Win11
• Browser: Chrome

Testmatrix-export-1747133338059.tar.gz

[linear[bot]]

BUDI-9325 Filtering a Data Provider on a Relationship _id does not work

[mikesealey]

Hey @LukiWasTaken - Thanks for providing your app-export.

There's some fine details here that think have been missed.

Looking at your app, you're trying to filter a data provider on bereich.ID, where bereich.ID equals ro_ta_cee48524194048[....]

But looking at your table bereich, bereich.ID equals 1

The issue stems from _id and ID being used interchangeably. bereich.ID is an AutoColumn that you've added, which is effectively a serial primary key, whereas every Budibase table regardless of the use of an AutoColumn ID, has a more complex _id which is what you've used in the filter.

Replacing the _id you've passed into the filter with 1 should resolve your issue. You should also be sure to prove a label and value column to your Multi-select picker, to ensure that values populate in the dropdown. The label is the human readable text-string, and the value is what would be used if you were to do some work with this field (for example, selecting an item by name, but using the value for a price calculation). However you choose to set them is up to you, but without them you're likely to encounter more issues.

In Summary - bereich.ID equals 1 returns one row to your Data Provider, for the options picker.