Boolean column issue

App Building
1

hi i got this case

image
image1667×639 98 KB

this is a db from another system, client wants to use it, they got a column named Cotizacion, and its int type, i have a table with boolean 1 = true and 0 = false, but when im saving it it still shows true / false. How i can do to send to db 1 or 0 instead or true false?

i got this transformer to save to db


let data =  {{table4.changesetArray}}
let id = {{table4.selectedRow.id}}
let fecha_actualiza = {{ moment.tz("America/Panama").format() }}

return data.map(row => {
  return Object.assign(row, {
    
    "fecha_actualiza": fecha_actualiza,
    "usuario": {{current_user.firstName}}
    
  })
})
2

fixed by using boolean type in postgresql