How can I create a BI report of the notes associated with a sales lead?
To create a BI report of notes associated with leads, use the following SQL query.
select * from fusion.ZMM_NOTES where SOURCE_OBJECT_CODE='LEAD'
To create a BI report of notes associated with leads, use the following SQL query.
select * from fusion.ZMM_NOTES where SOURCE_OBJECT_CODE='LEAD'