$search not working for external service

[David21]

Hello everyone,

I'm using cap Node.js(odata v4) with an odata v2 external API connected through a destination. The search functionality for external entities in not working, when i try to search something it returns all the records not just the searched ones. I was able to search in a single field by creating a where clause as seen in the code:

 And after some experimentation I came up with the following solution and was able to search in Multiple fields:

When I open the service endpoint for equipment entity and use URL?$search='some value' to test it, it works fine there but when I test the search in the FIORI value help dialog box it doesn't work. Any ideas why it's not working in the app & is there a better way to implement the search functionality ?

Edit: It seems that whenever I search something in the Value help's search bar, It only searches for that element in the Primary Key column(equipmentNo) and doesn't search for it in any other column i.e. ignoring the where clause. Any suggestions to solve this issue ?

 

 

[RaulM]

Hello, i have the same problem. Did u find a solution here?

[David21]

Yes, the issue was that search functionality wasnt implemented properly in the backend system( S/4HANA ). Once implemented, there was no need to set the where clause in code