Query Filter on GroupDatasource dont filter

Support
#1

Hi Guys

Where did i go wrong? Anyone Thanks :slight_smile:

package com.company.sqlcrud.web.customer;

import com.haulmont.bali.util.ParamsMap;
import com.haulmont.cuba.core.global.UserSessionSource;
import com.haulmont.cuba.gui.components.EntityCombinedScreen;
import com.company.sqlcrud.entity.Customer;
import com.haulmont.cuba.gui.data.GroupDatasource;

import javax.inject.Inject;
import java.util.UUID;

public class CustomerBrowse extends EntityCombinedScreen {

@Inject
private UserSessionSource userSessionSource;

@Inject
private GroupDatasource<Customer, UUID> customersDs;

public void Init(){
    customersDs.setQuery("select e from sqlcrud$Customer e WHERE e.deletedBy is NULL AND e.createdBy =" + userSessionSource.getUserSession().getUser().getLogin());
    customersDs.refresh();
}

}

#2

Problem solved!!!

> <groupDatasource id="customersDs"
>                          class="com.company.sqlcrud.entity.Customer"
>                          view="customer-order-view">
>             <query>
>                 <![CDATA[select e from sqlcrud$Customer e where e.createdBy = :session$userLogin]]>
>             </query>
>         </groupDatasource>

:sweat_smile::sweat_smile::sweat_smile:

#3

Best solution is using access groups LOL.

https://doc.cuba-platform.com/manual-6.1/constraints.html