All records not returned with 'All' selected in 'Custom plan property' in Sagent
Issue
'All' chosen in the 'Custom plan property' during plan execution, does not output all records in the Sagent.
Cause
It could be caused if 'Type:' in the 'Add Custom Property' is not '* list' for example 'string list','int list','decimal list'.
Resolution
UPDATED: May 27, 2019With 'All' options, Custom Property needs to be of list 'Type:' so that it can contains multiple values.
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.).
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.).
