Field Filter..

yuppicide · 2006-06-29

Our office uses Navision 3.10.

I want to know how to filter a field. Here's my scenerio:

I go into Sales & Receivables, then Customers, then pull up the list of all our customers.

Some of our customers have a name like "Target Corporation" for example.

Others are designated like "Target Corporation *****".

Some are "Target Corporation +++++".

We use the ++'s and **'s to designate that a company is a certain thing.

How can I filter a field to only show me the ones which have a + in their name?! I need to export all those out of Navision and paste them into Excel without doing a lot of deleting.

Otherwise I'd have to copy our whole list into Excel, then delete everything that does not have a + in the name and that will take me awhile with about 2000-2500 customers in our database.

kriki · 2006-06-29

filter : "Target Corporation *+*".

yuppicide · 2006-06-29

That was quick/easy. Thank you very much.

yuppicide · 2006-06-30

I'll ask this now incase I want to do it later.

*+* makes all the ++++ accounts show up.

What will make all the accounts like "Target Corporation ****" show up?! I can't field filter for *** -- is there anything that will do that?! If it was my choice I wouldn't have put ****, but they've been doing it for many years.

ara3n · 2006-06-30

Write a routine to update the records and use some other character such as +++. I don't it's possible since you are using wild character itself.

ara3n · 2006-06-30

You know what you can use

Target Corporation ???*

as a filter.

Savatage · 2006-06-30

ara3n wrote:

Write a routine to update the records and use some other character such as +++. I don't it's possible since you are using wild character itself.

"~" works good!

kriki · 2006-06-30

Savatage wrote:

ara3n wrote:

Write a routine to update the records and use some other character such as +++. I don't it's possible since you are using wild character itself.

"~" works good!

Actually I tried it, but it didn't work (with a SQL DB).
Maybe it only works on a Navision DB.

Savatage · 2006-06-30

interesting :-k

ara3n · 2006-06-30

kriki wrote:

Savatage wrote:

ara3n wrote:

Write a routine to update the records and use some other character such as +++. I don't it's possible since you are using wild character itself.

"~" works good!

Actually I tried it, but it didn't work (with a SQL DB).
Maybe it only works on a Navision DB.

There certain filters do do not work on SQL but work on Native. I don't think there is a document that explains the difference in terms of filters between sql and native.

Field Filter..

Comments

Categories