Home > Forum > General > Row blocking in item list

Row blocking in item list
0

I'm following this article https://community.webcon.com/posts/post/approval-process-on-the-item-list-with-row-blocking/138 in order to block rows. I've managed to give access to items list only users mentioned in one of the columns of item list using SQL against BPS Users list (see picture attached) , but all rows are available to everyone from this column, not only one row per one user.
What am I doing wrong?

MVP

Hi Przemysław,

let's say the filter is executed for each row of the list, and allows edit if the current user was returned by the query/source.
If you choosed bps users as the source, problably your sql query is not executed at all, and edit will be allowed for all users who are returned by the 'All BPS Users' data source.
I think that you can use the option 'dynamically' in your case, but if you want to use sql query, return the value from the current row of item list, not all values from the item list column - see attachment :)