Flexible search Query for stringset?

[mohammed24]

Hi Experts,

I have an attribute with type as StringSet

When i am trying to fire below query. I am not getting result as the subquery is saving the value in the form of object for eg: [B@a7f02b92

 SELECT  DISTINCT {b:pk}  FROM {A AS a left join B as B on {a:ncode} = {b:ncode} and {a:qCode}  =  {b:qCode}}
 
 WHERE 
 
 {a:comp} IN ({{select {comps}  from {B}}})

IS there any possible way to convert the object to string form using flexible search query?

[arvind-kumar_avinash]

Did you check https://answers.sap.com/questions/12770772/how-to-verify-whether-a-string-exists-in-string-co.html?c... ?

[mohammed24]

I am getting the result but with some special characters due to which i am unable to get final query results..is there any way to remove them?