ExpandedVenture / ConnectionSphere

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

Profile Template is not being applied in workload automatic assignation #190

Open ExpandedVenture opened 2 years ago

ExpandedVenture commented 2 years ago

Email from client:

Cecy Campaign(New client), seems all profiles are not updated yet. For example: Tamara Sg https://www.linkedin.com/in/tamara-sund/
and messages are going out.

ExpandedVenture commented 2 years ago

After researching, I found the template of the pipeline has not been applied to the accounts assigned.

Here is the query I ran:

select u.username, x.create_time, u.headline, t.headline, t.summary, t.id, u.id_lnusertemplate
    from lnuser u
    join pipeline_lnuser x on (u.id=x.id_lnuser and x.id_pipeline='2FCEDAF8-B831-4AF9-AD46-CCD712AA5230')
    join pipeline p on p.id=x.id_pipeline
    join lnusertemplate t on t.id=p.id_lnusertemplate
    where u.headline<>t.headline
    order by x.create_time
ExpandedVenture commented 2 years ago

Using this query to find all the accounts affected:

select c.name, u.username, x.create_time, u.headline, t.headline, t.summary, t.id, u.id_lnusertemplate
from lnuser u
join pipeline_lnuser x on (u.id=x.id_lnuser)
join pipeline p on p.id=x.id_pipeline
join [user] e on e.id=p.id_user
join client c on c.id=e.id_client
join lnusertemplate t on t.id=p.id_lnusertemplate
where u.delete_time is null
and u.id_lnusertemplate<>p.id_lnusertemplate
order by c.name, x.create_time