Dynamic data option in filter datagrid

[acreonte82]

Hello to all,
when we define the filter in datagrid we also have to define the value will be present in a combobox filter

Code:

$('#laboratory_result').datagrid({remoteFilter:true}); 

$('#laboratory_result').datagrid('enableFilter',[
									{
								field:'type_of_result',
						                type:'combobox',						              
						                options:{
						                    panelHeight:'auto',						                   
						                    data:[	{value:'',text:'All'},
						                    		{value:'Check positive control - Matching passed',text:'Check positive control - Matching passed'},
						                    		{value:'Check positive control - Matching failed',text:'Check positive control - Matching failed'},
						                    		{value:'Get genotype data',text:'Get genotype data'},
						                    		{value:'Sample ID not found',text:'Sample ID not found'},
						                    		{value:'UNDETERMINED/OMITTED',text:'UNDETERMINED/OMITTED'}
						                    	],
						                  
						                    onChange:function(value){
						                        if (value == ''){
						                            $('#laboratory_result').datagrid('removeFilterRule');				                            
						                            
						                        } else {
						                            $('#laboratory_result').datagrid('addFilterRule', {
						                                field: 'type_of_result',
						                                op: 'equal',
						                                value: value
						                            });					                           
						                        }
						                         $('#laboratory_result').datagrid('doFilter');
						                    }
						                }
						            },
						            {
						                field:'sample_number',
						                type:'text',
						                options:{precision:1},
						                op:['equal','beginwith']
						            },
						            {
						                field:'genotype_old',
						                type:'text',
						                options:{precision:1},
						                op:['equal','beginwith']
						            },
						            {
						                field:'genotype',
						                type:'text',
						                options:{precision:1},
						                op:['equal','beginwith']
						            }

						        ]);

When we set the values for a combobox filter the problem is how to implement a function that retrive all element for the combobox
At the moment I created a php script that return to me a json string with the grouped values
The question is easy: how can I integrate all?

who can help me?

[acreonte82]

stworthy can u help me?

[stworthy]

To let combobox retrieve data from remote server, simply set the specified 'url' property.

Code:

$('#laboratory_result').datagrid('enableFilter',[
{
	field:'type_of_result',
	type:'combobox',						              
	options:{
		panelHeight:'auto',						                   
		url: ...,  // specify the url to retrieve data from remote server
		onChange:function(value){
			//...
		}
	}
},
...

[acreonte82]

Ok I need a vacation....

A last question: if I want to reload the data in the combobox after I reset the filter (selecting the option 'All')?

This is to update the possibile value of filter..

Thanks

[acreonte82]

stworthy?

[stworthy]

Don't understand your question clearly. Maybe you need to explain it in more detail.

[acreonte82]

The scenario, of my case , is this:
- I have a datagrid with some medical results and in this datagrid I defined a personal comands to manage the data (update/delete/standby);
- each columns have a filter and one have combobox filter . The grouped values, of this combobox, are loaded from a php script (a dynamic value)
 

For example: if I show the medical result , selected from a value defined in the combobox , and then I deleted all results , I want to reload the filter values of the combobox. So the system show me the remaining possible values of filter loaded from a php script.

The question is: how I can force the reload of the combobox filter?

[stworthy]

To reload the data of combobox filter component, call 'getFilterComponent' method to get this object and then call 'reload' method on it.

Code:

var cc = $('#dg').datagrid('getFilterComponent', 'type_of_result');
cc.combobox('reload');

[acreonte82]

Thanks!