New answers tagged query
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 ...
- 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 ...
- 28k
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.
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 ...
- 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. ...
- 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 ...
- 607
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.
- 1,600
Top 50 recent answers are included