Skip to Content
author's profile photo Former Member
Former Member

Web Service Data Provider INLIST Operator

Hi,

I'm using the Rich Client to build a Report off of a Web Service Data Source (web service was also created using WebI Rich Client) and need to filter the data coming back so that I only get certain customer ID's. Because I'm using a web service as the data source I can't access the Query Filter Pane so I'm trying to do it when calling the web service.

Here's what I've tried:

Edit Query > Query Definition Edit Settings > Message Details > CustomerID

Value: KMART; COSTCO

Operator: INLIST

Unfortunately the above doesn't work. Is it possible to filter on multiple values and if so what's the syntax?

The below syntax does work, however I need multiple customers.

Value: KMART

Operator: INLIST

Version: BO XI 3.1

Thanks,

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 28, 2011 at 03:04 AM

    Hi,

    Try dropping the space before COSTCO.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.