New answers tagged

3 votes

Queries on Large Object (>1 million rows) Fail to Execute

First, a full recycle bin can cause problems, because IsDeleted is not indexed. Consider hard-deleting records as you delete them with the emptyRecycleBin function. I suspect the Queueable is probably ...
user avatar
  • 434k
0 votes

how to use SSJS to extract all distinct values (may require looping) and push it to sql query in marketing cloud?

So first thing you would need to do is get the list of JobID and Email Names out of SFMC. Now COULD you do this via SSJS? Yes. Should you? NO. So my first step would be to create a DE that has these ...
user avatar
0 votes
Accepted

Query Failed Timeout in Automation

Usually writing queries on dataview will take much time to give results, try limiting the result by adding Date Filter if any, else create DE and run the same query by using Automation studio.
user avatar
2 votes

How to compare values in soql query when field may have a different format

I had a similar situation where we need to query for phone numbers, but the phone number field can vary greatly in how people choose to enter them. (321)555-1212 vs 321-555-1212 etc I solved for that ...
user avatar
  • 750
2 votes

Lean, fast and flexible replacement for the fflib QueryFactory

It might be useful for you to include what features you're looking for in a query builder in your question. Because it's not obvious to me what you would need, like, dislike in a query builder. e.g. ...
user avatar
  • 12.8k
0 votes

Can someone explain me the difference between these two queries [Select a.Name From account a] and [Select Name From account ]

Alias notation in SOQL statements are used to distinguish different object used in a single SOQL Statement. To establish the alias, first we should identify the object and then specify the alias. In ...
user avatar
0 votes

Need help with a SQL query to marry Click and Subscriber data

Answering based on RDBMS sql knowledge. Inner Joins needs to be together and must come before where clause. You have added a where clause in between them.
user avatar
  • 1,600

Top 50 recent answers are included