Test Data Manager

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Relation job_information and publish_action table in gtrep database

  • 1.  Relation job_information and publish_action table in gtrep database

    Posted Jun 05, 2019 10:22 AM
    In the GTREP database there should be a relation between the job_information and the gtrep_publish_action table. At this moment I use the 'data' field in the job_information table to derive the gtrep_publish_action.pa_ld_id  like so: SUBSTRING(data, CHARINDEX('generatorid', data)+13,CHARINDEX('jobtype',data) - CHARINDEX('generatorid', data) + Len('jobtype')-22)

    I don't think this is how TDM Portal ties these two together. Does anyone know how this is done?