Search code examples
odatakendo-datasource

Concat $filter not working in Odata Query

Hey pls help me in odata filter with concat function: I am using following url: http://localhost:65314/ContractsWebServices/ContractsWebService/odata-contracts/VendorChangeOrderDetails/Default.GetConvertVendorChangeOrderIssues(contractId=1141)?$filter=concat(concat(IssueId, ' '), SplitIssueId) ne 422

I am getting following error: "

The query specified in the URI is not valid. No function signature for the function with name 'concat' matches the specified arguments. The function signatures considered are: concat(Edm.String Nullable=true, Edm.String Nullable=true)."

Solution

  • Datatype was mismatch in frontend code and WebApi. concat always works with string type as buddy said. in webapi, it was int after changing to string, it got fix.