Rest API - How to Querying Data using "Contains"

[Rezky]

Hi Everyone,
How to get data with condition using "contains" in Rest API?

In this Idempiere Rest Wiki there are queries for filter "contains -> if a string contains another string", but when I try it I get an error like in the following image.

Thank you for your help.

Regards,
Rezky

[Diego Ruiz]

Hi Rezky,

The REST API follows the same syntax as oData.

The contains filter is used like contains(columnname,'value'). In your case $filter=contains(Name,'working')

Best regards,

Diego

[Rezky]

Hi Diego,

I really appreciate your help for the solution.

I've tried it through the API test application and it has worked successfully.

But now I got new problem when I test API before using contains I got this result.

But when I try to use 'contains' I got this error.

Thank you for your help.

Regards,

Rezky

Pada Jumat, 28 Juli 2023 pukul 10.48.37 UTC+7 Rezky menulis:

Hi Diego,

I really appreciate your help for the solution.

I've tried it through the API test application and it has worked successfully.

But now I got new problem when I test API before using contains I got this result.

But when I try to use 'contains' I got this error.

Thank you for your help.

Regards,

Rezky

[zuhri...@gmail.com]

contains is used to search string in a column. it's working like query "LIKE". if you want to filter by MP_WorkOrder_ID just used C_Bpartner_ID eq xxx AND MP_WorOrder_ID eq xxx

[Rezky]

Hi Zuhri,

Thanks for the response, yes I understand what you're saying. Sorry, maybe I explained wrong, so in the MP_WorkOrder_ID column (figure 1) we can filter "id" by using the "eq" filter. What I mean is I want to filter the "identifier" column in "MP_WorkOrder_ID". From what I already know and have tried based on the WIKI, namely by "expanding" "MP_WorkOrder_ID" like image below.

But when I try to "expand" and filter by "contains" I get the following error.

Thank you for your help.

Regards,

Rezky