I am querying the job data view to retrieve the email details, which are part of a specific set of journey. The emails have a dynamic subject line populated through AMPScript. The query works fine except that the rendered subject line is not returned, it returns the AMPScript that was used, for example it shows the subject line as %%condition%% than 'XYZ- Your offer is here'. Would appreciate, if anyone can share any insight.
select
j.JourneyName as journey_name,
J.VersionNumber as version,
ja.ActivityName as email_name,
jb.TriggeredSendCustomerKey as TriggeredSend_ID,
jb.EmailSubject as Email_Subject_Line
from _JourneyActivity ja
join _Journey j
on ja.VersionID = j.VersionID
join _job jb
on ja.JourneyActivityObjectID=jb.TriggererSendDefinitionObjectID
where ja.ActivityType in ('EMAIL','EMAILV2')
and (j.journeyname like '%jjjj%' or j.journeyname like '%pppp%')