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
- 305 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
How to fix strangely behaving Option FlowFilters
Miklos_Hollender
Member Posts: 1,598
So you have FlowFilters of the Option type and actually put them on a form instead of forcing the user to use the filter buttons on top of the screen. While FlowFilters of the Code type work perfectly, the strange stuff about Options is that if you type in the value, they work, but if you select it from the list, they don't.
Therefore add this into the OnValidate, on the form:
SETFILTER("Whatever Filter",FORMAT("Whatever Filter"));
(Another weirdness I found when I wanted to show a drill-down form that in the case of FlowFilters, FORMAT("Whatever Filter"::"Whatever Value") isn't 'Whatever Value', it's rather 0,1, etc. Ouch! At the end I just ended up with text constants as in this case it was only empty, No, and Yes and filtering for a Boolean field - not very nice but does the job.)
Therefore add this into the OnValidate, on the form:
SETFILTER("Whatever Filter",FORMAT("Whatever Filter"));
(Another weirdness I found when I wanted to show a drill-down form that in the case of FlowFilters, FORMAT("Whatever Filter"::"Whatever Value") isn't 'Whatever Value', it's rather 0,1, etc. Ouch! At the end I just ended up with text constants as in this case it was only empty, No, and Yes and filtering for a Boolean field - not very nice but does the job.)
0