syntax for ODATA filter substringof

[dany_charbonneau]

Hi,

I can read the filter Odata, for instance :

$filter=startswith(FIELDNAME,'ABC')

return option = CP,

Low = ABC*

in the filter internal table in the DPC_EXT

so far so good but I cannot find the correct syntax for the substringof. According to the Odata specifications, the syntax should be :

substringof(string po, string p1)

$filter=substringof(FIELDNAME,'ABC')

but this does not work. Any idea on the correct syntax ?

Thanks !

[VictorI32]

I faced the same bug as Dany. This info may be helpful for anyone that runs into this problem:

$filter=substringof(colName,'value') eq true

The syntax above is correct from the odata spec and works correctly when calling S/4HANA Cloud odata v2 apis.

$filter=substringof('value', colName) eq true

The syntax above works when calling SuccessFactors odata v2 apis.

I had been using the same structure within the $filter param with both s4 and sfsf, so naturally I was confused when sfsf didn't work.

[Andre_Fischer · Accepted solution]

The syntax you are using looks correct.

Have you checked your implementation?

I posted the following blog with regards to more complex statements with substring.

https://blogs.sap.com/2018/06/07/how-to-get-select-options-for-a-filter-that-contains-two-substringo...

Regards,

Andre