Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
jqGrid filterToolbar does not handles special characters like \
30/09/2010
22:15
Avatar
archan.bhatt
Member
Members
Forum Posts: 19
Member Since:
30/07/2010
sp_UserOfflineSmall Offline

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

30/09/2010
23:34
Avatar
archan.bhatt
Member
Members
Forum Posts: 19
Member Since:
30/07/2010
sp_UserOfflineSmall Offline

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

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information