Some improvements

[acreonte82]

Hello,
my post is only to know if ,in the new version, the crud will have a search function (for each columns)  like kendoui.com crud..

Thanks in advance!!

[stworthy]

A datagrid filter example can be found here http://jsfiddle.net/urhv6/.

[acreonte82]

Ok I know, but I mean a search function with logic operator in column..
Like a dropdown menu, foreach columns, with a multiple type of search function with operator  "And/or/not/between.." and "> < =..."

Attached an example

[mapner]

stworthy,

Very good example of filter in a grid.
How to use it with remote searching?

thanks

[finzaiko]

Yes, Im waiting remote searching too 

Thanks stworthy,

[acreonte82]

stworthy,
I'm waiting your answer !!!

[stworthy]

The feature request for remote filtering has been sent to our develop team. We will release this solution after this develop work is finished.

[stworthy]

The datagrid filter extension is available now. It can be downloaded from http://www.jeasyui.com/extension/datagrid_filter.php.

[arma]

1. How to make any filter component to be autofit the width with its column header width on load? It only fits if i resize column header manually.
2. How if i want to unfilter a column (no filter component in a certain column) ?

[stworthy]

Please download the updated datagrid-filter file from from http://www.jeasyui.com/extension/datagrid_filter.php.
To apply a un-filter component, use 'label' filter as below:

Code:

dg.datagrid('enableFilter', [{
field:'itemid',
type:'label'
}]);

The user can also extend a new filter component. The code below shows how to achieve a 'label' filter.

Code:

$.extend($.fn.datagrid.defaults.filters, {
label: {
init: function(container, options){
return $('<span></span>').appendTo(container);
},
destroy: function(target){
$(target).remove();
},
getValue: function(target){
return $(target).html();
},
setValue: function(target, value){
$(target).html(value);
},
resize: function(target, width){
$(target)._outerWidth(width)._outerHeight(22);
}
}
});

[mapner]

Hi,

I'm using a button for make remote search.
How I can make search while typing the text like local search?

thanks

Code:

<table id="g-tck" title="Tickets" class="easyui-datagrid" style="width:auto;height:auto;" url="<?PHP echo _URL_ ?>tickets/GetPage",
toolbar="#tb1"
pagination="true" fitColumns="true" singleSelect="true">
<thead>
<tr>
<th field="NAME"  sortable="true">Customer</th>
<th field="DATETIME_ADD"  sortable="true">Date/Time</th>   
<th field="TITLE"   sortable="true">Title</th>
<th field="STATE"   sortable="true">State</th>   
</tr>
</thead>
</table>
<div id="tb1" style="padding:5px;height:auto"> 
<div> 
<a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" plain="true" onclick="doSearch()"></a>
</div>
</div>   

Code:

<script type="text/javascript">

function doSearch(){   

var q_filter = JSON.stringify( $('#g-tck').datagrid('options').filterRules );

$('#g-tck').datagrid('load',{  q_filter: q_filter }); 

} 

$(function(){
var dg = $('#g-tck').datagrid({filterBtnIconCls:'icon-filter'});
dg.datagrid('enableFilter');
dg.datagrid('options').remoteFilter = true;
});

</script>

[stworthy]

The remote filtering requires the 'url' property set to retrieve data from remote server. When filtering values changed, the 'filterRules' parameter will be sent to remote server.

Code:

$(function(){
var dg = $('#g-tck').datagrid({
filterBtnIconCls:'icon-filter',
url:...,
remoteFilter:true
});
dg.datagrid('enableFilter');
});

[mapner]

stworthy,

great work!

May be you must to include this in the documentation:

"When use remote filtering the 'filterRules' parameter will be sent to remote server in JSON format"

Thanks!

[acreonte82]

Great work!!
thank you for having implemented my idea.
Hope this new feature helped many developers and hope it grow with new features!!

[acreonte82]

stworthy can be a great idea to do a Tutorial/Demo of remote data filtering