Filtering option field in webservice

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am consuming webservice in PHP. Using ReadMultiple and filtering on different criterias.

Everything is ok, except i cannot find a way to filter on an option field.

array('Field' => 'Status',
  'Criteria' =>'VALUE'),
//This works

array('Field' => 'Status',//
  'Criteria' =>'<>VALUE'),
//Fails with - The value "VALUE" can't be evaluated into type Option


For an option field, the default filtering arguments that works elsewhere ( | & <> etc) is not possible to use.

In NAV gui, this is the filter value: for "_blank_" and "VALUE" =

 ; VALUE

This does not work either, also not "," instead of ";"

If someone know of a method to filter option type field in webservice, i would love some input :)


--

Regards

Kim

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report
RE: Filtering option field in webservice

Just;

array('Field' => 'Status',//

The // in red is not in the code, also, php ignores it, so that is not the issue.