Unable to Query a field on PostgreSql "Custom data Type" on Query Entity

Hi All,

Scenario is we are connected to a PostgreSQL that has a custom data type, from which we we're able to create a CDT on Appian end and manage to verify it on our Data Store.

for the custom data type on Postgre, we transform it to a text and it went well. However when doing a specific query to that specific field, thats where the issue persist.

Can you advice on this?

Data on Postgre

Error when doing a query on the specific field