Trying to create a workflow that takes the results of a query and then creates a filter to only let through some of those rows if EmployeeID matches the format of SLS-----.
For the life of me, I can't find a filter expression that works.
value.EmployeeID.test('SLS') throws an error that says it isn't a function and
value.EmployeeID.includes('SLS') says .includes is undefined.
Long story short, I want value.EmployeeID to evaluate true or false if SLS appears in it. What am I missing?
(and yes, I realized I could take care of this in the WHERE clause of the earlier query but since I'm new to ReTool I want to understand how the Filter block works even if I'm not using it the wisest way.)