Hi,

I found a javascript function, selectWhere(), in Infragistics help. I want filter the factory that user can choose according to their user id.

function dgdResult_AfterEnterEditModeHandler(gridName, cellId){    
    var cell = igtbl_getCellById(cellId);
    
    if (cell.Column.Key == "FACTORY_NAME") {
     var comboName = "cboFactory";
     var combo = igcmbo_getComboById(comboName);
          
     if (combo) {
        var cell_user_id = cell.Row.getCellFromKey("USER_ID");
        if (cell_user_id) {
               combo.selectWhere("COUNTRY_CODE IN (select country_code from user_country where user_id = '" + cell_user_id.getValue() + "')");
       }
     }
    }
   }

 But I found that it has no effect. In selectWhere(), I can only use simple condition like selectWhere("COUNTRY_CODE IN ('HK', 'JP')")

Is it the restriction of this function or did I do something wrong in the code?

My infragistics version is 6.2.20062.34 and I opened load-on-demand in webcombo.