% Wildcard selection - extract data via Query as a Web Service

[Former Member]

Hello all,

I am using Query as a Web Service to extract data through to my Xcelsius document. I have a series of charts that display summed data according to user selections within some combo boxes.

Is there any way to send through a wildcard selection, i.e. pass a " like '%' " query string somehow through to the database?

With the query that I have created:

• I have a measure value returned

• I have 4 filter objects

• I have selected the "Prompt" option for each

• Within the Data Manager, the prompt fields are assigned to cells which reference the combo box selections

When I build the query, the selections available are many (equal to, not equal to, greater than, greater than or equal to, etc), but there is no 'like' comparison.

Alternatively, is there a way that I can pass the selected parameter values, including " like '%' " if no value is selected within a dropdown, to the original measure calculations within the universe?

I hope this makes sense, let me know if I need to clarify anything. Any help would be very much appreciated.

Cheers,

Marco

[Former Member]

Very easy solution - select 'matches pattern' within the filter objects selection when building the query.

Don't know why I didn't try this earlier.

[Former Member]

Hi can you tell me how you pass the parameters to the query i am using Xcelsius 2008. And i created the web service using microsoft studio 2008.