Ticket #29969
Question
I had row level security working and after adding a record selection to the row security retrieval, the security has stopped and it's showing all records.
Answer
Informed customer the row level security template will not include additional where clauses when being used in another application. Therefore, the solution is to create an SQL view that filters the security data values you wish. Then, register said view to m-Power and build your row security retrieval over the view. This should give you the results you're looking for.
Asked on January 30, 2020