Hello.
We have evulation version of dhtmlxGrid professional, but I can’t get search or filter working.
I try to insert #numeric_filter and #text_search into header but i see #text_search instead of form. What am I doing wrong? PLS help me. :’(
HTML
You have to include dhtmlx_filter.js file
Where this file is located?
correct name is codebase/ext/dhtmlxgrid_filter.js
if you are using compiled dhtmlx.js - it is already included.
It only search for first row of grid.
Please have a look for my code
JSP page
| To find a <%=request.getParameter("treeName")%>, type the number or description. To find next, press Enter or click Find Next. To find previous, click Find Prev Find Next | Find Prev | ||
var tree;
var tree1;
var flag=0;
function findItemNow(event) {
var regEx = new RegExp("[-a-zA-Z0-9_\/]");
var txt = document.getElementById(“stext”).value;
// alert(‘inside functiion’);
if (event.keyCode == 13) {
var breakstat = false;
var totRows = tree1.getAllRowIds().split(",");
for (var i = 0; i < totRows.length; i++ ){
// alert(tree.cells(totRows[i],0).getValue());
var idTxt = tree.cells(totRows[i],0).getValue();
// alert(idTxt.split(txt).length);
if (idTxt.split(txt).length -1 >0){
// alert(totRows[i]);
tree.selectRowById(totRows[i]);
breakstat = true;
}
if(breakstat){
break;
}
}
}
}
function setupTree() {
document.getElementById('gridbox').innerHTML = "";
<%if(request.getParameter("treeType")!=null) {
if(request.getSession(false)!=null){
session.invalidate();
}
session = request.getSession(true);
%>
var url = "<%=request.getParameter("treeType")%>";
if(url.indexOf(".xml") < 0)
url = url + ".xml";
setupViewTree(url);
//getRowTest();
<%}%>
}
function setupViewTree(url) {
//to Load Business unit and finance Manager
/* tree1 = new dhtmlXGridObject('gridbox1');
tree1.setImagePath("dhtmlx/dhtmlxGrid/codebase/imgs/icons_greenfolders/");
tree1.setHeader("Business unit, Finance Manager");
tree.attachHeader("#text_search,#text_search");
tree1.setInitWidths("*,*");
tree1.setColAlign("left,left");
tree1.setColTypes("ed,ed");
tree1.enableAutoHeight(false);
tree1.enableAutoWidth(true);
tree1.setColSorting("str, str");
tree1.init();
tree1.setSkin("dhx_skyblue");
tree1.enableSmartXMLParsing(true);
tree1.enableDistributedParsing(true);
tree1.loadXML("COST_CENTER1.xml",getRowTest);
*/
//to load dhtmlx Tree cost center hierarchy
tree = new dhtmlXGridObject('gridbox');
tree.setImagePath("dhtmlx/dhtmlxGrid/codebase/imgs/csh_bluebooks/");
tree.setHeader("Cost Center Hierarchy, Business Unit, Finance Manager");
tree.attachHeader("#text_search,#text_search,#text_search");
tree.setInitWidths("350,450,450");
tree.setColAlign("left,left,left");
tree.setColTypes("tree,ed,ed");
tree.enableAutoHeight(false);
tree.enableAutoWidth(false);
tree.setColSorting("str,str,str");
tree.init();
tree.setSkin("dhx_skyblue");
tree.enableSmartXMLParsing(true);
tree.enableTreeGridLines(true);
tree.setEditable(true);
tree.attachEvent("onEditCell", doOnCellEdit);
// tree.attachEvent("onRowDblClicked", onRowDblClicked);
tree.loadXML("COST_CENTER.xml");
}
function onRowDblClicked(){
alert('hi user double clicked the event');
}
function doOnCellEdit(stage, rowId, cellInd) {
// stop user from modifying the first column
if(cellInd == 0){
// alert('u cant edit the cell');
return false;
}else{
return true;
}
}
/* tree.attachEvent("onOpenEnd",function(nodeId, event){
//alert("hi"+ nodeId + " " + event);
//alert(tree.getSubItems(nodeId));
if(event == 1){ // Expand event
var subItems = tree.getSubItems(nodeId).split(",");
for(var i =0; i <= subItems.length; i++){
tree1.setRowHidden(subItems[i], false);
}
}else if(event == -1){ // Collapse event
var subItems = tree.getSubItems(nodeId).split(",");
for(var i =0; i <= subItems.length; i++){
tree1.setRowHidden(subItems[i], true);
}
} //else part ends here
} // function body ends here
); // event ends here
*/
//to hide all rows from tree1
/*function getRowTest(){
var allrows = tree1.getAllRowIds().split(",");
//alert(allrows.length);
for(var i =0; i <= allrows.length; i++){
if(i != 0){
tree1.setRowHidden(allrows[i], true);
}
}
} */
//to hide only selected row data from the
/*function getRowID(){
if(tree.getSelectedId() != null){
//alert(tree.getSelectedCellIndex());
//alert(tree.getSelectedId());
//alert(tree.cells(tree.getSelectedId(),tree.getSelectedCellIndex()).getValue());
//alert(tree.cells(tree.getSelectedId(),0).getValue());
//alert(tree.cells(tree.getSelectedId(),1).getValue()); //moved to other tree
//alert(tree.getOpenState(tree.getSelectedId()));
//alert(tree.hasChildren(tree.getSelectedId()));
//alert(tree.getSubItems(tree.getSelectedId()));
var subItems = tree.getSubItems(tree.getSelectedId()).split(",");
for(var i =0; i <= subItems.length; i++){
// alert(subItems[i]);
tree1.setRowHidden(subItems[i], false);
}
}
} */
function setCopyToClipBoard()
{
if(tree.getSelectedId() != null){
if(!tree.hasChildren(tree.getSelectedId())){
alert(tree.cells(tree.getSelectedId(),0).getValue());
//alert(tree1.cells(tree.getSelectedId(),0).getValue());
//alert(tree1.cells(tree.getSelectedId(),1).getValue());
//window.clipboardData.setData('text',tree.getSelectedItemText() + "-&**JPM**COST**CENTER**TREE**&");
//self.close();
}
else{
alert("'S' level nodes cannot be selected. Please select a Cost Center.");
}
}
}
</script>
<script type="text/javascript">
setupTree();
</script>
XML file
S570307-MORTGAGE PRODUCTION AND SERVICING
MORTGAGE PRODUCTION AND SERVICING
MARIE L FISHER
S570315-LOAN SERVICING & DEFAULT
LOAN SERVICING & DEFAULT
MARIE L FISHER
S520298-TOTAL SERVICING SUMMARY
TOTAL SERVICING SUMMARY
MARIE L FISHER
S521065-CORE SERVICING - DOJ/AG (DEPT OF JUSTICE/ATRNY GEN)
CORE SERVICING - DOJ/AG (DEPT OF JUSTICE/ATRNY GEN)
MARIE L FISHER
101678-DOCUMENT SERVICES - DOJ/AG
CORE SERVICING
11249-DOCUMENT SERVICES - DOJ/AG
115265-STRATEGY PGM MGMT - DOJ/AG
119495-SPECIAL LOANS, ASSUMPTIONS OPT PROD - DOJ/AG
469721-GENERAL ADMIN - DOJ/AG
469723-CUSTOMER CARE - DOJ/AG
735298-FINANCIAL SERVICES - DOJ/AG
736192-INVESTOR SERVICES - DOJ/AG
739942-LOAN ADMINISTRATION - DOJ/AG
S532390-CORE SERVICING - FORECLOSURE LOOKBACK
CORE SERVICING - FORECLOSURE LOOKBACK
MARIE L FISHER
115264-CUSTOMER CARE - FORECLOSURE LOOKBACK
122945-DOCUMENT SERVICES - FORECLOSURE LOOKBACK
124521-SPECIAL LOANS, ASSUMPTIONS OPT PROD - FORECLOSURE LOOKBACK
132868-LOAN ADMINISTRATION - FORECLOSURE LOOKBACK
132891-INVESTOR SERVICES - FORECLOSURE LOOKBACK
19617-SERVICING ADMIN - FORECLOSURE LOOKBACK
466151-STRATEGY PROGRAM MGMT - FORECLOSURE LOOKBACK
469296-FINANCIAL SERVICES - FORECLOSURE LOOKBACK
469739-CHANGE MGMT - FORECLOSURE LOOKBACK
633137-SERVICING ADMIN - FORECLOSURE LOOKBACK
633731-STRATEGY PROGRAM MGMT - FORECLOSURE LOOKBACK
S574897-SERVICING ADJ CENTER
SERVICING ADJ CENTER
MARIE L FISHER
287512-HE HIST ADJ - DEDICATED SVCG
96655-SERVICING ADJ CENTER
S580914-LOAN SERVICING SUMMARY
LOAN SERVICING SUMMARY
MARIE L FISHER
S523209-LOAN ADMINISTRATION (L DEATLEY)
LOAN ADMINISTRATION (L DEATLEY)
MARIE L FISHER
S523214-SUPPORT (LEDFORD/SULLIVAN/KYLE)
SUPPORT (LEDFORD/SULLIVAN/KYLE)
MARIE L FISHER
103075-LOAN TRANSFER/DOC MG-LE-805
117011-PROJECTS 1
117012-AUTOMATION
117013-LOAN ADMIN 3
kindly provide u r response.
Thanks
It only search for first row of grid.
Please have a look for my code
JSP page
| To find a <%=request.getParameter("treeName")%>, type the number or description. To find next, press Enter or click Find Next. To find previous, click Find Prev Find Next | Find Prev | ||
var tree;
var tree1;
var flag=0;
function findItemNow(event) {
var regEx = new RegExp("[-a-zA-Z0-9_\/]");
var txt = document.getElementById(“stext”).value;
// alert(‘inside functiion’);
if (event.keyCode == 13) {
var breakstat = false;
var totRows = tree1.getAllRowIds().split(",");
for (var i = 0; i < totRows.length; i++ ){
// alert(tree.cells(totRows[i],0).getValue());
var idTxt = tree.cells(totRows[i],0).getValue();
// alert(idTxt.split(txt).length);
if (idTxt.split(txt).length -1 >0){
// alert(totRows[i]);
tree.selectRowById(totRows[i]);
breakstat = true;
}
if(breakstat){
break;
}
}
}
}
function setupTree() {
document.getElementById('gridbox').innerHTML = "";
<%if(request.getParameter("treeType")!=null) {
if(request.getSession(false)!=null){
session.invalidate();
}
session = request.getSession(true);
%>
var url = "<%=request.getParameter("treeType")%>";
if(url.indexOf(".xml") < 0)
url = url + ".xml";
setupViewTree(url);
//getRowTest();
<%}%>
}
function setupViewTree(url) {
//to Load Business unit and finance Manager
/* tree1 = new dhtmlXGridObject('gridbox1');
tree1.setImagePath("dhtmlx/dhtmlxGrid/codebase/imgs/icons_greenfolders/");
tree1.setHeader("Business unit, Finance Manager");
tree.attachHeader("#text_search,#text_search");
tree1.setInitWidths("*,*");
tree1.setColAlign("left,left");
tree1.setColTypes("ed,ed");
tree1.enableAutoHeight(false);
tree1.enableAutoWidth(true);
tree1.setColSorting("str, str");
tree1.init();
tree1.setSkin("dhx_skyblue");
tree1.enableSmartXMLParsing(true);
tree1.enableDistributedParsing(true);
tree1.loadXML("COST_CENTER1.xml",getRowTest);
*/
//to load dhtmlx Tree cost center hierarchy
tree = new dhtmlXGridObject('gridbox');
tree.setImagePath("dhtmlx/dhtmlxGrid/codebase/imgs/csh_bluebooks/");
tree.setHeader("Cost Center Hierarchy, Business Unit, Finance Manager");
tree.attachHeader("#text_search,#text_search,#text_search");
tree.setInitWidths("350,450,450");
tree.setColAlign("left,left,left");
tree.setColTypes("tree,ed,ed");
tree.enableAutoHeight(false);
tree.enableAutoWidth(false);
tree.setColSorting("str,str,str");
tree.init();
tree.setSkin("dhx_skyblue");
tree.enableSmartXMLParsing(true);
tree.enableTreeGridLines(true);
tree.setEditable(true);
tree.attachEvent("onEditCell", doOnCellEdit);
// tree.attachEvent("onRowDblClicked", onRowDblClicked);
tree.loadXML("COST_CENTER.xml");
}
function onRowDblClicked(){
alert('hi user double clicked the event');
}
function doOnCellEdit(stage, rowId, cellInd) {
// stop user from modifying the first column
if(cellInd == 0){
// alert('u cant edit the cell');
return false;
}else{
return true;
}
}
/* tree.attachEvent("onOpenEnd",function(nodeId, event){
//alert("hi"+ nodeId + " " + event);
//alert(tree.getSubItems(nodeId));
if(event == 1){ // Expand event
var subItems = tree.getSubItems(nodeId).split(",");
for(var i =0; i <= subItems.length; i++){
tree1.setRowHidden(subItems[i], false);
}
}else if(event == -1){ // Collapse event
var subItems = tree.getSubItems(nodeId).split(",");
for(var i =0; i <= subItems.length; i++){
tree1.setRowHidden(subItems[i], true);
}
} //else part ends here
} // function body ends here
); // event ends here
*/
//to hide all rows from tree1
/*function getRowTest(){
var allrows = tree1.getAllRowIds().split(",");
//alert(allrows.length);
for(var i =0; i <= allrows.length; i++){
if(i != 0){
tree1.setRowHidden(allrows[i], true);
}
}
} */
//to hide only selected row data from the
/*function getRowID(){
if(tree.getSelectedId() != null){
//alert(tree.getSelectedCellIndex());
//alert(tree.getSelectedId());
//alert(tree.cells(tree.getSelectedId(),tree.getSelectedCellIndex()).getValue());
//alert(tree.cells(tree.getSelectedId(),0).getValue());
//alert(tree.cells(tree.getSelectedId(),1).getValue()); //moved to other tree
//alert(tree.getOpenState(tree.getSelectedId()));
//alert(tree.hasChildren(tree.getSelectedId()));
//alert(tree.getSubItems(tree.getSelectedId()));
var subItems = tree.getSubItems(tree.getSelectedId()).split(",");
for(var i =0; i <= subItems.length; i++){
// alert(subItems[i]);
tree1.setRowHidden(subItems[i], false);
}
}
} */
function setCopyToClipBoard()
{
if(tree.getSelectedId() != null){
if(!tree.hasChildren(tree.getSelectedId())){
alert(tree.cells(tree.getSelectedId(),0).getValue());
//alert(tree1.cells(tree.getSelectedId(),0).getValue());
//alert(tree1.cells(tree.getSelectedId(),1).getValue());
//window.clipboardData.setData('text',tree.getSelectedItemText() + "-&**JPM**COST**CENTER**TREE**&");
//self.close();
}
else{
alert("'S' level nodes cannot be selected. Please select a Cost Center.");
}
}
}
</script>
<script type="text/javascript">
setupTree();
</script>
XML file
S570307-MORTGAGE PRODUCTION AND SERVICING
MORTGAGE PRODUCTION AND SERVICING
MARIE L FISHER
S570315-LOAN SERVICING & DEFAULT
LOAN SERVICING & DEFAULT
MARIE L FISHER
S520298-TOTAL SERVICING SUMMARY
TOTAL SERVICING SUMMARY
MARIE L FISHER
S521065-CORE SERVICING - DOJ/AG (DEPT OF JUSTICE/ATRNY GEN)
CORE SERVICING - DOJ/AG (DEPT OF JUSTICE/ATRNY GEN)
MARIE L FISHER
101678-DOCUMENT SERVICES - DOJ/AG
CORE SERVICING
11249-DOCUMENT SERVICES - DOJ/AG
115265-STRATEGY PGM MGMT - DOJ/AG
119495-SPECIAL LOANS, ASSUMPTIONS OPT PROD - DOJ/AG
469721-GENERAL ADMIN - DOJ/AG
469723-CUSTOMER CARE - DOJ/AG
735298-FINANCIAL SERVICES - DOJ/AG
736192-INVESTOR SERVICES - DOJ/AG
739942-LOAN ADMINISTRATION - DOJ/AG
S532390-CORE SERVICING - FORECLOSURE LOOKBACK
CORE SERVICING - FORECLOSURE LOOKBACK
MARIE L FISHER
115264-CUSTOMER CARE - FORECLOSURE LOOKBACK
122945-DOCUMENT SERVICES - FORECLOSURE LOOKBACK
124521-SPECIAL LOANS, ASSUMPTIONS OPT PROD - FORECLOSURE LOOKBACK
132868-LOAN ADMINISTRATION - FORECLOSURE LOOKBACK
132891-INVESTOR SERVICES - FORECLOSURE LOOKBACK
19617-SERVICING ADMIN - FORECLOSURE LOOKBACK
466151-STRATEGY PROGRAM MGMT - FORECLOSURE LOOKBACK
469296-FINANCIAL SERVICES - FORECLOSURE LOOKBACK
469739-CHANGE MGMT - FORECLOSURE LOOKBACK
633137-SERVICING ADMIN - FORECLOSURE LOOKBACK
633731-STRATEGY PROGRAM MGMT - FORECLOSURE LOOKBACK
S574897-SERVICING ADJ CENTER
SERVICING ADJ CENTER
MARIE L FISHER
287512-HE HIST ADJ - DEDICATED SVCG
96655-SERVICING ADJ CENTER
S580914-LOAN SERVICING SUMMARY
LOAN SERVICING SUMMARY
MARIE L FISHER
S523209-LOAN ADMINISTRATION (L DEATLEY)
LOAN ADMINISTRATION (L DEATLEY)
MARIE L FISHER
S523214-SUPPORT (LEDFORD/SULLIVAN/KYLE)
SUPPORT (LEDFORD/SULLIVAN/KYLE)
MARIE L FISHER
103075-LOAN TRANSFER/DOC MG-LE-805
117011-PROJECTS 1
117012-AUTOMATION
117013-LOAN ADMIN 3
kindly provide u r response.
Thanks
Built in search (#text_search) functionality highlight only first match in the grid.
If you want to hightlight all matches - you need to use search API and custom UI
If you want to show only matched rows - use #text_filter