0006176: 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))

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0006152

closed

Dowid

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

Notes
(0012588) svnbot (reporter) 2009-01-23 17:10	Repository: openbravo Revision: 12218 Author: dowid Date: 2009-01-23 17:10:26 +0100 (Fri, 23 Jan 2009) bug fixed 0006176: Alert rule "Products under stock" does not work on Postgresql --- U branches/r2.40/src-db/database/sourcedata/AD_ALERTRULE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12218&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-11-24 12:55	rafaroda	New Issue
2008-11-24 12:55	rafaroda	Assigned To	=> Dowid
2008-11-24 12:55	rafaroda	Status	new => scheduled
2009-01-23 17:10	svnbot	Checkin
2009-01-23 17:10	svnbot	Note Added: 0012588
2009-01-23 17:10	svnbot	Status	scheduled => resolved
2009-01-23 17:10	svnbot	Resolution	open => fixed
2009-01-23 17:10	svnbot	svn_revision	=> 12218
2009-03-03 17:09	psarobe	Status	resolved => closed