# Issue with filtering related rows using RowID

**URL:** <https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008>\
**Category:** Ask for Help\
**Created:** [August 25, 2025, 12:01pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008 "2025-08-25T12:01:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vinne](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vinne/32/91429_2.png) [@Vinne](https://community.glideapps.com/u/Vinne)\
**Post date:** [August 25, 2025, 12:01pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/1 "2025-08-25T12:01:51Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 25, 2025, 12:51pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/2 "2025-08-25T12:51:56Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Vinne](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vinne/32/91429_2.png) [@Vinne](https://community.glideapps.com/u/Vinne)\
**Post date:** [August 25, 2025, 1:09pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/3 "2025-08-25T13:09:21Z")

</div>

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**.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 25, 2025, 1:17pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/4 "2025-08-25T13:17:38Z")

</div>

> [@Vinne](#):
>
> If I set the collection source to use the relation instead of filtering, I only get the filter options **is empty / is not empty**.

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

---

<div class="post-metadata">

**Author:** ![Vinne](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vinne/32/91429_2.png) [@Vinne](https://community.glideapps.com/u/Vinne)\
**Post date:** [August 25, 2025, 4:25pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/5 "2025-08-25T16:25:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 1, 2025, 4:25pm UTC](https://community.glideapps.com/t/issue-with-filtering-related-rows-using-rowid/84008/6 "2025-09-01T16:25:57Z")

</div>

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