Hello,

Your ProductId in Test Inputs are filled with an existing product?

Hi @vibhor Agarwal ,

i would make it easy on myself and do the conversion in the input parameter before passing in.

but that being said, it looks like you are trying to use a SQL SERVER function on an Oracle database.

In Oracle, CONVERT is not for typecasting, try using CAST instead.

Dorine

Hi,

Pass Test input value and check.

 I will suggest change the type of product Id as integer or Identifier of product if have.

Or if you passing list of id in input and checking in condition then you should use BuildSafe_InClauseIntegerList  function.

https://success.outsystems.com/documentation/11/reference/outsystems_apis/sanitization_api/

Hope this will help you.

Hi @vibhor Agarwal 

I am not sure you tried this or not but suppose your entity column is Integer type and you check with IN operator then you don't need to convert your string of ID's.

SELECT * FROM Customers WHERE CustomerID IN ('1', '2', '3');

In above example CustomerID  is primary key of Customers table, would you try the same at your side.

I hope it'll help you.

Thanks
Deep