New answers tagged query
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 ...
- 352
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