At 01:53 PM 4/14/2011, Javier Valencia wrote:
R:azzak,
When I am using an Enhanced grid in a form, I really like the Filter Bar
option, as it allows selecting records quickly. I know I can limit the
rows on the table by using the WHERE clause when opening the form to select
a sub-set; however, once a sub-set is selected, the entire set cannot be
seen without exiting the form or using views and then closing, redefining
and re-opening the view. I am trying to get away from this by using a grid
with a pre-set value on the Filter bar so the user can, if necessary, just
delete the filter value and then the entire set is displayed. I would like
to be able to pre-set the Filter Bar with a value by using the PROPERTY
command on the After Start EEP, such as:
PROPERTY GridComponentID FILTER->COLUMNNAME->' 'value'
So, when the form opens, the grid has a pre-set 'value' for the COLUMNNAME
filter, and only the records meeting this criteria are shown and the user
can then reset or delete the value to show a different or the entire set
of records.
I have gone over every possible PROPERTY option for the Enhanced Grid and
I have not been able to find one that would allow me to do what I described
above; however; there are so many PROPERTY options for the Enhanced grid
that I could have missed an obvious one. Is there a PROPERTY option that
would allow me to do this?
Javier,
The following command/syntax is used for the illustration below:
-- EnhancDBGrd_BandList_Properties.RMD
IF (CVAL('DATABASE')) <> 'RRBYW17' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT RRBYW17 IDENTIFIED BY NONE
ENDIF
CLS
EDIT USING RBG91_EnhancDBGrd_BandList_Properties +
ARRANGE InvoiceHeader BY TransID +
ORDER BY Company
RETURN
Before: http://www.razzak.com/tips/Enhanced_DB_Grid_BandList_Before.png
After: http://www.razzak.com/tips/Enhanced_DB_Grid_BandList_After.png
In reference to your question, the entire data set must be loaded
first without
a WHERE clause in order to provide a range of filter options to end-user(s).
Currently, there are no PROPERTY commands to Pre-Set the Filter Bar
as On After
Start EEP. However, it would be a good enhancement request
([email protected]).
On the other side, you may clear all filter values at once using the following
PROPERTY command:
PROPERTY <Component ID> CLEARFILTER 'TRUE'
RETURN
Very Best R:egards,
Razzak.
