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
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
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 ...
- 462k
3
votes
Accepted
Marketing Cloud Query and SSJS Performance
Generally speaking, none of the SFMC APIs are built for bulk data operations -- that includes the platform languages -- AMPscript and SSJS.
Query Activities are the most performant option for dealing ...
- 29.3k
3
votes
Accepted
Can you conditionally build-up a static SOQL query in Apex?
No, there is not a way to append parts to a static query.
The use case that you describe is what dynamic SOQL was made to do.
In practice, I think that the main difference between static and dynamic ...
- 54.6k
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 ...
- 462k
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
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
1
vote
SOQL Find all Permission Sets with a given Custom Permission
SELECT ParentId FROM SetupEntityAccess
WHERE SetupEntityId IN (SELECT Id FROM CustomPermission WHERE DeveloperName ='yourCustomPermissionAPIName')
SELECT Name FROM PermissionSet where Id=:...
- 371
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
query × 1640soql × 637
marketing-cloud × 512
apex × 453
sql × 222
dataextensions × 139
automationstudio × 83
trigger × 52
visualforce × 49
dynamic-soql × 41
sosl × 41
rest-api × 37
data-views × 37
batch × 36
api × 34
governorlimits × 33
list × 30
unit-test × 28
relationships × 26
journeybuilder × 24
soap-api × 24
account × 24
error × 22
javascript × 21
email × 21