Wildcard issue in Query Design

[Former Member]

Hello people,

For my Design Studio Application, i need to add a restriction in my data with Query Design.

I have to restrict a voucher number in order to have only voucher which begin with "70000".

Here my restrction in Query Design :

But with this, i have no more data found...

Am i wrong with this restriction ?

Thanks all for your help.

Regards.

Jonas.

[Former Member]

Hi Jonas

is your BEx Query output gives you data?

Because you have filtered in the characteristic restriction which means that the data brought into design studio is already filtered.

If your report brings data, the design studio initial view should replicate the same.

- karthik S

[Former Member]

Hello Karthik,

Issue is on my query bex because this filter (using wildcard) brings me no data, but i can see my filter is working...

[Former Member]

I found a way out by filtering directly on a characteristic but i'm still curious to understand what is my mistake with this