Hot answers tagged

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