The desired situation
When changing the prefilter type, the SF gives a message to determine whether you want to delete underlying data, or exclude that this change can take place so that a developer is forced to empty underlying data first.
Current situation
- When you change a prefilter type in the SF from prefilter type "Query" to "Prefilter columns" the query is not emptied.
- When you change a prefilter type in the SF from prefilter type "Prefilter columns" to "Query", the columns underwater are not deleted.
The GUI works well because it determines based on the prefilter type whether the where statement is built based on the query or the columns.
