Documentation

Business component: Adding a where clause to a business component linked to grid

In case an additional where clause must be appended to the base filtering conditions defined in a business component linked to a grid,  a client side js action can be defined and linked to the grid (e.g. linked to a “before load” event).

The addSqlWhereClause property can be used for that purpose.

Example:
var filtervalue = getComponentByItemId('xxx', win).getForm().findField('filterName').getValue();
 
var strWhere = " ...";
 
store.baseParams.addSqlWhereClause = strWhere;