Adrian asked 7 years ago
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
Abu Ghufran answered 7 years ago
Hello,
To have difference columns structure, you need to refresh whole page.
The ajax call cannot change the html generated for columns.
Abu Ghufran answered 7 years ago
The grid is loaded with 2 server requests.
1) load the columns of grid and related html
2) do an ajax call, to load data of grid.
Only #2 is ajax call, so if you want to change structure you will need page refresh. It will not work with just ajax call and changing sql.
It is how it currently works.
If it is not suitable for your requirement, we recommend to use some alternate grid.
adrian answered 7 years ago
Hi!!
"You serious? What kind of garbage is it!!?" -This post wasn´t me
I try with the reload of page. In Chrome and Opera Works well. But in Mozilla and IE doesn´t work. Any idea?? Thanks so much!!
Abu Ghufran answered 7 years ago
Can you check debug console (F12) for possible JS errors?
https://phpgrid.desk.com/customer/portal/articles/926266
