All records not returned with 'All' selected in 'Custom plan property' in Sagent



'All' chosen in the 'Custom plan property' during plan execution, does not output all records in the Sagent.


It could be caused if 'Type:' in the 'Add Custom Property' is not '* list' for example 'string list','int list','decimal list'.


UPDATED: May 27, 2019
With 'All' options, Custom Property needs to be of list 'Type:' so that it can contains multiple values.

Custom plan proprty

For example, if 'Custom plan property' contains city. With 'Type:' string, it can only take one value (for example 'New York') but with string list type, it can take multiple values (for example 'New York, Chicago, Boston' etc.).