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: ...
- 92.1k
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 ...
- 92.1k
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 ...
- 24k
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[,...]
...
- 149k
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). ...
- 15.5k
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"&...
- 2,605
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, ...
- 642
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. ...
- 350
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 ...
- 30.3k
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.
- 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 ...
- 1,401
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.
- 1,401
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.
- 874
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 ...
- 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 ...
- 30.3k
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 (
...
- 135k
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 ...
- 2,389
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 '...
- 30.3k
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() {
...
- 1,205
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 ...
- 481k
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 ...
- 30.3k
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 ...
- 5,132
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: ...
- 14.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 ...
- 30.3k
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 ...
- 16k
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 ...
- 59.3k
2
votes
Accepted
How to create a Wave dashboard list filter?
So, after a lot of Googling, I came upon the following. First, open the dashboard. Then create a lens that does a GROUP BY for the relevant dimension. Clip it to Designer. Go to the dashboard, click ...
- 3,984
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 : ...
2
votes
Accepted
Trailhead - "Using the Report Builder" challenge. "Stage" field not available in reporting?
Try to drag and drop Stage field from the left panel onto Filters area (make sure there is no any filter in edit mode before trying this)
- 3,094
2
votes
Accepted
Remote Object Query Filter Criteria for Cross-Object Formula
Remove the quotes around true. With it like that you are checking for a string value and not a boolean value.
After talking with the OP and getting more detail into his problem the solution is:
<...
- 2,716
Only top scored, non community-wiki answers of a minimum length are eligible