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

[dany_charbonneau]

Hi Andre,

Thanks for the answer, your blog was pretty useful !

I was using syntax :

substringof(FIELDNAME,'ABC')

when it should be :

substringof('ABC',FIELDNAME)

Now it work like a charm, thanks a lot !

Regards,

Dany

[Andre_Fischer]

Ok. I have overlooked this as well.

Glad to hear that it works now ;-).

Regards,

Andre