Forum
22:15
30/07/2010
Dear Tony,
I ma using jqGrid 3.7.2. I tried to search for "" within my column from filterToolbar (local search) but it can not handle it. It gives me following error:
unterminated string literal
[Image Can Not Be Found]({"groupOp":"AND","rules":[{"field":"sharename","op":"cn","data":""}]})
Is there a way to handle this by searchBefore options in filterToolbar? Please give me a solution with code.
Thanks.
Archan Bhatt
23:34
30/07/2010
here is my grid options:
var mygrid = jQuery("#jqGrid").jqGrid({
url:url,
datatype: "json",
colNames: ['1','2', '3, '4', '5', '6','7','8','9', '10'],
colModel: [
{name:'1',index:'1', width:220, align:"left", formatter: sharenameFormatter},
{name:'2',index:'2', width:85, align:"right", search: false, sorttype:"int"},
{name:'3',index:'3', width:80, align:"right", search: false, sorttype:"int"},
{name:'4',index:'4', width:50, align:"center", sorttype: "date", datefmt: "M/D/Y", search: false},
{name:'5',index:'5', width:80, align:"right", search: false, sorttype:"int"},
{name:'6',index:'6', width:50, align:"center", sorttype: "date", datefmt: "M/D/Y", search: false},
{name:'7',index:'7', width:80, align:"right", search: false, sorttype:"int"},
{name:'8',index:'8', width:55,align:"center", sorttype: "date", datefmt: "M/D/Y", search: false},
{name:'9',index:'9', width:130, align:"left", sortable:false, formatter: emailFormatter},
{name:'10',index:'10', width:40, align:"center", sortable:false, search: false} ],
rowTotal: 1200,
rowNum: 20,
rowList:[10,20,30,40,50],
pager: '#pager',
sortname: '1',
sortorder: 'asc',
viewrecords: true,
emptyrecords: 'No data Found!',
width: 1150,
height: 470,
gridview: true,
//altRows: true,
ignoreCase: true,
mtype: 'GET',
multiselect: false,
headertitles: true,
sortable: false,
caption: 'Info',
hidegrid: false,
recordtext: 'View {0} - {1} of {2}',
loadtext: 'Loading...',
rownumbers: false,
loadonce: true,
toolbar: [true, "top"],
viewsortcols: [true,'horizontal',true]
});
jQuery("#jqGrid").jqGrid('navGrid','#pager',{edit:false,add:false,del:false,search:false,view:false,refresh:false});
jQuery("#jqGrid").jqGrid('navButtonAdd',"#pager",{caption:"Toggle",title:"Toggle Search Toolbar", buttonicon :'ui-icon-pin-s', onClickButton:function() {
mygrid[0].toggleToolbar();
}
});
jQuery("#jqGrid").jqGrid('navButtonAdd',"#pager",{caption:"Clear",title:"Clear Search",buttonicon :'ui-icon-refresh', onClickButton:function() {
mygrid[0].clearToolbar();
}
});
jQuery("#jqGrid").jqGrid('navButtonAdd','#pager',{ caption: "Columns", title: "Reorder Columns", onClickButton : function () {
jQuery("#jqGrid").jqGrid('columnChooser');
}
});
jQuery("#jqGrid").jqGrid('gridResize',{minWidth:650,maxWidth:1150,minHeight:200, maxHeight:850});
jQuery("#jqGrid").filterToolbar({searchOnEnter: false});
function sharenameFormatter(el, cellval, opts) {
return "<a href="http://someUrl.php?DN="+el+"" target="_blank">"+el+"</a>";
}
function emailFormatter(el, cellval, opts) {
var re = /DN/;
if(!opts[0]) opts[0] = opts['1'];
var opts = opts[0];
if(opts.match(re)) {
opts = opts.split("DN=");
opts = opts[1].split(""");
opts = opts[0];
}
//console.log(opts);
return formatEmail(el, opts);
}
function formatEmail(email, id) {
if(!email) email = "";
var emailHtml = "<div class="ui-icon ui-icon-plus" style="float:right; display:inline!important; vertical-align:middle; position:relative; z-index:2; cursor:pointer;" title="subscribe" onclick="javascript:subscribe('"+id+"');" ></div>" + "<div title='"+email+"' id='email"+id+"' style="display:inline!important; white-space:pre-wrap; margin-right:20px; z-index:1;">"+email+"</div>";
return emailHtml;
}
regards,
Archan Bhatt
Most Users Ever Online: 715
Currently Online:
37 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66