How to filter <>*Z in Navision Database Server??

xavigepe

Hi. I want to list all my customers whose names don't finish with letter Z.
I know in SQL option I can use <>*Z as a filter, but how can I do that in Navision Database Server?.

Thanks,

willy

Hi! Try something like <>*?Z

xavigepe

No luck

Waldo

afaik ... not possible.

may be something like:
*A|*B|*C|...

:?

themave

to accomplish unusual items like this, I have added a new field to several tables, such as inventory, customer, ect.

it is a Boolean field (true, false)
I then have a non-printing report (processing only) that I run that that changes the field to either true or false, depending on the what I want.

So, to run this I would filter to mark all customers that end in Z (filter *Z in your case) to true.

Then once they are marked, I can run the report excluding those marked as true, to get the info I really want.

I know it is not what you asked, but it does accomplish what you want

Alex_Chow

xavigepe wrote:

Hi. I want to list all my customers whose names don't finish with letter Z.
I know in SQL option I can use <>*Z as a filter, but how can I do that in Navision Database Server?.

Thanks,

Hi, when using <> in filters, you will not be able to use wildcards... I'm not sure why this is, but I hope it'll be address in newer versions.

themave

deadlizard wrote:

Hi, when using <> in filters, you will not be able to use wildcards... I'm not sure why this is, but I hope it'll be address in newer versions.

that is the reason I had to come up with an alternative, It is much easier to filter when not excluding.

And I use the marker field for many things. You would be surprised at how many uses you can come up with, once you have it. Some times I use it to mark slow moving items, so I can then filter the item list and cut and past to excel. Just the slow moving items. You can run the report with a date filter to show sales meeting a criteria for a given period. and mark those records.

kine

But I assume that your solution have big problems with the locking... ;-)

of course, you can use Mark function for that. Mark all, set filter, unmark records within filter (*Z), clear filters, set MarkedOnly...

xavigepe

Thanks so much for your answers.