Search code examples
javajspjqgridstruts2

Struts2 jQGrid Plugin Case Insensitive toolbar searching


I find this two topics very useful:

(first: Case insensitive search in jqGrid including hidden fields),
(second: Search in the middle of a column by default in jqGrid with toolbar search),

How to apply this in JSP?


Solution

  • i fount the solution: This is the response JSP:

    <%@ taglib prefix="s" uri="/struts-tags"%>
    <%@ taglib prefix="sj" uri="/struts-jquery-tags"%>
    <%@ taglib prefix="sjg" uri="/struts-jquery-grid-tags"%>
    <div id="prije">Prije</div>
    
    
    <s:url var="remoteurl" action="jsontable" />
    
    <sjg:grid id="gridtableID" 
    
        caption="Primjer JSON TABELE" 
        dataType="json"
        href="%{remoteurl}" 
        gridModel="gridModel" 
        viewrecords="true"
        pager="true"
        pagerPosition="centar"
        navigator="true"
        navigatorSearch="true"
        filter="true"
        filterOptions="{stringResult:true}"
        loadonce="true"
    
         >
    
        <sjg:gridColumn name="id"
            index="id" title="ID" 
            formatter="integer"
            search="false"
            searchoptions="{sopt:['cn','eq','ne','bw','bn','ew','en','nc']}"
            editable="false" />
        <sjg:gridColumn name="name" index="name" title="Name" sortable="true"
            search="true"
            searchoptions="{sopt:['cn','eq','ne','bw','bn','ew','en','nc']}" />
        <sjg:gridColumn name="country" index="country" title="Country"
            search="true"
            searchoptions="{sopt:['cn','eq','ne','bw','bn','ew','en','nc']}"/>
        <sjg:gridColumn name="city" index="city" title="City" search="true"
            searchoptions="{sopt:['cn','eq','ne','bw','bn','ew','en','nc']}" />
        <sjg:gridColumn name="creditLimit" index="creditLimit"
            title="Credit Limit" formatter="currency" search="true"
            searchoptions="{sopt:['cn','eq','ne','bw','bn','ew','en','nc']}"/>
    
    </sjg:grid>
    
    <script>
    $(document).ready(function(){
        $("#gridtableID").jqGrid('setGridParam', { ignoreCase: true});
        });
    </script>