Disable row selection in editable grid

Question

Hi, 
 I have created an editable grid using entity backed record.Is there any way to disable the row if that particular row is being worked on by some other user i.e. if a user has already selected first row and another user opens that record view it should't allow him to select the first row. 
 Thanks, Nitesh

Smruti Swain · Accepted Answer

Hi Nitesh, Disabling a particular row in the gird level is not feasible however if your use case is something like on selection of a particular row from the record view, you kick off a process, then you can try the solution with the help of an extra column to hold whether the row is being worked upon as posted by my other friend no the above post. 
 Or try another approach is to have optimistic locking on the CDT by adding @version jpa annotation if you simply dealing with Database updates. Thanks

Mike Schmitt · Answer

Are you referring to an editable grid on a SAIL form, or just a grid-style Record Type listing? 
 
If it's an editable grid (i.e. a!gridLayout) on a SAIL form, you can disable individual rows as long as you have the information to go on for this. The scenario I'm thinking of would require the main database table you're looking at to have an additional field i.e. "isInUse", and when user A starts working on a particular row (via an action or related action), you could set the "isInUse" flag to TRUE for that record, and be sure to set it back to FALSE when that user is finished. Then when user B accesses the editable grid, the rows that have TRUE for "isInUse" can be set to have their selection boxes disabled individually.

Disable row selection in editable grid

Top Replies