Filter data on current user

Answered

Donatas Krukauskas

• September 08, 2023 11:02

Hello,

I have a custom (and simple) webapp that lists contents of one table. A user can add/delete a row.

Is there a way to display only the rows that the user has added? I have column boaUserID, and would like to show only the rows that match current username. What would be the best way to approach this? Thank you in advance!

0

• Best answer

  

  PSA Support

  • September 08, 2023 13:29

  Hi Donatas, 

  If you add boaUserID to the Horizontal view for the page, the application will automatically filter for that user. If you have added the ChangedBy field on your table, you can add it your Horizonal view and alias it as boaUserID. That will then automatically filter the page for the rows that the user has added or changed (note: ChangedBy only captures the last change, it does not keep an archived history). 

  1
• 

  Donatas Krukauskas

  • September 11, 2023 19:00

  This is amazing, and it works!

  Thank you!

  0

Please sign in to leave a comment.