Hot answers tagged

10 votes
Accepted

Filter in Related List using fields from related record

There's three options available that I know of. Use an existing, third party Lightning component that provides filtered related list functionality, such as this one from Salesforce Labs. (Disclaimer: ...
user avatar
  • 85.9k
6 votes
Accepted

Filtering SOQL results with optional conditionals

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 ...
user avatar
  • 85.9k
6 votes
Accepted

how to filter the collection used in aura:iteration

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 ...
user avatar
5 votes
Accepted

Filter and search is not working

I see that the code where you find actual accounts is not returned in wrapper format public pagereference Search() { String finalSearchValue = '%' + fullname + '%'; Accounts = ...
user avatar
5 votes
Accepted

How to use ORDER BY and GROUP BY together in the same query

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[,...] ...
user avatar
  • 142k
5 votes
Accepted

SFMC Filter Activity - Date + -

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). ...
user avatar
5 votes
Accepted

API SOAP: Method retrieve, combine 3 or more filter conditions

The SOAP logic will look something like this after combining the ComplexFilterParts and SimpleFilterParts. <Filter xsi:type="ComplexFilterPart"> <LeftOperand xsi:type="ComplexFilterPart"&...
user avatar
  • 2,585
5 votes

Help with filter logic

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, ...
user avatar
5 votes
Accepted

Data Filters and Measures Error for Unique Opens

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. ...
user avatar
5 votes
Accepted

How to Refresh an existing Filtered Data Extension without Filter Activity / Automation?

Surprisingly, there is a public facing, undocumented endpoint that will let you refresh your filtered Data Extensions as long as you have the Object ID of the Filtered DE. Below is a quick overview ...
user avatar
  • 27.8k
4 votes
Accepted

Can I create an index on a field to speed up searching?

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 ...
user avatar
4 votes
Accepted

Exacttarget - Sending email to filters VS sending email to filtered data extension

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/...
user avatar
4 votes
Accepted

Why Salesforce REST API List View Describe Method returns extra values in columns list?

You have to check by hidden boolean field.
user avatar
  • 376
4 votes
Accepted

How to create List View for Service Contract with only My Records?

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 ...
user avatar
4 votes
Accepted

Filter NULL values in reports?

If you want a not null field, just set the field not equal to blank, i.e., leave the filter value box empty.
user avatar
4 votes
Accepted

Data Filters vs. Query Activities - discrepancy between the two

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.
user avatar
4 votes

Create a filtered list using 2 or more tags - MobilePush

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 ...
user avatar
  • 41
4 votes
Accepted

Can I create an AND and OR filter and apply that to a data extension

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 ...
user avatar
  • 27.8k
3 votes
Accepted

Filter on Accounts that currently have one product but not another

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 ...
user avatar
  • 10.4k
3 votes

How to have 2 tabs for the same object, with different default filtering?

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: <...
user avatar
  • 22.2k
3 votes
Accepted

how to write formula filter and how use it in SOQL

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 ( ...
user avatar
  • 129k
3 votes
Accepted

How to use Contact Builder Data Model and Data Filters for Email Sends?

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 ...
user avatar
3 votes
Accepted

create query and filter option is gone?

SFMC has been pushing to move people off of using interactions inside email studio, so during pretty much any maintenance or 'update' that they do (Like the one done Friday), they wipe away all those '...
user avatar
  • 27.8k
3 votes
Accepted

How to approach multiple Rest queries in same method

You may build a dynamic query using if --- else if --- else, depending on the parameters in your URI. The structure will be something like this: @HttpGet global static void getinvoiceById() { ...
user avatar
  • 1,160
3 votes
Accepted

How to filter a objectlist in javascript by date

As written, you're trying to subtract numbers (02-08-2018 = -2024). Instead, you need to make sure you're using Date objects: startdate = new Date("02-08-2018") I believe you'll also need to do this ...
user avatar
  • 429k
3 votes

Filter in Related List using fields from related record

I am not able to add filter based on order record type in Opportunity page layout. You won't be able to do so as the filters available are based on your current record. In your case you have child ...
user avatar
  • 28.9k
3 votes

How to make a Lightning Component in a Lightning record page visible to a subset of users?

If you don't mind add to the User object, just create a custom checkbox field on the User called Beta Tester and then you could conditionally show components on the page based on this true/false ...
user avatar
  • 4,642
3 votes
Accepted

Filtered Data Extension bug

If you’re filtering a Sales/Service Cloud Synchronized Data Extension, and it seems that you are (some of the fields in your screenshot have __c), then you are experiencing the documented bug: ...
user avatar
  • 10.3k
3 votes
Accepted

Marketing Cloud - API - Data Extension - Filter by Date

You were very close, you need to put it in the YYYY-MM-DDTHH:mm:ss format, like you had in your second example. The difference though is that your equals is so specific it likely was not accounting ...
user avatar
  • 27.8k
2 votes

Why doesn't lookup filter work on visualforce page?

You need to display the first lookup field in the visulaforce page as Apex:inputField I had the same issue and by displayin the field in my page the second lookup with filter worked properly ! p.s : ...
user avatar

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