system
#1
Hi,
I 'm trying to create a variable that filters out a specific sitename.
It’s giving me a syntax error if i use the <> symbol for not equal. Does BO not support inequality in a where clause?
= Where (<Sitename(Query 1 with Loyalty)> <> “Arclight”)
thanks.
srt6 (BOB member since 2003-09-17)
system
#2
Please, take a look at FAQ Reporter here.
Please, do a Search on BOB first before posting a question.
Andreas (BOB member since 2002-06-20)
system
#3
You just can’t. Build a filter instead.
Steve Krandel (BOB member since 2002-06-25)
system
#4
My apologies for not looking at the FAQ first. Did do a search and did not find anything on it, guess i need help on that too
Filtering as Steve suggested works for me. I just got caught up the fact how a Where clause doesn’t take an inequality.
Thanks.
srt6 (BOB member since 2003-09-17)
system
#5
You can use a “<>” in a Join so it’s kind of strange you can’t use it in a WHERE clause, especially since the database allows it.
Iggy (BOB member since 2002-10-24)
system
#6
It’s a WHERE option on a variable, not in a query. 8) BusinessObjects only supports =, and only against a constant rather than another variable.
Dave Rathbun (BOB member since 2002-06-06)