Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
2009 R2 RTC Drop Down Search not Searching...
sil21
Member Posts: 55
We have a server running several NAV R2 databases in RTC. This problem is occuring in all databases on this server. I have not seen it in other servers.
When you are selecting a record from the drop down search list (customer for a sales order, vendor for a purchase, item on a sales or purchase line, entry for "My Customers", etc), the search only works on the first highlighted column. If you move the highlight to filter on a different column no results are returned.
Example: Start a sales order and in the Customer No field enter "The". The search box would come up with the default on the No. field and of course there woudl be no results. But, typcially, if you move the filter to be on the Name column the results should refresh and show "The Cannon Group" and "The Device Shop". This works perfectly on other NAV installs but on this one server it does not. The only way to get the results to show is to bring up the list with F4 (so all records are there) and then move the filter and type "The"
Does anyone know why this is not working properly? I'm wondering if there is some setting on the SQL that effects the searching since it happens on several databases on one server.
Thanks!
Sara
When you are selecting a record from the drop down search list (customer for a sales order, vendor for a purchase, item on a sales or purchase line, entry for "My Customers", etc), the search only works on the first highlighted column. If you move the highlight to filter on a different column no results are returned.
Example: Start a sales order and in the Customer No field enter "The". The search box would come up with the default on the No. field and of course there woudl be no results. But, typcially, if you move the filter to be on the Name column the results should refresh and show "The Cannon Group" and "The Device Shop". This works perfectly on other NAV installs but on this one server it does not. The only way to get the results to show is to bring up the list with F4 (so all records are there) and then move the filter and type "The"
Does anyone know why this is not working properly? I'm wondering if there is some setting on the SQL that effects the searching since it happens on several databases on one server.
Thanks!
Sara
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I'm sorry to say I don't remember what fixed it! I believe we installed a newer version of the exe/dlls and that resolved it. Sorry!