0:07
hello everyone in this video we are
0:09
going to see how to make use of not and
0:13
operators uh in Salesforce s soql we
0:17
don't have uh an option to directly use
0:21
not in together for example here I'm
0:24
getting the name and Industry from
0:26
account object where industry in let's
0:31
um a requirement where you wanted to
0:34
get uh all the account and account name
0:38
Industry and where the industry is not
0:41
in construction chemicals banking
0:42
apparel electronics and also null so if
0:46
you have the opposite of it like not in
0:49
we cannot directly use industry not in
0:53
not space in and these values Salesforce
0:56
SQL does not support uh not in direct ly
1:01
combined together uh but there is not
1:04
operator in soql so we can make use of
1:08
that uh to achieve the not in operator
1:11
for example here I'm getting name and
1:14
Industry from account where not industry
1:17
in so in this case it will fetch all the
1:21
account records where industry is not in
1:25
these values and also not
1:37
please check the video description in
1:39
the video description I have shot my
1:41
blog post from the blog post you should
1:43
be able to get the sample s soql which
1:45
was referenced in this
