dropdowns in parameters do not show all table content
I want to set up a multiple parameter (on three fields). but one of the fields is behaving weardly. it does not show all the data in the table behind it.
do you know about such behavior?
the values not shown are values starting with a character. the values starting with a number (but that perhaps contain a character further on), are shown.
thanks in advance for your ideas
David Deitch replied
My experience is not that it only displays the first 1000 values but that it only examines the first 1000 rows and then displays the unique values from that subset.
Who has had dynamic parameters show only a dozen options from what should have been a couple dozen unique values among thousands of rows...