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
Discussion posts and replies are publicly visible
Isn't this a duplicate of
Not Actually, though that one is the first issue we encountered and was actually fixed by changing schema. The current one is after changing schema and mapping the DB thru query entity.