[stokie123]

Hi All,

Apologies for such a remedial question but I am having real difficulties in trying to link the opportunity to either the notes system of notes system custom. I have the Enterprise Reporting View manual but this is hardly helping me at all.

Thank you,

Si
This is a cached copy. Click here to see the original post.

[elena]

RE: Getting the opportunity system notes

You need to join TRANSACTIONS view with NOTES_SYSTEM_CUSTOM view using a join like this:

transactions.transaction_id = notes_system_custom.transaction_id

like in this query:

select transactions.tranid, notes_system_custom.*

from transactions, notes_system_custom

where transactions.transaction_id = notes_system_custom.transaction_id and

transactions.transaction_type = ‘Opportunity’

order by transactions.tranid, time_entered

[Author]

Posts