Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

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

    Hi,

    Try dropping the space before COSTCO.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I vaguely recall passing multiple values to a filter via BI Services before.

      Perhaps a silly question, but I assume that you've tried commas instead of semi-colons?