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%')