Often we create named queries that filter out the 'no values'. Example: one of the fields is Product. The dataset contains 10 productvalues, but also records without a productvalue (the no values). My views only need records with a productvalue, so we use Named Queries. When creating the Query we deselect the 'no value' in the fieldfilter and save the Named Query.
Now we get new sourcedata and new productvalues are added to the dataset. The Named Query doesn't work as expected as it only contains the productvalues of the previous dataset where we expected it would leave out NULLS but include new products.
Please advice how to do this as we now have to clear the named query and populate it again after each new refresh. Thanks