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