Unlike when we use on-demand with a filter parameter, where we send the distinct values, using on-demand with named parameters we send the complete data set
We should add the ability to the on-demand feature, i.e., the on-demand dialog (and API if such exists) enabling an end user to specify whether to use distinct values or (as today) the complete data set.
Right now since we don't use distinct values a lot of duplicates are sent to an external system, i.e., database, which causes unnecessary stress on the external system.
