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, 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.).