How can I fetch data from Notes/Comments related to a Lead?

1

How can I fetch data from Notes/Comments related to a Lead? I want to add it to my custom query report.

image
image1173×269 17.2 KB

1 Like
2

Hi,

Please find the query below:

select * from `tabComment`
Where reference_doctype = 'Lead'

Thanks,

Divyesh Mangroliya

2 Likes
3

Hello, I appreciate your assistance with this, but it seems that only the task I added to the Lead is showing. The Notes I added are not showing.

4

Hi,

For the Notes:

select * from `tabCRM Note`
where parenttype = 'Lead'

Thanks,

Divyesh Mangroliya

2 Likes
5

Thank you so much!!! @mangroliya