Set grid filter OnInialize, then clear on search

[Peter.Greulich]

Given a MySql datetime field named "Updated", I want to have the grid load just showing today's records.

Putting this in the grid query does this:

DATE(Updated) = curdate()


So far so good. Bu I want to be able to use the search part to show other dates, hence this code:

OnSearchPartFilterCompute:
Dim args as SQL::Arguments
vDate = e.SearchDataSubmitted.UPDATED
args.add("Date",vDate)
e.rtc.filter_searchPart = "DATE(Updated) = :Date"
e.rtc.parameters_searchPart = e.SearchDataSubmitted.Updated+"|||D|Date"

Which works great all by itself. But shows no data if i use the first filter above.

I need both; 1) show today's records, then 2) search on other dates. I can do either one, but not both.

eh?

P.S. I swear I've done this before but can't find an example.

[cptutrecht]

Re: Set grid filter OnInialize, then clear on search

I think a solution could be not to set the filter in the mysql query but using javascript gridfilterset method. It sets a userfilter, so it wil be overruled when doing a new search.

From the builder:

//NOTE: The filter and order expression must be enclosed in single quotes. Therefore if your filter uses single quotes
you must escape the single quote. e.g. 'customername = \'smith\''.
You cannot use double quotes in the filter as it will cause a Javascript error.
Therefore, the recommended approach is to always use a filter that has arguments, and pass in the argument values as the 3rd parameter to the method.
(see examples below).
//Filter the Grid to show orders above $1,000, ordered by orderTotal.
{grid.Object}.gridFilterSet('ordertotal > 1000');
//Sort the Grid by Lastname and within Lastname, by Firstname. (SQL Table)
{grid.Object}.gridFilterSet('','Lastname, Firstname');
//Sort the Grid by Lastname and within Lastname, by Firstname. (DBF Table)
{grid.Object}.gridFilterSet('','Lastname+Frstname');
If you use arguments in the filter (e.g. orderdate = :whatOrderdate), then you can specify parameter values with the
'filterParameters' argument.
The syntax for parameters is a '\n' (Javascript CRLF character) delimited string with value|||type|parameterName
//Search for records where City is 'London'. Order result by 'Contactname'
GRID1_GridObj.gridFilterSet('city=:whatCity' ,'Contactname','london|||c|whatCity\nuk|||c|whatcountry');
//Search for records where City is 'London' and Country is 'UK'
GRID1_GridObj.gridFilterSet('city=:whatCity and country = :whatCountry','','london|||c|whatCity\nuk|||c|whatcountry');
Note: In the above example, the filter uses 2 arguments (:whatCity and :whatCountry). Therefore the 3rd parameter passed into the method
defines these two arguments. Each argument is delimited with '\n' - the Javascript encoding of a CRLF character.

[Peter.Greulich]

Re: Set grid filter OnInialize, then clear on search

Thanks Ger. I tried that but no luck.

[cptutrecht]

Re: Set grid filter OnInialize, then clear on search

Strange... Maybe Alternative change the basefilter: http://wiki.alphasoftware.com/Grid+C...e+Filter+V10.5

[Peter.Greulich]

Re: Set grid filter OnInialize, then clear on search

Got it to work - by cheating.

Set this as the user filter in the tabbed_ui:

DATE(Updated) = curdate()

Then the regular search part worked using the code above in post#1.


--
BUT: if anyone knows the right way - i.e. w/o using the tabbed_ui as the starting filter please let me know.

[christappan]

Re: Set grid filter OnInialize, then clear on search

another workaround but probably still not the "right way" you're looking for, but you could put something like this in the onSearchRender:

var now = new Date();
var month = now.getMonth();
month = month + 1
var day = now.getDate();
var year = now.getYear();
if(year < 2000) { year = year + 1900; };
var datestr = month + '/' + day + '/' + year;

{grid.Object}.setValue('S','DATEFIELD',datestr);

{grid.Object}.submitSearchForm();

[Peter.Greulich]

Re: Set grid filter OnInialize, then clear on search

That's very nice, Chris. Works for me.

I didn't know that the onSearchRender fires upon grid load. Cool.

[agillbb]

Re: Set grid filter OnInialize, then clear on search

You could also simplify Chris' javascript:

var now = new Date();
{grid.Object}.setValue('S','DATEFIELD', $u.d.toStr(now,'[mm]/[dd]/[yyyy]') );
{grid.Object}.submitSearchForm();

[christappan]

Re: Set grid filter OnInialize, then clear on search

I use that approach in several places in our app, and it has its pros and cons, namely that the user can see what the original search criteria are, but the grid loads and then the search fires, so unless you hide the grid until a search is executed, the grid queries the data twice.

Thanks Andy for the shorthand. Most of my javascript is borrowed--I'm still learning things like you've got.

[agillbb]

Re: Set grid filter OnInialize, then clear on search

Yes. To avoid the double query, you can set the user filter from the button that opens the grid, and just display the filter value in the search box so that the user at lease knows the filter is active.

It also makes sense in search-oriented grids to keep the focus on the search box, so in several of the client-side js events (like onGridRenderComplete, afterSearchClear, etc.) you should put:
$('{Grid.ComponentName}.S.MYSEARCHFIELD').focus();

You might also wish to throw this in your onKeyPress event so that the enter key triggers the submit:

//capture the ENTER key from search part textbox
var keyCode = event.charCode || event.keyCode;
if (keyCode==13)	{grid.Object}.submitSearchForm();

[christappan]

Re: Set grid filter OnInialize, then clear on search

Andy, at least with most Search Part control types, the enter key functions in that manner even without your code (though thanks for that insight). In fact, when Alpha offered the option of a search submit icon in v11 the functionality was lost until I asked them to replace it (and they did).

[agillbb]

Re: Set grid filter OnInialize, then clear on search

Oh, sorry, I had to do this in the past partly because there were instances where the ENTER key did not work because it was being trapped by parent components.
So you might keep it in your back pocket in case you need it :)

[djvdm]

Re: Set grid filter OnInialize, then clear on search

I have a similar need to default a grid to today's date and then be able to search by any other date, however, I am using a grid based on a stored procedure and am not able to choose a field to filter by on the TUI. Currently, I am using the onSearchRender event to set the date and fire the search, but I'd rather have the grid open with today's results rather than open and show a blank grid briefly while the search completes. I would like to set the default date in the argument setting but it complains about date() or now() not being a date value.

Not a critical issue, but it would be nice to use one step instead of two. Any suggestions?