# UniqueID versus RowID **URL:** \ **Category:** Ask for Help\ **Created:** [August 3, 2022, 2:39am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829 "2022-08-03T02:39:59Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [August 3, 2022, 2:39am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/1 "2022-08-03T02:39:59Z")
I just realized that testing on the screen’s rowID to exclude itself from a collection didn’t work. I had to add a UniqueID whenever I add a row, and then could test the screen’s UniqueID against the collection’s UniqueIDs. Is this a bug, or is there a good reason why a RowID couldn’t be used as a UniqueID ? ---
**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 3, 2022, 2:53am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/2 "2022-08-03T02:53:23Z")
Are you saying that RowID is not unique? Can you demonstrate this? ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [August 3, 2022, 8:30am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/3 "2022-08-03T08:30:10Z")
No, that’s just fine…. Basically, I have a database of comments from users. When I select a detail screen of a comment, I create a relation where the email of the user relates to the whole database, to get a list of all comments from that user, which I then display in a collection based on the relation. I then wanted to show all comments except the one from the detail screen so I set up a filter in the collection, « rowID is not screen-\>rowID » but it doesn’t work as it filters out everything in the collection (as if every rowID was the same, which is definitely not the case) 😉. I also tried to create the collection from the whole comments database and then filtering out « user is screen-\>user and rowID is not screen-\>rowID », but same problem. So I added a uniqueID at the creation of each comment and filtered « uniqueID is not screen-\>uniqueID » which works fine. Seems weird to me… ---
**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 3, 2022, 10:12am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/4 "2022-08-03T10:12:02Z")
mmm, yes. I don’t think I can explain what’s going on here, but I would like to see it for myself. Is there any chance you can make a small copyable prototype app that demonstrates the issue? ---
**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\ **Post date:** [August 3, 2022, 10:35am UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/5 "2022-08-03T10:35:05Z")
Sounds like your RowID is the users ID and not specific the CommentID? If so, filtering comments on UserID will remove all of those Users comments. ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [August 3, 2022, 1:46pm UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/7 "2022-08-03T13:46:28Z")
Yup, to my defense, it was late… 😉 ---
**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:** [August 4, 2022, 1:47pm UTC](https://community.glideapps.com/t/uniqueid-versus-rowid/45829/8 "2022-08-04T13:47:22Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.