[Vtigercrm-developers] how to know what lead an account came form?

[Alan Lord]

On 04/01/2022 11:50, Angelo Paglialonga wrote:
> Hi Ruben , I think you could make  a sql query joining Leads and 
> accounts  with same email and Converted flag set to 1.

You would have to include modtracker to make sure you get the fields' 
value at the right moment in time - in case the field value has changed 
since.

> @alan if you have a suggestion you could propose a merge request what do 
> you think?

It would be easier now as I think I encouraged vtiger to add a lead 
conversion event. Yes, 4 years ago:

https://code.vtiger.com/vtiger/vtigercrm/commit/f9125c7eac5f1b505dc216dd68dd012cd265b6e1

An event handler would probably be all that is needed plus a column to 
record the old lead id somewhere.

Al