Tuesday, March 24, 2020
Tip of the Day: Filtering and Capturing Enhanced DB Grid Results
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.2.20312 or higher
Sections......: Forms
Keywords......: Enhanced DB Grid, Filter, WHERE Clause, ORDER BY
Did you know there were new GETPROPERTY command parameters added to provide
greater control when filtering Enhanced DB Grids and capturing the results?
The new CURRENTFILTERCOLUMNNAME parameter captures the field/column name
where the focus is clicked for the filter in Enhanced DB Grids.
Example 01:
GETPROPERTY CustomerGrid CURRENTFILTERCOLUMNNAME 'vFilterColName'
After filtering is performed, the CURRENTWHERE and CURRENTSORT parameters
capture the current WHERE Clause and current sort for the Enhanced DB Grid.
Example 02:
GETPROPERTY CustomerGrid CURRENTWHERE 'vGridCurrentWhere'
GETPROPERTY CustomerGrid CURRENTSORT 'vGridCurrentSort'
CURRENTWHERE will return the combination of the form-level WHERE Clause and
the grid-level filter. CURRENTSORT will return the current ORDER BY.
The command syntax is also supported on a table level to capture the current
WHERE clause and current column sort in forms. The below captures the current
WHERE Clause and ORDER BY for the table:
GETPROPERTY TABLE 'Customer->CURRENTWHERE' 'vCurrentWhere'
GETPROPERTY TABLE 'Customer->CURRENTSORT' 'vCurrentSort'
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/202003241319.02ODJRQE019702%40atl4mhob12.registeredsite.com.
