Row level security is not working for me

Support
#1

The row level security was working fine but after i upgraded to v 2.5.1 I noticed that it is not working. I have downgraded to 2.5.0 but still not working.

Here is the row level role defined which is assigned to a user.
image

Here is what i see i.e. all the Operating location instead of only one that is filtered.

image

Here is teh code loading Operating location in Attend Log Manual detail screen:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<view xmlns="http://jmix.io/schema/flowui/view"
      title="msg://attendLogManualDetailView.title"
      focusComponent="form">
    <data>
        <collection class="com.inteacc.mdg.entity.gen.OperatingLocation" id="mdg_OperatingLocationsDc"
                    fetchPlan="_instance_name">
            <loader id="mdg_OperatingLocationsDl" readOnly="true">
                <query>
                    <![CDATA[select e from mdg_OperatingLocation e
                    join e.operatingLocationCo o
                    where o.company = :container_mdg_CompaniesDc]]>
                </query>
            </loader>
        </collection>
        <collection class="com.inteacc.mdg.entity.gen.Company" id="mdg_CompaniesDc" fetchPlan="_instance_name">
            <loader id="mdg_CompaniesDl" readOnly="true">
                <query>
                    <![CDATA[select e from mdg_Company e]]>
                </query>
            </loader>
        </collection>

Since the row level role defined to have access to the operating location which is only existing in the employee profile isn’t supposed to load only one entity in Operating location?

#3

Hi,

I want to clarify - before upgrade to 2.5.1 it works fine on 2.5.0 (but doesn’t work after you reverted the version)? Or initially it was some older version?

Are you able to provide some reproducable sample project?

Regards,
Ivan