Concat $filter not working in Odata Query

0
votes

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)."

2
odatakendo-datasource

2 Answers

0
votes

concat takes a string, I suspect you are passing it a number in your issueid.

0
votes

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.