Hot answers tagged

11

If you click on 'Learn More' top left of the Issues page it will take you to the Issues FAQ. What Can I do If I Do Not See My Issue Here? How Can I Report a New Issue? Contact Salesforce Support if you have questions about an Issue affecting your Organization which is not listed here.


9

I don't want a SOQL query slowing down the page It doesn't matter if it's your query or salesforce's query - a query needs to be run in order to get data to be displayed in your table. I can accomplish this via controller/SOQL and via an html table with outputPanels having a conditional render around data rows. If your query includes only the rows which ...


6

First I would add a formula field: Is_Alpha__c = IF(CONTAINS("A:B:C:D:E:F:G:H:I:J:K:L:M:N:O:P:Q:R:S:T:U:V:W:X:Y:Z", UPPER(LEFT(My_Field__c, 1))), "Yes", "No") Then your "other" query has a where clause of: WHERE Is_Alpha__c = 'No'


6

You must put GROUP BY before ORDER BY. Take a look at SOQL SELECT Syntax: SELECT fieldList [subquery][...] [TYPEOF typeOfField whenExpression[...] elseExpression END][...] FROM objectType[,...] [USING SCOPE filterScope] [WHERE conditionExpression] [WITH [DATA CATEGORY] filteringExpression] [GROUP BY {fieldGroupByList|ROLLUP (...


5

Any special reason why you need a custom lookup field on Account? That's what AccountContactRole object is for (as you mentioned in the question). It's a junction object though (has 2 masters) which means you can't make a lookup to it (similar to OpportunityContactRoles, OpportunityLineItems etc). If you need it really as lookup (to use in some formulas I ...


5

I think the only way to do the is to create a custom controller (either stand alone or extending the standard controller) and perform your filtering there.


5

I've used it earlier and it calculates itself based on the days in the month. So, it does not default to 30 days and adjusts based on the days in the month (I believe it handles leap year as well). You can run a quick test to verify it before you automate it. Unfortunately, this is not very well documented in SFMC guides.


5

The SOAP logic will look something like this after combining the ComplexFilterParts and SimpleFilterParts. <Filter xsi:type="ComplexFilterPart"> <LeftOperand xsi:type="ComplexFilterPart"> <LeftOperand xsi:type="SimpleFilterPart"> <Property>IsActive</Property> <SimpleOperator>equals</...


5

Boy, your AND's are confusing, nevertheless if by match you mean their result is true then you should try something like this - Essentially, I want the filer logic to alert when 1 AND 2 match, only if 8 AND 9 do not match ( (1 AND 2) AND NOT (8 AND 9) ) This is only for the first case, I am hoping you can do the same for the rest.


5

This is a great opportunity to apply Dynamic SOQL. Here's one way to approach it. Start with a query template string, with placeholders for your dynamic entries: String queryTemplate = 'SELECT [your list of fields] FROM Student__c {1} {2}'; We'll dynamically construct the content of the WHERE clause based on data. We'll use an extra merge field to allow ...


5

This should be done via query activity as this will result in a non-performant Filter activity being created. This will pull against the full scope of each data view referenced by the query activity. From a "why it doesn't work" perspective of making measures/filters like this the methodology being used here is opposite what is expected. Not open or ...


5

You cannot do this in salesforce lightning - Aura or LWC. Below are the options that works in salesforce lightning Aura Option 1: Have filtered logic in Javascript and use it in Component. This is preferred. CONTROLLER: let myFullObject = { myList: [...], }; myFullObject.myFilteredList = myFullObject.myList.filter(element => ...); component.set("v....


4

Unfortunately, no. The Report Builder does not provide a LIMIT option. This will require doing your report through other means, whether a Visualforce page with SOQL or exporting the data to a different system. You may be able to find something in the AppExchange.


4

You can submit a Case through the Salesforce Success Community to have Salesforce index a field. Also, assigning a field as an ExternalId will index it. EDIT: Found the documentation regarding External IDs: Working with Very Large SOQL Queries


4

I see that the code where you find actual accounts is not returned in wrapper format public pagereference Search() { String finalSearchValue = '%' + fullname + '%'; Accounts = [Select Id, Name, Active__c FROM Account where Name like :finalSearchValue]; wraplist = new list<wrapData>(); for(...


4

Francesco. Great questions! First, for example’s sake, let’s pretend you just added 100 subscribers to your subscriber_all data extension, and you know at least some of them qualify for the filter/filtered data extension you are sending to. If you send an email to a filter, the filter is run at the time of send. Therefore, those subscribers you just ...


4

You have to check by hidden boolean field.


4

Service Contract object list view doesn’t have the Filter by Owner option for now.However, as a workaround, you can create a custom formula field in that object with checkbox as the return type and use the below formula: IF( OwnerId = $User.Id, TRUE,FALSE) The checkbox will return TRUE if the running user ID is equals to Record Owner ID, otherwise it will ...


4

The issue here is that when the SQL query runs, it excludes all records that have a blank value for an email address. When the data filter executes, it includes blank values for email addresses.


4

You are getting that result is because in the system, tags are created per device & app and one contact can have multiple tags. So behind the scenes the filter essentially finds contacts with all of the tags AND returns as long as one of the tags has a value "fishing". To achieve your goal, here is an alternative: Create two lists: list 1) value = ...


4

This is very feasible. You would just need to create child nesting conditions inside your drag and drop filter settings. See below screen shot for example: To do this, you click on the little grey boxes at the end (highlighted part in image). This will create a 'nested conditional' inside of your overarching conditions.


3

I can confirm that this indeed happens inside namespaced packaging orgs (= the developer org of a managed package). I have the same problem with two of our managed ISV packages. Even setting the Debug Logging Level to ERROR everywhere (assumption 1: Log reaches max size otherwise and skips my debugs) or setting it to FINEST (assumption 2: I should see more ...


3

Edit: You changed your question, and i'm going with eyescream here, Contact Roles are the best method to go with, instead of using a lookup filter. For future reference, here is the answer on the lookup filter question: Change your Lookup filter, to set the Account of the contact, equal to that of the current account. Put the filter on required, that way, ...


3

Create a hidden formula field on the target object, called something like "30 Mins Ago", with formula NOW() - 0.020833333. Then add filter criteria of Last Modified Date less than Field: 30 Mins Ago.


3

There is no way to use relative date filter criteria down to the minutes. The smallest increment is in days: https://help.salesforce.com/HTViewHelpDoc?id=custom_dates.htm&language=en_US You could create a formula field on the record that looked something like this IF( ( NOW()*24*60 - LastModifiedDate*24*60 ) < 30, 'True','False') And then you ...


3

If you render the page using salesforce's own query generator, you'll end up querying more data than you're going to actually render. Worse, expressions are going to build up in your view state, so large queries could have a devastating effect on your page's ability to perform at all. Finally, since you want to put the fate of your code on salesforce.com's ...


3

In salesforce you can not make two tabs of a custom object. Instead you can create a visualforce tab and use recordSetVar and other native approach to show filtered record in that tab. Sample: <apex:page standardController="Account" recordSetVar="accounts"> <apex:dataList var="a" value="{!accounts}" type="1"> {!a.name} </apex:...


3

If I understand the structure correctly, you should be able to do this using cross filters and a formula field on the Asset to get the Product Family. Create a report on Accounts and add two cross filters. 1. Accounts with Contracts where Assets Product Family = "Product Group A" 2. Accounts without Contracts where Assets Product Family = "Product Group B"


3

See Condition Expression Syntax (WHERE Clause). So (depending on the exact API names and data types of the fields) the where clause would be something close to: select ... from ... where not ( Price__c > 25000 or (Sf__c > 20 and PfNumber__c != 1 and PfNumber != 100) )


3

I believe - and more seasoned people feel free to correct me! - that Contact Builder isn't (yet) linked to Data Filters or Filtered Data Extensions. What this means is that in order to work and create the same segments in sendable DE's (or just DE's), you need to create the same data relationships inside email studio. Go to: Email Studio => Subscribers => ...


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