New answers tagged

0 votes

Get NPSP Address object fields in a SOQL query

I'm guessing about the data model here, but I'm assuming the npsp__Address__c object is a child of the Account object. When querying child records, you need to use the relationship api name. At a ...
  • 5,994
0 votes

Sub query result using golang from salesforce

When you are inside the salesforce it does provide the data in list format. This could be a reason since you are outside the salesforce so below are the different ways you can retrieve the cases. you ...
0 votes

Marketing Cloud Data View Question - Query returns 0 records

I was having the same problem and was able to resolve it by changing "_Subscribers" to "ent._Subscribers".
1 vote
Accepted

Error in conversion bigint to varchar SQL

Your query is failing because you are trying to store varchar data into a field which has Int/BigInt as a datatype. Do check your Data extension/ Table fields & their datatypes and the kind of ...
3 votes

Relationship query filtering

You can add a Left Inner Join: SELECT ... FROM Account WHERE ... AND Id IN (SELECT AccountId FROM Contact WHERE ...)
  • 147k
1 vote

Error in conversion bigint to varchar SQL

You can only do SELECT statements in SFMC. While the engine is based on Microsoft Transact-SQL, not all functions are supported: https://help.salesforce.com/s/articleView?id=sf.mc_as_sql_reference.htm&...
  • 29.4k
0 votes

how can I find all fields using SFMC Query Studio

Sadly * is not supported in query studio in SFMC, you must type each field manually. I find it useful to use the object explorer, and copy out the fields to excel for some formatting, then copy them ...
  • 3
1 vote

USING DATEADD but no data export to target de

There are a few potential issues with the query: It appears that the table names may be incorrect. The query references "customerfield" and "orderfield," but it's unclear if those ...
  • 13.7k
4 votes

how can I find all fields using SFMC Query Studio

In Query Studio, you have an Object Explorer on the right, where you can type in the DE name and it will show you all the fields:
  • 13.7k
0 votes

how can I find all fields using SFMC Query Studio

To find all fields of a data extension, you would need to find the data extension location and then go to there to extract data or copy and paste the data extension fields there for your SQL query for ...
  • 1,269
4 votes

Aggregate Queries: Can I return values where GROUP BY size is greater than 1?

The HAVING clause works perfectly fine for this requirement. Just remember it goes after GROUP BY. SELECT ... FROM ... WHERE ... GROUP BY ... HAVING count(Id) > 1
  • 147k
2 votes
Accepted

Embed Managed Aura component inside LWC

No. This is an X-Y Problem. You can't access the DOM of any other component, even child components, even if they're in the same namespace, unless you have that component configured as a Light DOM ...
  • 463k
2 votes
Accepted

Parentheses on Dynamic SOQL Unexpected Token '('

The problem is that dynamic queries do not allow any dot reference. So MIsMap.keySet() isn't allowed. That said, you can create a reference outside the query to hold that value. Set<Id> infoIds ...
  • 147k
0 votes

How can I merge a list and a data extension?

You can actually do this with SQL in Automation Studio. Just have it update the DE. You will need to match the primary keys and non-nullable fields: Select l.SubscriberKey, l.EmailAddress, l.ListName, ...
  • 1
0 votes
Accepted

How to add 7 business days from current day in Salesforce Marketing Cloud through Query Activity

Since you want to add 7 business days from a day so it will always be +7 days. The remaining thing to do is calculate the excluded days (weekend days) to add up. If you spend some time calculating, ...
  • 1,269
4 votes
Accepted

Do indexed fields guarantee sort optimisation?

First, let's start off by saying a lot of the engineering of databases at the scale of Salesforce, and most commercial CRMs, are typically far beyond the likes of anything other kinds of developers ...
  • 463k

Top 50 recent answers are included