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.
var filtervalue = getComponentByItemId('xxx', win).getForm().findField('filterName').getValue(); var strWhere = " ..."; store.baseParams.addSqlWhereClause = strWhere;