0006152: Alert tule "Products under stock" does not work on Postgresql

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0006152

Openbravo ERP

Z. Others

public

2008-11-21 16:32

2009-04-21 11:04

Reporter

villind

Assigned To

Dowid

Priority

normal

Severity

trivial

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0006152: Alert tule "Products under stock" does not work on Postgresql

Description

The alert query has incompatible data types.

Steps To Reproduce

Activate the alert "Products under stock", and see the log

Proposed Solution

Add to number for '-1' as postgresql is considering this value as integer, not numeric.

Fixed version:

select p.M_PRODUCT_ID as referencekey_id,
       p.name as record_id,
       0 as ad_role_id,
       null as ad_user_id,
       p.name||' with minimun stock '||po.stockmin||' has stocked '||
                   (select sum(qtyonhand) as QtyStored
                       from m_storage_detail s
                       where s.m_product_id = po.m_product_id
                        and ad_isOrgIncluded(s.ad_org_id,po.ad_org_id,po.ad_client_id)!=to_number(-1)) as description,
       'Y' as isActive,
        0 as ad_org_id,
        0 as ad_client_id,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
  from m_product p,
       m_product_org po
where p.m_product_id = po.m_product_id
  and po.stockmin is not null
  and po.stockmin > (select sum(qtyonhand) as QtyStored
                       from m_storage_detail s
                       where s.m_product_id = po.m_product_id
                        and ad_isOrgIncluded(s.ad_org_id,po.ad_org_id,po.ad_client_id)!=to_number(-1))

Additional Information