Database Type not Supported by Outsystems

We are integrating our application with a Postgres external database, and one of the columns is of type Timespan. Since there is no mapping option for this type on Outsystems, we used "Time" but got the error 

We are able to select the records mapping to a text type on Outsystems but updates and inserts fail.

Are there any suggestions other than converting the type on the external database extension?

Thanks in advance. 

mvp_badge
MVP

Hi pvivacqua ,

I also connected with Postgres external database, and for timestamp type field I made the configuration below in the integration studio:



if not works, try to mark as ignore, example:


You can see more details in this link:

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Extensibility_and_Integration/Mapping_External_DB_Data_Types_to_OutSystems_Data_Types



Hope this helps.

Regards.

Hi Agno Silveira, thanks for the reply. For timestamp works fine, the problem is for the type Timespan.


mvp_badge
MVP

Okay, according to the documentation I passed, for a type that is not supported by the platform, you can try to mark it as "Ignore" in the integration studio, have you tried this alternative?

Agno thanks for the reply. I need to use this record on my application (full CRUD), ignoring is out of the question. 


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.