Field Filter..

yuppicideyuppicide Member Posts: 410
edited 2006-06-30 in Navision Attain
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.

Comments

  • krikikriki Member, Moderator Posts: 9,086
    filter : "Target Corporation *+*".
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • yuppicideyuppicide Member Posts: 410
    That was quick/easy. Thank you very much.
  • yuppicideyuppicide Member Posts: 410
    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.
  • ara3nara3n Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ara3nara3n Member Posts: 9,255
    You know what you can use

    Target Corporation ???*

    as a filter.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • SavatageSavatage Member Posts: 7,142
    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!
  • krikikriki Member, Moderator Posts: 9,086
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • SavatageSavatage Member Posts: 7,142
  • ara3nara3n Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.