ODATA search error

HCL Volt MX Volt MX Forum
,
1

$filter=Atendente eq 'Rubens.Marcelo' and substringof('SFH', Detalhe)

Can anyone tell me where the error is in the ODATA searc search?

2

Hi Rubens,

According to the Volt MX Documentation (https://help.hcl-software.com/voltmx/v9.5/Foundry/voltmx_foundry_user_guide/Content/Support_for_OData_Methods.html) the substringof function takes the parameters as follows: 

$filter=substringof('colname', 'expression') eq [true|false]


In the example you provided, the parameters are in reverse order:

$filter=Atendente eq 'Rubens.Marcelo' and substringof('SFH', Detalhe)

Are you able to test reversing the parameters and test? Thank you!