Filtering Data on a Microsoft Dynamics NAV Page
You can use filters to view specific data on a Microsoft Dynamics NAV page based on a given criteria. Microsoft Dynamics NAV SharePoint client supports the following methods for filtering data.
| Method | See |
|---|---|
On Web Part pages, use Web Part connections to filter on a single data field. |
Connecting Microsoft Dynamics NAV Web Parts to Other Web Parts |
On pages that are displayed by using a URL, add a filter query string to the URL. |
Displaying Pages in the Microsoft Dynamics NAV SharePoint Client by Using URLs |
Add filters from the C/AL code by using the SETFILTER and SETRANGE functions on fields. |
|
On List type pages, use the Quick Filter field that is displayed at the top of the page. |
By combining these methods, you can set up multiple layers of filters for filtering on more than one data field.
Note
All filters that are defined for the page are included in the FILTERGROUP(0) of the underlying data table for the page.
Filtering Limitations Compared to the Microsoft Dynamics NAV Windows Client
The Microsoft Dynamics NAV SharePoint client has the following limitations on filtering compared to the Microsoft Dynamics NAV Windows client:
Advanced filtering on List type pages is not available.
The filter action in the action strip on ListPart type pages in page parts is not available.
See Also
Tasks
How to: Display a Microsoft Dynamics NAV Page in a Web Part
How to: Connect a Microsoft Dynamics NAV Web Part
Concepts
Connecting Microsoft Dynamics NAV Web Parts to Other Web Parts
Understanding Microsoft Dynamics NAV Web Part Connections
Developing for the Microsoft Dynamics NAV SharePoint Client