0017159: AD_Alert bug in alert Definition

Description

A NullPointer Exception is return when trying to navigate to the alerts shortcut from the vertical Menu

Steps To Reproduce

Define a new Alert.

SQL:
select o.c_order_id as referencekey_id,
       o.documentno as record_id,
       0 as ad_role_id,
       salesrep_id as ad_user_id,
       null as m_warehouse_id,
       o.documentno || ' should be completed in less than 1 day.' as description,
       'Y' as isActive,
        o.ad_org_id,
        o.ad_client_id,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
  from c_order o
where o.docstatus = 'DR'
and o.datepromised < now()

Filter Clause: ad_user_id = @ad_user_id@

Error (from log): ERROR: column reference "ad_user_id" is ambiguous

Proposed Solution

Workaround: Filter clause should be ad_alert.ad_user_id = @ad_user_id@

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0046453) alostale (viewer) 2012-03-15 12:49	Updating to design defect: as this was designed in this way, when fixing this issue the where clause should be parsed to identify whether alias is already in use not to duplicate it.

(0052446) AugustoMauch (administrator) 2012-09-24 21:19	Effort: 4 Impact: low Plan: mid

Issue History
Date Modified	Username	Field	Change
2011-05-13 12:30	Xpand-IT	New Issue
2011-05-13 12:30	Xpand-IT	Assigned To	=> alostale
2011-05-13 12:30	Xpand-IT	Modules	=> Core
2011-05-16 08:55	alostale	Status	new => scheduled
2011-05-16 08:55	alostale	fix_in_branch	=> pi
2012-03-15 12:49	alostale	OBNetwork customer	=> No
2012-03-15 12:49	alostale	Note Added: 0046453
2012-03-15 12:49	alostale	Type	defect => design defect
2012-03-15 12:49	alostale	fix_in_branch	pi =>
2012-09-24 21:19	AugustoMauch	Note Added: 0052446
2012-09-24 21:19	AugustoMauch	Priority	low => normal
2017-03-31 14:36	alostale	Status	scheduled => acknowledged
2017-04-10 14:34	alostale	Assigned To	alostale => platform
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base