Security Filter

deepblue
deepblue Member Posts: 152
edited 2007-05-16 in NAV/Navision Classic Client
Hello!

I'm trying to aplly a security filter on the Vendor table. So, I want to let the user only see the vendors with a N° that begins with 'F'.
In the Security Filter field, I've put "Vendor: N°=F*" but it doesn't work.

Do you have any idea?

Thanks!

Comments

  • Waldo
    Waldo Member Posts: 3,412
    Are you using a SQL Server based database?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • deepblue
    deepblue Member Posts: 152
    yes I'm using SQL Server based database
  • ayhan06
    ayhan06 Member Posts: 210
    * does not work with security filter.. use "f..g" instead of "f*"
  • vyanku
    vyanku Member Posts: 791
    Vendor: N°=F..g

    Hi , Will u please tell me what is this mean??[/quote]
  • Waldo
    Waldo Member Posts: 3,412
    It's a range. Same as 1..10 (from 1 to 10) but then for letters/words, not numbers.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • ayhan06
    ayhan06 Member Posts: 210
    Waldo wrote:
    It's a range. Same as 1..10 (from 1 to 10) but then for letters/words, not numbers.

    definetely true :)
  • vyanku
    vyanku Member Posts: 791
    yes but what is the meaning of
    Vendor: N° :=
  • ayhan06
    ayhan06 Member Posts: 210
    filter vendors whose no s start with "f"

Categories