How to Query Supplier Discussion's History Table
Could anyone know how to query History Table on Discussions?
thanks.
==This is Supplier Discussions function Query==
select t.auto_number,
decode(t.status, 1, 'Close', 'Open') status,
t.subject,
t.message,
(select l.entryvalue from listentry l where t.priority = entryid(+)) priority,
(select i.item_number from item i where dp.list32 =i.id) item_number,
t.*
from discussion t, discussion_p2p3 dp
where t.subclass = 2476857 --SDS
and t.id = dp.id