Hello,
We have a custom process to disable users if their termdate is past. Below is the where clause
Dim f As ISqlFormatter = Connection.SqlFormatter
Value = f.AndRelation(f.Comparison("IsTemporaryDeactivated", False, ValType.Bool, CompareOperator.Equal, FormatterOptions.None), _
f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal, FormatterOptions.None), _
f.Comparison("CCC_TMDATE", Date.Now.Date, ValType.Date, CompareOperator.LowerThan, FormatterOptions.None), _
f.Comparison("CCC_TMDATE", DBVal.MinDate, ValType.Date, CompareOperator.GreaterThan, FormatterOptions.None))
We want to dump all the users that were disabled based on above to a file on the job server. How do we go about doing this? Please advise
Thanks in advance