Problem with filter expression "*.."

Ronin666

Hello, i got a problem with a filter expression:
I want to start a report about invoices and filter that report for special invoice-id´s.
For example there is an invoice with the number D1503999, another with D1504000, and so on.
and i wanted to filter some invoices, so i set a filter like this: D1503*..

And whats the result: The report shows me all invoices from D1504000 on.
But it leaves out the number D15039999....
why that???
I thought that the filter should show me all invoices beginning with no. D15030000

Anyone knows if my filter is wrong? or is this a known problem in MBS ?

thx for help

Savatage

Does it also give you a problem if your filter is set to:
>D1503000

I don't know how many invoices appear when you type in :
D1503*..

But maybe invoice # D1503999 does appear but it's not being sorted descending by inv# but by some other field that puts this invoice in another position in the list and your missing it?

Just a thought..

Ronin666

That is the funny thing:

if i set the filter to 'D15030000..' it works...

so i don´t think that this i a sorting problem...

i forgot to post that i had this problem with Attain 3.10.

i think i will try it again with MBS 3.70 and see what happens

StephenG

The result is correct.

The '*' is a legitimate character for a CODE datatype.
So your filter is in theory filtering >='D1503*' which in a list would look like this
D1503002
D1503003
D15039999
D1503*
D1504000
D1504001

Ronin666

thx Stephen !

maybe this doesn´t solve my problem,
but now i understand why this "error" occured.

henning

good luck to england at the Euro2004 ... hopefully more luck than germany

RobertMo

understanding means a lot and it helps you setting correct filter you want:
set D1503.. if you want to show what is alphabetically >= 'D1503'.
set D1503* if you want to show everything that begins with D1503.
(the same as D1503..D1504, but the upper margin is excluded)

and yes, D1503 doesn't have to exist, if setting filter D1503.. it will find the first one that is larger than D1503.