Dynamics Nav(Navision)Web服务ReadMultiple日期过滤器 [英] Dynamics Nav (Navision) webservice ReadMultiple date filter

问题描述

使用Navision Web服务，如何按日期过滤.

Using the Navision webservices, how can you filter by a date.

即在SalesHeader表中，有一个"ExportedDate".我想查找尚未设置ExportedDate或在特定日期导出的所有SalesHeader.

i.e. Within a SalesHeader table there is an "ExportedDate". I would like to find all SalesHeaders where the ExportedDate has not been set or were exported on a particular date.

似乎，每当我们在日期字段上设置过滤器时，Web服务都将返回所有行或不返回任何行.

It seems that whenever we set a filter on a date field, then the webservice will either return all rows or no rows.

推荐答案

这可以完成.您必须使用与Nav Client中相同的过滤器表达式:

This can be done. You have to use the same filter expression as you would use in the Nav Client:

01012011..         would be all dates from 01.01.2011
..01012011         would be all dates to 01.01.2011
01012011..03012011 gets all dates between 01. and 03.

这篇关于Dynamics Nav(Navision)Web服务ReadMultiple日期过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！