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

[Alan Lord]

I've never tested this theory, but also, it "might" be possible to work 
out some of these (maybe not 100%) by some clever queries and data 
analysis of modtracker plus the lead and account tables... think last 
modified time of the lead and created time of the account etc...

Al


On 04/01/2022 11:28, Alan Lord wrote:
> 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/