Sorry I'm reposting my queryvar clickQuery = xtk.queryDef.create(       <queryDef schema={vars.targetSchema} operation="select" >          <select >                                                          <node expr="distinct(@journalDistributionID)" alias="@clicksJD_id"/>            <node expr="da...

Hi,I have the following queryvar clickQuery = xtk.queryDef.create(       <queryDef schema={vars.targetSchema} operation="select" >          <select >                                                          <node expr="distinct(@journalDistributionID)" alias="@clicksJD_id"/>            <node expr="d...

Awaiting a reply!

Thanks Adhiyan. I just have one more question may be related or unrelated to this thread. I wanted to know which is the broadLog ID in1.eventHisto table2.trackingLogEventHisto tableRegards,Priyanka

Hi Adhiya,Thank you. Which schema has broadLog ID and tracking details together?Regards,Priyanka

Hi,How is delivery ID different from broadLog ID?Regards,Priyanka

Thanks Amit for your prompt reply. But I need to know for which emails the clicks and opens happened. For this I would need broadLog id.Any clue? Regards,Priyanka

Hi Adhiyan,Thanks for your kind reply. But my use case is the following.for a particular date  and for a particular journal id ( I'm working for an paper publishing company ), I want to display the number of emails sent, no of unique clicks happened on the email, no of unique opens in the following ...

Awaiting an answer pls!Regards,Priyanka

Hi,Your help would be appreciated. I have the following query to display the unique opens . Unfortunately count distinct (for broadlog id)is not working. Is there any other way to achieve this.var opensQuery = xtk.queryDef.create(       <queryDef schema="nms:trackingLogEventHisto" operation="select"...