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.
On Web Part pages, use Web Part connections to filter on a single data field.
On pages that are displayed by using a URL, add a filter query string to the URL.
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.
|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
- The filter action in the action strip on
ListPart type pages in page parts is not available.
TasksHow to: Display a Microsoft Dynamics NAV Page in a Web Part
How to: Connect a Microsoft Dynamics NAV Web Part
ConceptsConnecting Microsoft Dynamics NAV Web Parts to Other Web Parts
Understanding Microsoft Dynamics NAV Web Part Connections
Developing for the Microsoft Dynamics NAV SharePoint Client