Hot answers tagged

6

I would look into using Query Studio which is much more user-friendly and better for trial and error development work. Query Studio. It will help you as you learn and get up to speed. I'd also really recommend reviewing the query/SQL documentation that SFMC has provided because it will help understand the limitations of SQL in SFMC vs the outside world. ...


5

If your target Data Extension's primary key is just Subscriber Key, I'd expect a primary key violation since you're joining with a one-to-many relationship (MasterSubscribers -> _Click). I think you can achieve what you want without a JOIN: select m.SubscriberKey , m.EmailAddress , m.Country , m.Language , m.Gender , m.FirstName , m.LastName , m....


3

The total number of parameters you need to use in JavaScript will be the number of Apex parameters plus one for the callback. You neglected to include the required parameter, hence the error. The following change would suffice: BudgetGraphController.getBudgetData('{!JSENCODE($CurrentPage.paramEters.Id)}', function (result, event) { Note that: global ...


2

I think you're approaching the query from the opposite direction. For your script you will need a query that returns all accounts. The difference you want to make is based on whether or not the account has an opportunity that's closed lost. So add a subquery to your account query that selects all opportunities of that account that are closed lost; List<...


2

That's because the field called 'Profile' only exists on the User object. Try SELECT Id, Subject, CreatedDate FROM Event Where CreatedDate > 2020-03-02T12:00:00Z AND CreatedBy.Profile.Name='ProfileName' That's sorts out your "created by" need. Question of "visible" by certain profiles is different. SOQL query won't tell you that - not for a Profile. ...


2

I would suggest going through the Apex developer guide once. As to answer your question, it depends on the variable type. I think yours is the second case. Case 1 If your query looks like this : Product2 product_query = [Select ProductCode From Product2 Where Name = :current_sensor]; then the result accessed via (You will get QueryException if more ...


1

You can call the createable property of DescribeGlobalSObjectResult to verify whether the current user has read, create, or update access to an sObject, respectively. From the docs DescribeGlobalSObjectResult represents the properties for one of the objects available for your org.


1

You can simply extend the query in step 4 of the linked approach with a join on the _Subscribers data view based on the subscriberkey that exists in both sources to pull the email address into the target data extension. It would look something like this: SELECT a.subscriberkey, b.emailaddress from [name of MobileConnect/MobilePush filtered list name] a ...


1

Query Studio seems to run into this issue when you do not use an alias for the table. Try this: SELECT l.[Email Address] as Email FROM LIST_NAME l


1

You know what is odd about that error message? Have another look at it: Uncaught ReferenceError: a0IL000000CAaDEMA1 is not defined It has the custom object ID in the remote action from {!$CurrentPage.parameters.Id}! So it is most likely something with the SOQL query itself... global with sharing class BudgetGraphController { @RemoteAction ...


Only top voted, non community-wiki answers of a minimum length are eligible