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:
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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=:...
Only top scored, non community-wiki answers of a minimum length are eligible