I need to set up a filter with a OR clausule and I don't know how to. Any Help?.

I need to set up the filter manufacturer to filters manufacturer number 34 and 37.

Dim pws As New MagentoService.MagentoService
Dim sesionID = pws.login("xxxxxxx", "xxxxxxxxxxx")
Dim result

Dim filters As New MagentoService.filters
Dim complexFilter(2) As MagentoService.complexFilter
complexFilter(0) = New MagentoService.complexFilter
complexFilter(0).key = "manufacturer"
Dim assEnt As New MagentoService.associativeEntity
With assEnt
    .key = "in"
    .value = ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿"34" OR "37"?????????????????
End With
complexFilter(0).value = assEnt

complexFilter(1) = New MagentoService.complexFilter
complexFilter(1).key = "set"
Dim assEnt2 As New MagentoService.associativeEntity
With assEnt2
    .key = "eq"
    .value = "9"
End With
complexFilter(1).value = assEnt2

filters.complex_filter = complexFilter
result = pws.catalogProductList(sesionID, filters, "0")

I think I must use the key in and use an array on value, but I can't.


1 Answer 1


For in complex filter you must specify value in coma separated format (without spaces): value = '34,37'.

  • Works perfect!!! Thanks!!! Very easy, y try with arrays, parenthesys, etc...
    – jfrubio
    Nov 19, 2015 at 11:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.