I am trying to write a program that lists all released Campaigns for a specific channel. I have the channel nailed down okay! :-D
The difficulty i am finding is linking the CRM_MKTPL_ATTR table to CRM_JEST....
how can I link these two tables within CRM as I need all active campaigns with a status of I1004? Or is there another table?
I have tried using CRMD_LINK - unsuccessfully!
Can anyone help?