Hello,
how can we use a filter on a translated column that is exposed via the HandleGetByQuery()-Method within the Composition API?
The column is configured respectively and the endpoint returns the translation in the DisplayValue:
... "CCC_WorkflowType": { "Value": "1", "IsReadOnly": true, "DisplayValue": "Master of Role" }, ...
The expectation is that calling the endpoint with a filter parameter returns the entity but it doesn't return any results, hence it seems like the filter mechanism does not consider MultLanguage translations:
[{ColumnName: 'CCC_WorkflowType', CompareOp: 'Like', Value1: 'Master%'}]
How can we achieve this?