smk
smk copied to clipboard
bcgov
cascading queries specification
Request from business area.
Currently, a query defined on a layer is not cascading. It would be nice to have the option to confiure a cascading query.
Example: a dataset contains the following attributes: HEALTH_AUTHORITY, CITY, BUSINESS NAME
In a cascading (top-down) search, a user chooses Vancouver Coastal as the Health Authority then under City users should only see distinct CITY values where HEALTH_AUTHORITY = 'Vancouver Coastal'. Victoria, for example, would not be among the CITY choices in such a case.
