Question Re: syntax for ODATA filter substringof in Technology Q&A

syntax for ODATA filter substringof

dany_charbonneau — Fri, 21 Sep 2018 18:23:13 GMT

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 !

Andre_Fischer — Fri, 21 Sep 2018 19:40:49 GMT

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.

Regards,

Andre

dany_charbonneau — Mon, 24 Sep 2018 12:55:17 GMT

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 — Mon, 24 Sep 2018 13:13:59 GMT

Ok. I have overlooked this as well.

Glad to hear that it works now ;-).

Regards,

Andre

VictorI32 — Tue, 06 Sep 2022 23:19:14 GMT

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.