Hi! I need to put the grid dynamic. I need to show diferents tables in the grid. So i need to change the cols in the grid. I try to do this but doesnt work. Someone can help me ?

I change the query with a <select> in html. The Query works well. But the cols doesnt change.

$( "select" ).change(function() {
var str = "";
$( "select option:selected" ).each(function() {
str += $( this ).val() + " ";
str=str.toString().split(';');
str=str.toString().split(',');
});
$.ajax({
type: "POST",
url: "includes/query.php",
data: { namequery: str[0] }
,success:function (data)
{
if (data=='OK')
{
var myGrid = jQuery("#list1");
// reset filters and sort field
myGrid.setGridParam({
postData: {
filters: JSON.stringify({
groupOp: "AND",
rules: []
})
},
sortname: ''
}).trigger('reloadGrid');

// empty toolbar fields
jQuery(".ui-search-input input").val("");

$("#fbox_list1_reset").click();
}

}

I do a query in Ajax to take the cols and the new query and then I try to change them in the grid. I put these variables in $_SESSION and then call $g->select_command =$_SESSION['query']; and update cols using foreach

Thanks for all! Sorry for my bad english