Default Grid Filter on Opening

[TPeterson]

I have a grid with a list of nursing home operators to whom we lease facilities. I have a check-box filter that, among other things, allows for filtering on the Status of the Operator as being either "Active", "Inactive" or "Prospective". I've set the Status initial value to "Active" hoping that when the grid is opened only the "Active" operators are initially shown. When opening the grid, the "Active" filter is correctly checked, however ALL the operators are shown and I have to click the Filter button to actually run the filter. How do I get the filter to automatically run when the grid is opened? Thanks.

[Bill Griffin]

Re: Default Grid Filter on Opening

You can set a default filter in the Query tab

DefaultFilter.PNG

[TPeterson]

Re: Default Grid Filter on Opening

Bill, thanks for your response. The problem I get when filtering the grid query is that ONLY the "Active" operators populate the grid. If I then clear all filters, the grid still only shows the "Active" operators. It seems like I need some kind of ongridinitialize ajax callback to run the initial filter, or something (I'm now using developer language way above my head!).

[Clipper87]

Re: Default Grid Filter on Opening

Tom,

All you have to do is put "{grid.Object}.submitSearchForm();" in the OnGridRenderComplete client side event which basically acts as if the user clicks on the search button the first time the grid is shown.

ogrc.png

[TPeterson]

Re: Default Grid Filter on Opening

Thanks Frank. Adding that event did result in the grid only showing "active" operators on initial rendering, and I thought I was done. However, when "Clear Filter Criteria" is clicked, the "Active" Status search criteria is automatically checked, I guess because it's using "Active" as a default value as opposed to just an initial value for Status. I have to manually uncheck the "Active" check box to make it go away. Either I keep the event you suggested and I do away with the "Clear Filter Criteria" link, so it's clear that the checkboxes have to be manually checked/unchecked, or I don't set the initial value of Status to "Active" and instead figure out how to do an initial search on Status = "Active". Thanks again.

[Lance Gurd]

Re: Default Grid Filter on Opening

Tom,
I have a Jobs grid with a status field.
I use the quick search in the grid properties with settings,
position - in grid,
position - centre,
field(s) to search - status,
allow QBF style - checked,
search style - exact,
control type - radiobutton
choices - list type - static, choices - Active, Inactive, Prospective (for your grid, I have 4 options)
maximum number of choices - 0
has 'showall' button - checked
'showall' button text - all
initial selection - Active

This way your grid is filtered both initially and every time the user changes the radio buttons at the top of the grid and you can use the search part of the grid with this filter intact.

[TPeterson]

Re: Default Grid Filter on Opening

Lance, thanks. I look forward to trying your settings tomorrow. Looks like you're pulling an all-nighter!

[Lance Gurd]

Re: Default Grid Filter on Opening

I have a strange body clock

[Clipper87]

Re: Default Grid Filter on Opening

Tom,

Put this in your OnGridRenderComplete client side event and set the default value for your Status search field back to NULL

{grid.object}.setValue('S','STATUS','Active');
//add 10 msec delay to be sure that the previous statement has completed
setTimeout("{grid.Object}.submitSearchForm();",10);


Although {grid.Object}.submitSearchForm() seemed to perform OK I added a 10 msec delay just to make sure that the Status field indeed has been set to 'Active' Note that the fieldname in the setValue statement must be uppercase. If you change 10 into for example 3000 you can better see what actually happens; the status field gets selected with 'Active' and after 3 seconds the search is performed.

[TPeterson]

Re: Default Grid Filter on Opening

Frank, that did the trick! It also immensely helped my understanding of Javascript event handlers. Thanks again.

Lance, I made a duplicate of my grid component to review your settings recommendation. I'll let you know how that turns out.

[TPeterson]

Re: Default Grid Filter on Opening

Lance, I just used your settings recommendation and that worked great too. However, I've added additional filter conditions, i.e. Operator Type as "Public" or "Private", which causes me to need the full Search part. Thanks again!

[Lance Gurd]

Re: Default Grid Filter on Opening

Glad it worked

[kotinkarwak]

Re: Default Grid Filter on Opening

Hi,
I have made use of the quick search method and wondered how I would "clear" the initial setting of ACTIVE status after performing a search or a clear searches. At the moment the quick search options that have been defined as options still show ACTIVE, in this case misleading.

initial-state.png

after-search.png


Regards

[Clipper87]

Re: Default Grid Filter on Opening

Check the id of the radiobuttons using Firebug & set checked to false in for example the aftersearchsubmit event

var rb1 = $('GRID1.D.V.R1.CPL.1');
rb1.checked=false;

'GRID1.D.V.R1.CPL.1' is the id in my test case so that will be different for you

[kotinkarwak]

Re: Default Grid Filter on Opening

Thanks,
Still arm wrestling with this.
The setting .checked=false doesn't achieve result. have tried this in firebug as well.

var rb1 = $('GRID1.QUICKSEARCH');
rb1.checked = false;
console.log(rb1);
console.log(rb1.innerHTML);

I have output the innerHTML for this object as below, highlighting that the second item is selected, can't figure how to move that to the ALL settings since on clear of the selection, the intention will be that all will now be selected hence this if indicated for the qucik search options will complete the picture.

"<span><input value="-999999999" name="GRID1_QUICKSEARCH" onclick="GRID1_GridObj.quickSearch($gvs('GRID1_QUICKSEARCH'));" type="radio">ALL</span>
<span><input checked="checked" value="ACTIVE" name="GRID1_QUICKSEARCH" onclick="GRID1_GridObj.quickSearch($gvs('GRID1_QUICKSEARCH'));" type="radio">ACTIVE</span>
<span><input value="INACTIVE" name="GRID1_QUICKSEARCH" onclick="GRID1_GridObj.quickSearch($gvs('GRID1_QUICKSEARCH'));" type="radio">INACTIVE</span>
<span><input value="PROSPECTIVE" name="GRID1_QUICKSEARCH" onclick="GRID1_GridObj.quickSearch($gvs('GRID1_QUICKSEARCH'));" type="radio">PROSPECTIVE</span>
"