A previous advanced filtering demo that I had posted got wiped out when moving to the new forums, so I'm posting a new one.
This advanced filter demo BSV uses:
1) Form of LoggedInRegularUser for selection of filters. Auto-refresh and 'Save form when selection changes"
2) Customer query that utilizes Auto-refresh to show new filtered selections any time the filters are updated.
3) Filter form has no buttons & includes a link to "Clear filters" that appears any time a filter is applied. READ PROTECT rule makes this link appear only when appropriate.
4) Customers query is driven by the following query that utilized values in LoggedInRegularUser:
FIND Customer WHERE (Customer=LoggedInRegularUser.Selected_Customer OR LoggedInRegularUser.Selected_Customer IS UNDEFINED) AND (Customer.City=LoggedInRegularUser.Selected_City OR LoggedInRegularUser.Selected_City IS UNDEFINED) AND (Customer.Region=LoggedInRegularUser.Selected_Region OR LoggedInRegularUser.Selected_Region IS UNDEFINED) ORDER BY Customer.Name
Note that this demo was build using V6 build 2042.
Sample BSV:
