Issue with filtering related rows using RowID

Ask for Help
1

Hello,

I have a problem when editing an object (a row from the “Faktury” table).
In this table, I have a RowID column.
In the second table (“Pozycje Faktur”), I have a column RowID_Faktury where I store the invoice ID.

I would like to display only those items where RowID_Faktury matches the RowID of the current invoice. Unfortunately, the filter I set with the condition RowID_Faktury = screen>RowID does not work – no results are displayed.

Could you please advise me on how to properly configure the filtering/relationship in this case?

1 Like
2

I assume the ID matches exactly in both tables?
Do you have row owners applied to any columns in the Pozycje Faktur table? If you create a relation in your Faktury table, does it show matches, and if so what happens when you change your collection source to use the relation instead of filtering?

2 Likes
3

Yes, the IDs are 100% correct.
I don’t have any row owners applied.
Yes, after creating a relation in the Faktury table, I can see matches from the PozycjeFaktur table.
If I set the collection source to use the relation instead of filtering, I only get the filter options is empty / is not empty.

1 Like
4

Sounds like you are trying to use the relation as a filter, rather than using it as the source of the collection.

4 Likes
5

Great, now it works. I’m really grateful.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.