How to fetch the actual values from a hashcode column using SQL query.

[Former Member]

I have a collection configured in my items.xml as follows:

 <collectiontype elementtype="java.lang.String" code="StringList" autocreate="true" type="list" />

I am using the above collection type for defining one of the attributes:

 <attribute type="StringList" qualifier="emails">
     <persistence type="property" />
     <modifiers read="true" write="true" search="true"
         optional="true" />
 </attribute>

How to get the actual values using SQL query which the above attribute is holding?

[former_member620692]

Please check the solution at https://answers.sap.com/questions/12750906/how-to-retrieve-the-data-and-see-for-blob-object-c.html?c... and https://answers.sap.com/questions/12770772/how-to-verify-whether-a-string-exists-in-string-co.html?c...