Skip to Content
0
Former Member
Oct 24, 2009 at 06:12 AM

Document linked to a Message

25 Views

Hi Experts,

From which table I will get the information about the document "(Invoice / Payment etc)" attached to a message/alert and how can I retrieve the document?

Scenario : I wrote a query to show alert , But it displays the same documents repeatedly . I am trying to stop this by incorporating a condition to the SQL Query, which will go and check the messages whether alert is allready send or not

Thanks and regards

Ajith G