why gorm can't using where 0 (zero) #7157

dickyjoelsaputra · 2024-08-19T07:10:18Z

dickyjoelsaputra
Aug 19, 2024

`
func (repo *ciswSaldoRepository) ListRequest(usersId []int, status []int) (res []entity.AbsenceLeave, err error) {

err = repo.Db.
	Joins("User").
	Preload("AbsenceType.Group").
	Preload("User.AbsenceSaldo").
	Preload("User.UnitKerjaDefault", func(db *gorm.DB) *gorm.DB {
		return db.Where("status = ? AND invisible = ?", true, false)
	}).Preload("User.UnitKerjaDefault.RoleAccess").Preload("User.UnitKerjaDefault.UnitKerja").
	Preload("Dates", func(db *gorm.DB) *gorm.DB {
		return db.Order("absence_date.absence_date asc")
	}).
	Preload("BackupUser", func(db *gorm.DB) *gorm.DB {
		return db.Preload("User").Preload("User.UnitKerjaDefault", func(db *gorm.DB) *gorm.DB {
			return db.Where("status = ?", true)
		}).Preload("User.UnitKerjaDefault.RoleAccess").Preload("User.UnitKerjaDefault.UnitKerja").
			Where("is_backup = ?", true).Order("leveling asc")
	}).
	Preload("ApproveUser", func(db *gorm.DB) *gorm.DB {
		return db.Preload("User").Preload("User.UnitKerjaDefault", func(db *gorm.DB) *gorm.DB {
			return db.Where("status = ?", true)
		}).Preload("User.UnitKerjaDefault.RoleAccess").Preload("User.UnitKerjaDefault.UnitKerja").
			Where("is_higher = ?", true).Order("leveling asc")
	}).
	Joins("HrdUser").Preload("HrdUser.UnitKerjaDefault", func(db *gorm.DB) *gorm.DB {
	return db.Where("status = ?", true)
}).Preload("HrdUser.UnitKerjaDefault.RoleAccess").Preload("HrdUser.UnitKerjaDefault.UnitKerja").
	Preload("AbsenceFiles").
	Where("absence_leave.user_id IN ?", usersId).
	Where("absence_leave.id IN ( SELECT absence_id FROM absence_user GROUP BY absence_id HAVING SUM ( CASE WHEN approve_status = 1 THEN 1 ELSE 0 END ) = COUNT ( * ) )").
	Where("absence_leave.cancel_at IS NULL").
	Where("absence_leave.hrd_status IN (?)", status).
	Find(&res).Error
if err != nil {
	return res, err
}

return res, nil

}

`

so this is my status :
`
cisw, err := c.CiswSaldoRepo.ListRequest(users, []int{0})
if err != nil {
return nil, &entity.GeneralError{
ErrorUser: err,
ErrorServer: err,
}
}

`

and i got 500 errors at Where("absence_leave.hrd_status IN (?)", status) , im trying to use Where("absence_leave.hrd_status = ?", 0)

still got the 500 erros , when i try NULL and change it to 0 via pgsql , its fine

`

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

why gorm can't using where 0 (zero) #7157

{{title}}

Replies: 0 comments

Select a reply

why gorm can't using where 0 (zero) #7157

dickyjoelsaputra Aug 19, 2024

Replies: 0 comments

dickyjoelsaputra
Aug 19, 2024