Composition API filter on translated columns?

Question

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?

Hanno Bunjes · Answer

Hi, 
 We will definitely add filtering capabilities. You can expect to see more in the 8.2.1 release. 
 This page explains the currently supported parameters (including the grouping capability that you mentioned): 
 https://support.oneidentity.com/technical-documents/identity-manager/8.2/api-designer-user-and-development-guide/5#TOPIC-1722944 
 
 To support your specific use case, you can add a specific API parameter + WHERE clause that does what you need. On the API method, you can add something like this: 
 
 Method.Define(...)
.FromTable("Person")
.WithParameter("CCC_WorkflowType", typeof(string), "Workflow type", isInQuery: false)
.WithWhereClause(request =>
{
 var workflowType = request.Parameters.Get<string>("WorkflowType");
 if (string.IsNullOrEmpty(workflowType))
 return null;
 // client supplied a filter value -> generate a WHERE Clause
 return request.Session.SqlFormatter()
 .Comparison("CCC_WorkflowType", workflowType, ValType.String);
})
 
 Regards 
 Hanno