Hi Will:
You nailed it – this is exactly what I was looking for – It didn’t occur to me to look through the Searching/Filtering demos – Thank you so much for pointing me in the right direction.
Ken
Thank you for the update Will. I know that keeping documentation up to date is pretty much always the last thing on the list, but, for me at least, it’s one of the most important things and should be a higher priority.
Ken
Will:
Yes, that’s what I’d like to try and accomplish.
For example, in your demo html file, somehow add in a parameter to only pull records from the table where the productID = 8. So when the button is clicked, the grid only shows that row from the table.
Ken
Thanks, Will. That solved my problem.
Ken
Thanks, Will – I’ll give it a try and let you know…
Hello Guriddo? Anyone care to help me out here?
Will:
The fact that the setSelect commands only is excuted once is the problem. In essence that means you can only filter the entire table on only one column at a time. In other words, in my code above, the initial table yeilds around 5,000 rows (no filters appliaed). The user selects an option from the Platform column, the table refreshes with only those platforms that match the selected option. However, the Location drop-down still contains all of the locations, whereas it should only contain those locations that match the selected Platform. And so on…
What I am looking for is a way to filter the table based on all of the setSelects combined, in sequence of them being selected. I am sure it can be accomplished with javascript, I just can’t quite figure out how to do it. All of the examples in the forum for dependent drop-downs are for the editing forms – I want to make the setSelects (or some other javascript based method) dependent on each other simply to filter the table.
Oh ok. Let me try my last post above. This is what I ended up doing to show/hide the export button based on the number of records returned:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
$grid->navigator = true; $setNav =<<<SETNAV function() { var numrecs = $('#grid').jqGrid('getGridParam','records'); if (numrecs < 200000) { $('#pager_excel').show(); } else { $('#pager_excel').hide(); } } SETNAV; $grid->setGridEvent('gridComplete',$setNav); $grid->setNavOptions('navigator',array('add'=>false,'edit'=>false,'del'=>false,'view'=>true,"columns"=>true)); // Run the script $grid->renderGrid('#grid','#pager',true, null, null, true,true); |
Well heck 😉
Thanks for the quick response and I am looking forward to the next release.
Ken
So I finally figured it out. Here’s what I did that worked:
I’d still like to know how to get code to show up as code after submitting a post though.
Ken
And if you could tell me how to show the code I posted as code I’d appreciate that too.
MymsMan:
I’ve been a customer of their php suite for the past three years or so and I have had the exact same complaint as you regarding their documentation, and I’ve been getting the same promise, that “we know it’s out of date/incomplete and we will have it fixed/updated very soon”.
At this point I doubt that they will ever have decent documentation.
That would make a rather large download. At least I now know that I can just add the table in my local database and if I want I can load it with dummy data.
Thanks for the explanation.
Regards!
Ken
Thanks, Tony.
I for one use the jqCharts library probably more than any other. I’m very relieved that you are working with them to get this done.
Ken
Do you have a plan in place to acquire the rights to distribute the Highcharts library, and if so, when do you expect that to happen?
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top