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

[Angelo Paglialonga]

Hi Ruben , I think you could make  a sql query joining Leads and accounts  with same email and Converted flag set to 1.
@alan if you have a suggestion you could propose a merge request what do you think?

_______________

Angelo Paglialonga
Consulente per soluzioni CRM ad alto ROI.

Telefono: 3386077866
Skype: angelo.paglialonga
Web: https://www.angelopaglialonga.com


> Il giorno 4 gen 2022, alle ore 08:29, Alan Lord <alanslists at gmail.com> ha scritto:
> 
> Not as standard I believe.
> 
> In the past I have modified a customers' system to add a lead_id column to the vtiger_account table and used an event handler (or I hacked the lead conversion process itself) to pass this information on.
> 
> This would be a useful addition to any vtiger I think.
> 
> HTH
> 
> Al
> 
> 
>> On 04/01/2022 03:00, Rubén A. Estrada Orozco wrote:
>> Hi everyone,
>> When you convert a lead into an account, the lead "disappears" from the leads module. In the database, however, the lead is still there with the flag "converted" equals to 1.
>> I have a large database and would like to determine the leads that originated certain accounts. Is that possible? I thought maybe there was an leadid field somewhere in the account, but couldn't find it.
>> Any ideas?
>> BTW Happy New Year!
>> Saludos
>> Rubén
>> _______________________________________________
>> http://www.vtiger.com/
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220104/f938b28c/attachment.html>