Questions tagged [filters]
The filters tag has no usage guidance.
297
questions
0
votes
1
answer
52
views
Need to find a method for an extension class that filters the a certain value of the current shown record
I am trying to find a method to query a certain dynamic value and make the results visible in the standardController.
Background: we want to display all leads who have the same date field as the ...
- 7
1
vote
1
answer
85
views
Automated Email Campaign with filtered data
In my current environment, we have multiple automated email campaigns setup in this way.
For one such campaign, there is a designated source DE which will be only be growing on demand which contains ...
- 75
2
votes
1
answer
633
views
How to make a Lightning Component in a Lightning record page visible to a subset of users?
I would like a single Lightning Record Page to have 2 components, each visible only to a specific set of users. There are a few users identified as 'beta testers' and one version of the component ...
- 321
6
votes
4
answers
26k
views
Filter in Related List using fields from related record
Here is the scenario -
I am showing related orders in opportunity page layout by using related list lightning component.
Order is having two record types - say A and B.
In the Opportunity detail ...
- 1,237
1
vote
1
answer
50
views
Enhanced Segmentation - Final send volume after exclusion
I'm busy building filtered data extensions using the new enhanced segmentation features, so that we can drag and drop segments in to our sends.
So as an example I have created 2 filtered DEs, one ...
- 37
0
votes
1
answer
699
views
preconfigure filter affecting widget with disabled apply global filters
I have embedded a wave dashboard on a visualforce page.
In my dashboard I have charts that "Apply global filters is disabled".
What happen is when I view the dashboard on the visual force page, and ...
- 79
0
votes
0
answers
18
views
View my cases and all new cases (other owner)
as an agent I need to see the tickets I managed (the owner is me) and also the new tickets (other owner). I tried to filter in the lists of views but it doesn't allow me to do what I want. Any ...
- 13
2
votes
1
answer
99
views
"Account Data Extension" with Account ID as proimary Key using for Order related Emails?
I created a "Account Data Extension" with AccountID as primary key, so every customer is just ones in the Data Extension.
Now I want to send order related Emails/Journeys. Therefore I filter this Data ...
- 21
0
votes
0
answers
1k
views
Filter Data Based On Values Matching In Two Columns
Is it possible to filter data based on values in two columns matching in Einstein Analytics? For example, I have one column named BO Qty and another named Supply Qty. If BO Qty is 1 and Supply Qty is ...
- 91
0
votes
1
answer
72
views
Filter in a 1:many relationship for one value only
we have two Data Extensions - DE1 one storing client's data and another one, DE2, storing information on with a 1: many relationship.
We now need to filter on exactly one of the values DE2 Data. ...
0
votes
3
answers
588
views
Filter Synchronized Data coming into Marketing Cloud
I am wondering if there is a way to filter data coming into marking cloud from Sales Cloud. I ask because I do not want to import Accounts that dont have email address associated with them as these ...
- 1
3
votes
1
answer
862
views
Filtering SOQL results with optional conditionals
I am creating a web component that allows users to filter the results of some data based on some optional filtering fields. In SOQL, how do you handle returning results when a filter is not set?
For ...
- 1,058
1
vote
1
answer
82
views
Retrieve a Filtered Data extension with fields of both the data extension
We are using Data Relationships as a Data Filter to retrieve data from two data extensions, but the filtered data extension has fields only that of the source data extension. What must I do so that I ...
- 65
1
vote
1
answer
266
views
Displaying related cases Email data on visualforce Page for Big Objects Data
First of all i am very new in salesforce and not have anything to do with programming however i have been trying to finish my first project by getting help online. I have created a BIG OBJECT "...
- 41
0
votes
1
answer
34
views
How to fix wrong test controller's filter by status?
public void byStatus(){
//Temporary multipicklist, because my main picklist isn't multiselected:
String temporary = jobAdvertisement.Temporary__c;
List<String> temporaryList = new ...
- 143
1
vote
2
answers
5k
views
Reports automatically and forcefully filtered by owner role (Winter 19)
Since Winter 19 release all of our reports are now being filtered by owner role automatically. We can't find a way to clear the filter, and we can't find an entry in the release notes. A Salesforce ...
- 319
0
votes
1
answer
439
views
XOR Using Filter Logic
Is making an XOR through Filter Logic possible?
I'm comparing opportunities by a custom field that is basically a date range. This field is called Selling Period and follows the format year - season. ...
- 3
1
vote
1
answer
2k
views
jquery datatables in lightning component
I have a lightning component which uses jquery datatables.User needs to filter the datatable using Stage picklist and date field.Based on the user selection(Stage and Date) then datatable needs to ...
- 13.5k
1
vote
1
answer
1k
views
Data Filters vs. Query Activities - discrepancy between the two
I'm noticing a discrepancy between running a data filter versus running a SQL query activity (containing the same logic).
Here's my data filter:
And, here's my query activity:
Finally, here are ...
- 859
1
vote
1
answer
685
views
Lightning Filter Component
We are building a component that allow user to search for list of records. Was wondering if there is a standard filter component that can be applied with the possibility to apply multiple fields and ...
- 11
2
votes
1
answer
830
views
How To Filter Recurring Last 3 months from a specific start date?
My company uses salesforce and have introduced OTE targets determined every 3 months. This started in May 2018.
I want a filter that displays the current OTE data. The commands 'LAST 3 MONTHS'. 'LAST ...
- 21
0
votes
2
answers
482
views
Handle 1 AND (2 OR 3) in Apex Query
In the List View we can see the Filter logic that enable us to handle many condition such and 1 AND (2 OR 3) . But I m not able to figure out how this logic is being handled in apex.
For example if ...
- 2,512
0
votes
1
answer
138
views
Javascript Filter In Custom Controller Not Returning Filtered Results to Visualforce Page
I have a custom controller and page with a few lines of Javascript. The functionality should work as follows: when a user enters a state or account name in the parameters, the list of accounts and ...
- 81
0
votes
1
answer
305
views
Filter for Aggregated List Results in Custom Controller
I have a custom controller with a Visualforce page that displays a list of accounts with aggregated results for each account. I want to create a filter for state and inspection date that would filter ...
- 81
0
votes
0
answers
25
views
Filter View Visibility
I have a filter view on salesforce custom object which i want to make visible for external user and not internal users profile. Selected the view for partner users, if works but still it is availbale ...
- 377
0
votes
1
answer
593
views
How to filter a objectlist in javascript by date
I have lightning controller in were I want to filter a list based on a datefield. I tried the following but end up with an empty list:
My list has 2 records:
serverList[0].Startdatum__c = 1-12-2018
...
- 2,284
1
vote
1
answer
151
views
How to approach multiple Rest queries in same method
I have written a Rest Get method where I get a response based on id like, /services/apexrest/invoices/a000X000015ABc2
How do I go about if I want to use this same method for following calls:
- GET &...
- 2,284
1
vote
1
answer
3k
views
SOQL - Query for Last Name of Contacts
I am trying to query for Contacts by Last Name. I understand the error I am receiving, but I am unsure of the cause.
I think one of the following might be the potential root causes:
Name is of the ...
- 1,999
0
votes
1
answer
234
views
How to add custom filter in salesforce views
I have created a custom object in my org and showing a custom list view for that object. Salesforce provides filter option but it contains 2-3 steps, so I want to add a drop-down to filter the results ...
1
vote
1
answer
46
views
Partner Community Records Sharing
I have a custom object on which their is a look to Account. Now i want to show all records in Service Provider Community where Custom field Account is equals to service provider's Account. I am not ...
- 377
0
votes
2
answers
1k
views
Filter on Einstein Analytics Dashboard in lightning page returns no result
Description:
Einstein Analytics dashboards integrated into Lightning Pages with filters, come with 'Modified' and '+X filters' buttons on top. In the case below we have 15 Filters applied.
15 ...
- 125
3
votes
1
answer
755
views
Filters/Decision Splits for specific rows in a Data Extension (when Contact/Subscriber has more than one row)
When a Contact/Subscriber has multiple rows in a Data Extension, I need to be able to filter and make decisions based on a specific row (i.e., the row that qualified them for the current entry into ...
- 33
1
vote
1
answer
665
views
How to filter by territory name in Lightning Experience dashboard?
I have a dashboard that contains a report, which deals with accounts and territories (Enterprise Territory Management).
I would like to add a dashboard filter for territory name, also known as label. ...
- 3,648
2
votes
1
answer
158
views
How to use subscriber status in a filtered group
I am trying to update a filtered group, which is filtered on "All Subscribers". I want to exclude subscribers with status "Unsubscribed" from All Subscribers which cant be selected in the filter, when ...
- 21
1
vote
0
answers
326
views
Marketing Cloud - How to fetch click data from measures
I am trying to fetch click data in Data Extension from measures in Email Studio but getting an error in automation studio..
Firstly I created a measures in which the condition is Click Date is After ...
-2
votes
1
answer
1k
views
Filtering JSON api response in apex [closed]
I have a json response that is got from a customer search API. This response contains multiple customer which is got according to the search request criteria. I want to filter this response including ...
- 103
1
vote
1
answer
172
views
create query and filter option is gone?
We used to have query and filter options under interactions / query activities and both options are gone.
Could you please clarify if there is a new way to create query or filters or this is due to ...
- 563
0
votes
2
answers
1k
views
Filter a data extension in SSJS with SimpleOperator IN
I am trying to filter a data extension to only return certain rows via an SSJS automation.
It works fine if I set the SimpleOperator to "equals" and the Value to a static value.
What I really want ...
1
vote
2
answers
1k
views
Deduplicate array in javascript based on id value in array
I have a array which is a collection of 2 arrays which has duplicate Id records how do I deduplicate these in javascript. Filter is my primary array to which I add opleidingfilter. Filter array ends ...
- 2,284
1
vote
0
answers
140
views
Marketing Cloud Populations - and possible use cases
So far all Sales Cloud objects are synchronised via Marketing Cloud Connector to the Synchronised Data Extensions and have no relation to each other, meaning if we want to combine different objects in ...
- 5,600
0
votes
1
answer
2k
views
How to define a field value of an object in javascript
I have an iteration over the values of a picklist in a lightning component. It dynamically generates checkboxes for every value of this picklist.
I want to be able to use the value of this picklist ...
- 2,284
4
votes
1
answer
3k
views
Variable returning undefined in javascript function
I have a lightning component with an array of checkboxes which are loaded dynamically where I select a field on account as a criteria. For test purposes I used Billingcity.
The filter works for this ...
- 2,284
0
votes
1
answer
467
views
Using Measures for Suppression of Subscribers
Weirdly I have not used Measures much. We have a requirement to not send an Email if the Subscriber has been sent that email in the past 2 days.
Previously I have used the SendLog and we queried ...
- 1,798
0
votes
2
answers
3k
views
Query the "All Contacts" table in Mobile Connect?
Is there a way to query the "All Contacts" table in Mobile Connect?
It seems the Filter does not have an filter parameter for not begins or any other way to include such search criteria.
- 5,600
-1
votes
1
answer
401
views
Filtering for dates in a lookup call via AMPScript
we need a date filtered rowset from a data extension in an user's email via AMPScript but the lookup function does not include a filter option.
The rowset we want to retrieve shall have a greater (...
0
votes
1
answer
1k
views
Can a List View be made that filters on Junction Objects?
My organization associates Users with Contacts. We have a custom junction object to establish a many-to-many relationship between Users and Contacts.
We want to allow Users to filter the Contact list ...
- 463
1
vote
0
answers
64
views
Only show the Opportunity with the highest probability per Account in Report
Tried to summarize the probability field to 'Max' but it still shows all the opps under the account (+ the one with the highest one)
I am using a standard 'opportunity' report - I do not want to ...
- 335
1
vote
1
answer
315
views
Help with filter logic
I'm trying to set up filter criteria which works, unlike what I have below.
(1 AND 2) OR (8 AND 9) OR
(1 AND 3) AND 4)) NOT (8 AND 9) OR
(1 AND 5) NOT (8 AND 9) OR
(1 AND 6) NOT (8 AND 9) OR
(7 ...
1
vote
1
answer
400
views
Is it possible to create a complex filter with php FUEL SDK?
I currently using in my project:
https://github.com/salesforce-marketingcloud/FuelSDK-PHP
I don't find any documentation on how to perform a get with a complex filter:
$myClient = new ...
- 113
0
votes
1
answer
360
views
Display filtered list in page layout
I'm trying to display a list of records related to the record being viewed on its page layout. I could see doing this either by embedding a filtered list report or by creating a custom related list ...
- 27