Please find the attached example application. The examples shows the following:
To test:
Click '400,000 + rows'. Wait for the data to load, this may take a while.
Drag 'Project Manager' and 'Job' to the Row area.
View the Project Manager filter and see the Blank row.
Click 'Get Available Project Managers'
View the output, notice that the 1st row is '010' NOT ' '.
Click 'Get Unique Project Managers'
View the output, notice that the 1st row is '010' NOT ' '.
The btnGetAvailableValues_Click and btnGetUniqueValues_Click events show
that the field.GetAvailableValues() and field.GetUniqueValues() events are not returning a row when
the value is spaces " " , which can be a valid value. The built in filtering displays a checkbox for blank values.
Is there another event or option that can be set to achieve the returning of a Blank selection?
I have managed to replicate the problem with the GetAvailableValues method. This issue is a bug. We will fix it in the near future. The problem with the GetUniqueValues method was fixed in the context of the T292840: GetVisibleValues and GetUniqueValues methods do not return the Blank values bug report.