Skip to main content
12 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: ...
David Reed's user avatar
  • 93.2k
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 ...
David Reed's user avatar
  • 93.2k
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 ...
salesforce-sas's 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"&...
David Devoy's user avatar
  • 2,615
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). ...
Gaurav Kheterpal's user avatar
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, ...
Jitender Padda's 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. ...
FreeRangeHotDogs's 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 ...
Gortonington's user avatar
  • 30.7k
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.
vladykx's user avatar
  • 386
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 ...
Ajay Prakash Dubey's 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.
Ajay Prakash Dubey's 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.
Mike Marks's 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 ...
Nan Su's 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 ...
Gortonington's user avatar
  • 30.7k
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 ( ...
Keith C's user avatar
  • 136k
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 ...
Kenneth Wagner's 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 '...
Gortonington's user avatar
  • 30.7k
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() { ...
S..'s user avatar
  • 1,215
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 ...
sfdcfox's user avatar
  • 497k
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 ...
Jayant Das's user avatar
  • 30.6k
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 ...
Brian Miller's user avatar
  • 5,222
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: ...
zuzannamj's user avatar
  • 14.4k
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 ...
Gortonington's user avatar
  • 30.7k
3 votes
Accepted

Is there a way to distinguish Long Text Area field or Rich Text Area field from a regular Text Area?

There is method in the DescribeFieldResult to determine if the field can be used as part of the filter criteria of a WHERE statement, this method isFilterable() can be used to distinguish the field ...
Patlatus's user avatar
  • 17.3k
3 votes
Accepted

Example of Filter Operator "Between" (SSJS)

If you use the SimpleOperator "between", what you need is to put an array into the Value property. E.g. I have this DE: And I want to filter out the records where its date value from 10/02/...
Duc Le's user avatar
  • 3,473
3 votes

How to filter non-related object by query

This cannot be done in a query. SOQL does not allow fields to appear on the right-hand side of a filterexpression (i.e. WHERE Field1_c = Field2__c). Even if it were possible, you wouldn't be able to ...
Derek F's user avatar
  • 62.7k
2 votes
Accepted

Initial term of field expression must be a concrete SObject

The oldMap variable does not have a member named oli. Change oldMap.oli to oldMap.get(oli.Id) and you will then have your old record from the map. To check if the value changed: if (oli....
Adrian Larson's user avatar
  • 151k
2 votes

Advanced APEX: Dynamic Filters to apply within a loop

I don't know about ninjas, but the Selector package has worked very well for me in the past when I had to apply filters. I've even had to run a similar paradigm to what you describe. One nice thing ...
Adrian Larson's user avatar
  • 151k
2 votes

Lightning - retrieve picklist values available for RecordType

I just found this for LWC, that allows you to get the picklist options for a record type https://developer.salesforce.com/docs/component-library/documentation/lwc/lwc....
Tony White's user avatar
2 votes

Lightning - retrieve picklist values available for RecordType

You can now use the UI API from your lightning component's apex controller to retrieve this information. It's not ideal because you have to use an API call into your own org, but at least it is now ...
Kyle's user avatar
  • 1,190

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