I am trying to create an xsodata service on top of a calculation view using multiple values input parameter.
Parameter created: IP_TARGRP (Mandatory and mutiple values selected)
in the filter expression code (Column Engine) : IN("tariffGroup",$$IP_TARGRP$$)
xsodata service:
"CV_TAR_FILTER_VALUES" as "UserCompTarFilterSubValue" keys generate local "GENERATED_ID" parameters via entity "TarFiltersSubsValues" ;
XSODATA URL given:
https://hostname:port/xsodata/notifadmin.xsodata/TarFiltersSubsValues(IP_TARGRP='BULK')/Results
Error:
{ "error": { "code": 500, "message": { "lang": "en-US", "value": "Error while executing a DB query" } } }
When I pass numeric values in the input parameter it does not give any error.