06.03.2024
12:19
Hi!
So I have this Item List in "Orders app". Lets say it has 10 columns. 6 Of those columns can be editable depending on subprocesses or other proceses. So there is a query, that if returns 1 it means that column can be edited by a user, if 0 then the column in this row is blocked.
For that I am using "Column edit restrictions" from the "Permissions" tab in the studio.
And it works great. For few rows. If there are more rows it works really slow. I made some analitics. The query is executed in 20-180 ms depending on many things. So lets say it is 50 ms.
For 6 columns it means it is executed 6 times, so it takes 300 ms. For 10 rows it is 3 seconds. And of course orders can have many more rows.
So I came up with an idea. I made technical Data Row column. It returns 1 if the columns should be editable in current row and 0 if not. It's just a copy of an above query.
Then I changed "Column edit restrictions" to just check this Data Row Column and block column depending on technical row.
That was great, 6x faster form loading.
And that all worked in Webcon BPS 2022. In BPS 2023 it is not working.
I beleave there was a change in the order of Data Row column of Item List execution. I think Data Rows queries are now executed at last, after it checks if columns should be blocked.
How can I achieve this in BPS2023?
