Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
RTC Filter Pane quick filter error, must specify an interval
LibertyMountain
Member Posts: 94
When I open the Bin Contents list page in the Role Tailored Client and try to set a quick filter on a single Item Number, I get the following error:
(if that is hard to read, it says, "The filter '@287091*' on the Item No. field in the Bin Content table must specify an interval. You can use two permitted formats for filters that specify an interval: * A Selects values equal to A. * A..Z Selects values between A and Z, inclusive.")
I think I am using the first "permitted format for filters," and that is entering one item number. The item does exist in the Bin Content table. If I enter a range of that item to itself (287091..287091), then the filter works as I expect. I noticed also that if I put tic marks (apostrophes) around the item number, the filter works ('287091' instead of 287091). Also if I use the advanced filters on this page and enter just the item number there, it works. The error only shows if I am using the quick filter, and it seems to only happen on this page (Bin Contents list page), and only when filtering on Item No. The other quick filters like Bin Code and Location code work as expected.
I assume that there is something wrong with my page, but I am not very familiar with page design. Does anyone have any suggestions? How can I turn on a run-time debugger in RTC? Would it help for you to see the text file export of this page?
(if that is hard to read, it says, "The filter '@287091*' on the Item No. field in the Bin Content table must specify an interval. You can use two permitted formats for filters that specify an interval: * A Selects values equal to A. * A..Z Selects values between A and Z, inclusive.")
I think I am using the first "permitted format for filters," and that is entering one item number. The item does exist in the Bin Content table. If I enter a range of that item to itself (287091..287091), then the filter works as I expect. I noticed also that if I put tic marks (apostrophes) around the item number, the filter works ('287091' instead of 287091). Also if I use the advanced filters on this page and enter just the item number there, it works. The error only shows if I am using the quick filter, and it seems to only happen on this page (Bin Contents list page), and only when filtering on Item No. The other quick filters like Bin Code and Location code work as expected.
I assume that there is something wrong with my page, but I am not very familiar with page design. Does anyone have any suggestions? How can I turn on a run-time debugger in RTC? Would it help for you to see the text file export of this page?
0
Comments
funny thing is, that if you click on the Item No. column and do a 'Filter to this Value' (ALT+F3), the filter is set to the value in single quotes.
if you go on the Sales Order List it works just fine :shock:
I have a feeling that that issue comes from the fact that the Bin Content table has a function called GetCaption, which is used by the page. That function uses the GETRANGEMIN and GETRANGEMAX, which causes the error. To me it seems like an issue with the compiler, as it clearly understands that the RANGEMAX and -MIN can be the same - if you put it in single quotes :oops:
Henrik Helgesen,
President | Helgesen Consulting
about.me | LinkedIN