[NAV 2012 R2 WS] How to change the filter length

msinnmsinn Member Posts: 10
edited 2012-07-25 in NAV Three Tier
Hello everybody,

I'm consuming a webservice with the SOAP PHP extension as in Freddy's blog http://blogs.msdn.com/b/freddyk/archive/2010/01/19/connecting-to-nav-web-services-from-php.aspx.

I have an error when the length of the filter is over 2370 characters with ReadMultiple:
 Uncaught SoapFault exception: [a:Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException] The specification of the filter on the Customer table is too long (4012 bytes). It can take up a maximum of 4000 bytes.

or when is over 2500 characters:
Fatal error: Uncaught SoapFault exception: [a:Microsoft.Dynamics.Nav.Types.Exceptions.NavFilterException] The filter '*69263|61278|60104|60109|61246|61261|69263|61278|60104|60109|6124669263|61278|60104|60109|61246|61261|692...

I really need to set such a filter in a special situation as getting data sets from NAV(our current ERP) which are in a special context in our older ERP system.
How can I encrease the length of the filter specification?

Thank you for your help in advance

Marius

Comments

  • mihail_kolevmihail_kolev Member Posts: 379
    why don't you try temp table.
    -Mihail- [MCTS]
  • msinnmsinn Member Posts: 10
    Thank you for your time.
    I don't have the experience in order to work with temp tables in Navision, I'm really at the begin.
    What I do is to chunk my filter and merge the data from a ReadMultiple loop. It works in this special case where I have to get the filter string from another erp system.
  • mihail_kolevmihail_kolev Member Posts: 379
    msinn wrote:
    Thank you for your time.
    I don't have the experience in order to work with temp tables in Navision, I'm really at the begin.
    What I do is to chunk my filter and merge the data from a ReadMultiple loop. It works in this special case where I have to get the filter string from another erp system.

    It's possible too :)
    -Mihail- [MCTS]
Sign In or Register to comment.