ExpandedVenture / ConnectionSphere

Simple Service to Start Prospecting Online
0 stars 0 forks source link

followups are not being generated when the lnuser has been removed from the pipeline #129

Closed ExpandedVenture closed 3 years ago

ExpandedVenture commented 3 years ago

image

ExpandedVenture commented 3 years ago

After deploy and run the new fix-patch, double check we are generating followups using templates belonging the right pipeline.

The query below should return 0 records:

select distinct top 1000 h.id
from lnchat h with (nolock)
join [message] m with (nolock) on m.id=h.id_message
join lnchat i with (nolock) on ( i.id_result=h.id_result )
join [message] n with (nolock) on n.id=i.id_message
where h.id<>i.id
and m.id_pipeline<>n.id_pipeline
and h.create_time > dateadd(hh, -2, getdate())
ExpandedVenture commented 3 years ago

Fixed.