Skip to main content
Salesforce

Return to Question

Added code formatting to code snippets
Source Link
Adrian Larson ♦
Adrian Larson ♦
  • 151.3k
  • 38
  • 247
  • 431

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"

Please help me out !!

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"

Please help me out !!

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"

Added code formatting to code snippets
Source Link
edit approved Dec 27, 2018 at 18:22
John Towers
edit approved Dec 27, 2018 at 18:22
John Towers
  • 3.9k
  • 1
  • 21
  • 30

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';

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';

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"

Please help me out !!

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"

Please help me out !!

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"

Please help me out !!

added 48 characters in body
Source Link
moni
moni
  • 25
  • 1
  • 5

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 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"

Please help me out !!

I have written my saql like 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 = 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"

Please help me out !!

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"

Please help me out !!

Source Link
moni
moni
  • 25
  • 1
  • 5