Filter behaviour in views

Filter behaviour in views

The drop-down list of the Filter items is based on all the data of the table. It should be based on the restricted data based on the same criteria of the current view.

If my records are:

FieldA UserID
A slack
B slack
C support
D support






and the view is defined as:

list "MyRecords"
{
show all rows from Listings [(UserID == zoho.loginuser)]
(
FieldA
)
filters
(
FieldA
)
}












The filter currently display: A, B, C, D
The filter should display A and B only.