Suppress "blank" option in Search or Force Selection in Quick Search

[Dfred]

I have a RO grid with an updateable detail view. A quick search is used to filter the RO grid. An initial value for the search is assigned under the quick search properties. A dropdownlist control is used with choices based on field values from a SQL table. My question is:

Can I suppress the blank option that shows up on the dropdownlist?
I can turn off the "ALL" option, but that does not prevent the user from selecting the blank option.

If not, do you have a suggestion on how I can make the search revert to the initial value using XBasic? What event would be appropriate to use?

Thanks in Advance,
Donna

[StephenP]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

I'm not at my computer right now, but you can use the onchange event for the dropdown to check for a blank value and when found return another value instead.

[Dfred]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

I have not been able to find an "onchange" event associated with the Quick Search. I looked under Events in the Grid Component designer and under the Javascript events in the Grid Properties section. I could use some help with writing the XBasic or Javascript required for the event as well.

Donna Frederick

[StephenP]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

As I said, I wasn't at my computer, so I got it a bit wrong. Try this as a starting point.

Under Grid -> Properties -> Javascript - System Events, add the following code for the canQuickSearch event:

var qs_value = $('{Grid.ComponentName}.QUICKSEARCH').value;
if (qs_value == '') {
	alert('You must select a value');
	return false;
}

You can then modify it to behave as needed.

[Dfred]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

Thanks so much. Works like a charm!

Donna

[NormanRMouton]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

Stephen

What must I do to have the same on the normal search fields.

[StephenP]

Re: Suppress "blank" option in Search or Force Selection in Quick Search

You should be able to use the canSearchSubmit event, with the following:

var s_value = $('{grid.componentName}.S.LASTNAME').value;
if (s_value == '') {
	alert('You must select a value');
	return false;
}

Just modify the code inside the if block to suit your needs. I hope it helps.