edited tags

Link

edited Jun 12 at 15:13

zuzannamj

14.5k
3
27
56

Code formatting

Source Link

edit approved Jun 12 at 8:41

Arulkumar

162
1
8

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when iI run the query, nothing populates in the DE and nothing populates in the Action Log. I
I feel like I'm SO close but as I've been building out my automation I keep running into Super niche errors. Do I need a primary key? Any help would be welcome!!!

Here's my query: SELECT AccountID, OYBAccountID, JobID, ListID, BatchID, SubscriberID, SubscriberKey, EventDate, Domain, TriggererSendDefinitionObjectID, TriggeredSendCustomerKey

FROM _Sent

WHERE Eventdate > Dateadd(day, -30, Getdate())

SELECT
    AccountID, 
    OYBAccountID,
    JobID,
    ListID,
    BatchID,
    SubscriberID,
    SubscriberKey,
    EventDate,
    Domain,
    TriggererSendDefinitionObjectID,
    TriggeredSendCustomerKey
FROM _Sent
WHERE Eventdate > Dateadd(day, -30, Getdate())

Here are my DE values:

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when i run the query, nothing populates in the DE and nothing populates in the Action Log. I feel like I'm SO close but as I've been building out my automation I keep running into Super niche errors. Do I need a primary key? Any help would be welcome!!!

Here's my query: SELECT AccountID, OYBAccountID, JobID, ListID, BatchID, SubscriberID, SubscriberKey, EventDate, Domain, TriggererSendDefinitionObjectID, TriggeredSendCustomerKey

FROM _Sent

WHERE Eventdate > Dateadd(day, -30, Getdate())

Here are my DE values:

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when I run the query, nothing populates in the DE and nothing populates in the Action Log.
I feel like I'm SO close but as I've been building out my automation I keep running into Super niche errors. Do I need a primary key?

Here's my query:

SELECT
    AccountID, 
    OYBAccountID,
    JobID,
    ListID,
    BatchID,
    SubscriberID,
    SubscriberKey,
    EventDate,
    Domain,
    TriggererSendDefinitionObjectID,
    TriggeredSendCustomerKey
FROM _Sent
WHERE Eventdate > Dateadd(day, -30, Getdate())

Here are my DE values:

Source Link

asked Jun 10 at 16:50

userjlq

1

Simple Queries - Sent

I'm new to writing queries but I thought this SENT query would be simple. I'm just trying to get All sends for the last 30 days. But when i run the query, nothing populates in the DE and nothing populates in the Action Log. I feel like I'm SO close but as I've been building out my automation I keep running into Super niche errors. Do I need a primary key? Any help would be welcome!!!

Here's my query: SELECT AccountID, OYBAccountID, JobID, ListID, BatchID, SubscriberID, SubscriberKey, EventDate, Domain, TriggererSendDefinitionObjectID, TriggeredSendCustomerKey

FROM _Sent

WHERE Eventdate > Dateadd(day, -30, Getdate())

Here are my DE values:

query dataextensions sql automationstudio

Stack Exchange Network

Return to Question

Simple Queries - Sent