I’m working in Xcelsius trying to feed multiple criteria to a web service in a particular field so it works properly with my list builder and it doesn’t seem to be pulling back any results.
I used the (+) input control on the field i wanted, and when i snapshot the excel data i can see all of the criteria, but nothing it’s not pulling back any data when i refresh the connection. I’m not sure what the issue is. Has anyone run into this before?
LittleMalky (BOB member since 2012-03-20)
[Moderator Note: Moved from Desktop Intelligence to Xcelsius - Crystal Dashboard Design]
Marek Chladny 
(BOB member since 2003-11-27)
Do I need to do something with the “Operator”? I just left it blank.
LittleMalky (BOB member since 2012-03-20)
download the freeware Fiddler, which is a packet trace program. by looking at the raw html you will be able to see exactly what is going out to the database. You probably have a syntax problem.
also, in QaaWS, each value of a multivalue parameter must be bound to its own cell
(5 values)= 4 times where you click the + and bind to a cell location.
you dont need to config anything else.
Cairmor 
(BOB member since 2008-06-05)
Thank you for your feedback. I actually tested this with Firebug using FireFox and I can see the values getting pushed through. It doesn’t seem to be a syntax issue.
I have 9 potential selections for this one field, and I validated multiple times now that each one is linked to a different cell. Still, my data returns back all zero’s.
LittleMalky (BOB member since 2012-03-20)
So I’m trying to use this Multi select with the List Builder component. After further testing, it seems to only return results when I select one value from the list builder. If i select more than more, then it returns all zero’s.
LittleMalky (BOB member since 2012-03-20)
which web service are you using ?
Cairmor (BOB member since 2008-06-05)
Please let me know if I’m answering this wrong, I’m a rookie at this, but QAAWS hitting a BOBJ latest instance.
LittleMalky (BOB member since 2012-03-20)
I think you’d need to use the INLIST operator, and your values would need to be comma separated.
Hopefully, your values won’t ever contain commas, as I’m sure this would further complicate things.
-tkt
theknowtank (BOB member since 2011-04-20)
^^ thats what I was going to say…
Cairmor (BOB member since 2008-06-05)
So instead of having my field repeat 9 times and link each field to a different cell, you are saying to consolidate it all back down to 1 and set the the operator to InList in the web service parameter? I didn’t know you could do an InList.
LittleMalky (BOB member since 2012-03-20)
I suppose so.
Essentially, you can have a field in your block called “State”.
Then, in the web service, you would use the “INLIST” operator, and the value would be GEORGIA, FLORIDA, ALABAMA.
Good Luck.
theknowtank (BOB member since 2011-04-20)
No, this doesn’t work. I’m really out of ideas at this point.
LittleMalky (BOB member since 2012-03-20)
It SHOULD work. If you can get it to work in WEBI using a filter with multiple values, then the Web Service should work.
My advice is to get it working in the Rich Client or wherever you created the Web Services first. Test it there until you are able to get what you want. Then get Xcelsius to send whatever you need down the pipe.
Good Luck. Don’t let it beat you.
-tkt
theknowtank (BOB member since 2011-04-20)
It works when only one value is selected so i know it’s not my syntax, but if i choose two or more it brings back all blank cells. It’s like i need to have an “or” statement between the field i duplicated. It seems it’s defaulted to “and” so it doesn’t accept it.
LittleMalky (BOB member since 2012-03-20)
Can you post a screenshot of the Rich Client Web Services window, where you’re testing your WS?
theknowtank (BOB member since 2011-04-20)
have either of you looked at this post ? It is applicable to the current thread > It has a dumb title tho…so its hard to find with search.
Cairmor (BOB member since 2008-06-05)
It worked! So I concatenated everything into one cell and separated each item with a comma instead of a semi colon and changed the operator to INLIST. Before i was trying semi colon because that’s the BOBJ structure.
Thanks for your help everybody!
LittleMalky (BOB member since 2012-03-20)
theknowtank (BOB member since 2011-04-20)