Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
116
Navision DOS
851
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
617
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
320
Dynamics CRM
111
Dynamics GP
10
Dynamics SL
1.5K
Other
990
SQL General
383
SQL Performance
34
SQL Tips & Tricks
35
Design Patterns (General & Best Practices)
1
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.6K
General
1K
General Chat
1.6K
Website
83
Testing
1.2K
Download section
23
How Tos section
252
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Options
Mute
Reg Filtering
smartsri
Member
Posts:
10
2007-02-19
edited 2007-02-19
in
NAV/Navision Classic Client
Hi,
I want to Filter Records from Customer table that Customer No. Should not be start with 10.
So I have put coding Like.
Cust.setfilter("No.",'<>%1','10*')
Its not working...
Anybody help me...
Sridharan
Sridharan
0
Comments
remco_rausch
Member
Posts:
68
2007-02-19
Hi,
I had a play with the filters and it seems that the * seems to not work as I expected it to.
I tried
Cust.SETFILTER("No.",'<>%1*',10);
but that shows all the records.
In the end I got it to work with as follows:
Declare a text constant:
Filter <>%1*
Cust.SETFILTER("No.",STRSUBSTNO(Filter,10));
Hope that helps,
Remco
0
Mbad
Member
Posts:
344
2007-02-19
Dont hardcode filters. Create a textfield on the appropriate setup table(would be sales & rec setup), and make the customer type in the filter. Then apply it on the form.
0
Sign In
or
Register
to comment.
Comments
I had a play with the filters and it seems that the * seems to not work as I expected it to.
I tried
Cust.SETFILTER("No.",'<>%1*',10);
but that shows all the records.
In the end I got it to work with as follows:
Declare a text constant:
Filter <>%1*
Cust.SETFILTER("No.",STRSUBSTNO(Filter,10));
Hope that helps,
Remco