Skip to Content
0
Former Member
Aug 14, 2008 at 11:07 AM

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

23 Views

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