How to check "does not contain" in saql?

Question

I have written my saql like

q = load "Opportunities";
q = filter q by !('Opportunity.Name' in ["test","TEST ","Test"]);
q = group q by 'Opportunity.Name';
q = foreach q generate 'Opportunity.Name' as 'Opportunity.Name', count() as 'count';

Also I have tried

q = load "Opportunities";
q = filter q by 'Opportunity.Name' not in ["test","TEST ","Test"];
q = group q by 'Opportunity.Name';
q = foreach q generate 'Opportunity.Name' as 'Opportunity.Name', count() as 'count';

But in the final results I am getting the Opportunity names contains "Test","TEST"

Answer 1

If you want to exclude any opportunity with "Test" in the name I think you would want to use the matches operator.

q = load "Opportunities";
q = filter q by !('Opportunity.Name' matches "test") && !('Opportunity.Name' matches "Test") && !('Opportunity.Name' matches "TEST");
q = group q by 'Opportunity.Name';
q = foreach q generate 'Opportunity.Name' as 'Opportunity.Name', count() as 'count';