Disable filter
Alkro
Member Posts: 115
Is possible to disable filters in a Form.
With code, i apply one filter and i want Users can't apply other filters only in this form.
How?
With code, i apply one filter and i want Users can't apply other filters only in this form.
How?
0
Answers
-
Alkro wrote:Is possible to disable filters in a Form.
With code, i apply one filter and i want Users can't apply other filters only in this form.
How?
Use FILTERGROUP.
FILTERGROUP(0) is standard user editable filter set.
FILTERGROUP(2) is used for forms
Check C/Side oniine help for more.
Example:
OnOpenForm:
FILTERGROUP(2);
// set your filter here
FILTERGROUP(0);
bostjanl0 -
Alkro wrote:Is possible to disable filters in a Form.
With code, i apply one filter and i want Users can't apply other filters only in this form.
How?
Whed I read your post for second time i realize, that I misread your post. :oops:
My first answer was how to prevent user to change your filter.
But you are asking, how to prevent user to use filters in general.
It is not nice, but you can use OnTimer and RESET ](*,)0 -
-
Simple!
thanks!!0 -
if you type this in OnAfterGetRecord the filter is set and the command is send to SQL Server. So the filterstatement was carried out on Server.
Better, use the following sourceForm - OnFindRecord(Which : Text[1024]) : Boolean reset; //or setrange(NotAllowedFieldsToFilter); EXIT(FIND(Which));
RegardsDo you make it right, it works too!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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
- 1.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