Java connector with grid filtering

Suite and Optimus Suite 5
#1

I have the filter enabled for the connector and this the url requested, nothing extra should be needed server side right?

But the log shows it is not doing any WHERE

connector=true&filter=4&col0=Dont&col1=&col2=&col3=

#2

a) you need to have connector.js included on the page
b) filter must be from connector family

#connector_text_filter
#connector_select_filter

#3

I have both of those but the connector acts like it doesnt see any of the filter options and doesnt include any WHERE. Do you have to have a beforeFilter for it to work?

#4

Can you provide html page with used init code ? ( or demo link , if you have any )

#5

The grid columns also refresh each time, but I am sure it is the same issue.


<script>window.dhx_globalImgPath="/imgs/"; </script>
<link rel="STYLESHEET" type="text/css" href="/dhtmlxLayout/codebase/dhtmlxlayout.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxLayout/codebase/skins/dhtmlxlayout_dhx_web.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxGrid/codebase/skins/dhtmlxgrid_dhx_web.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxGrid/codebase/dhtmlxgrid_skins.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxGrid/codebase/dhtmlxgrid.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxForm/codebase/skins/dhtmlxform_dhx_web.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxToolbar/codebase/skins/dhtmlxtoolbar_dhx_web.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxWindows/codebase/dhtmlxwindows.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxWindows/codebase/skins/dhtmlxwindows_dhx_web.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxMenu/codebase/skins/dhtmlxmenu_dhx_skyblue.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlxTabbar/codebase/dhtmlxtabbar.css">
<link rel="STYLESHEET" type="text/css" href="/dhtmlx_custom.css">

<script language="JavaScript" src="/dhtmlxcommon.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxLayout/codebase/dhtmlxlayout.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxLayout/codebase/dhtmlxcontainer.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/dhtmlxgrid.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/dhtmlxgridcell.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/excells/dhtmlxgrid_excell_link.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/ext/dhtmlxgrid_srnd.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/ext/dhtmlxgrid_rowselector.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxGrid/codebase/ext/dhtmlxgrid_filter.js" type="text/javascript"></script>
<!--<script language="JavaScript" src="/dhtmlxGrid/codebase/ext/dhtmlxgrid_deprecated.js" type="text/javascript"></script>-->
<script language="JavaScript" src="/dhtmlxForm/codebase/dhtmlxform.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxToolbar/codebase/dhtmlxtoolbar.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxWindows/codebase/dhtmlxwindows.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxMenu/codebase/dhtmlxmenu.js" type="text/javascript"></script>
<script language="JavaScript" src="/dhtmlxTabbar/codebase/dhtmlxtabbar.js" type="text/javascript"></script>
<script src="/connector.js"></script>


grid = a.attachGrid();
grid.setSkin('dhx_web');
grid.attachEvent("onrowselect", function(id){
form_cust.load("Center?req=cust_form&seq="+id);
});
menu1 = new dhtmlXMenuObject();
menu1.renderAsContextMenu(true);
menu1.setSkin("dhx_web");
menu1.loadXMLString('<menu id="0"><item text="Print Equipment"  id="print_equip"/></menu>');
grid.enableContextMenu(menu1);        
grid.init();                  
grid.enableSmartRendering(true);
grid.load("Center?req=cust_list");

[code]

GridConnector data = new GridConnector(conn);
data.servlet(request, response);
data.dynamic_loading(100);
GridConfiguration config = new GridConfiguration();
GridColumn column1 = new GridColumn();
column1.setHeader(“Header 1”);
column1.setWidth(150);
column1.setSort(“connector”);
config.addColumn(column1);
GridColumn column2 = new GridColumn();
column2.setHeader(“Header 1”);
column2.setWidth(75);
column2.setSort(“connector”);
config.addColumn(column2);
GridColumn column3 = new GridColumn();
column3.setHeader(“Header 1”);
column3.setWidth(210);
column3.setSort(“connector”);
config.addColumn(column3);
GridColumn column4 = new GridColumn();
column4.setHeader(“Header 1”);
column4.setWidth(100);
column4.setSort(“connector”);
config.addColumn(column4);
GridColumn column5 = new GridColumn();
column5.setHidden(true);
config.addColumn(column5);

String[] labels ={"#connector_text_filter","#connector_text_filter","#connector_text_filter","#connector_text_filter"};
config.addHeader(labels);

data.setConfiguration(config);
class SortingBehavior extends ConnectorBehavior{
@Override
public void beforeSort(ArrayList sorters){
sorters.add(new SortingRule(“COLUMN1”,“ASC”));
}
}
data.event.attach(new SortingBehavior());
data.render_table(“CUSTOMER”,“SEQ”,“COLUMN1,COLLUMN2,COLUMN3,COLUMN4,COLUMN5”);[/code]

#6

just to be sure - try to update connector.js with latest one ( attached )
connector.zip (1.52 KB)

#7

That fixed it thanks.