Questions tagged [filters]
The filters tag has no usage guidance.
221
questions
0
votes
1answer
49 views
How to Refresh an existing Filtered Data Extension without Filter Activity / Automation?
I know that there is the process to create a filter definition, a filter activity and then have these run inside an automation to automatically update filters.
But this means that you need to ...
-1
votes
1answer
25 views
Can I create an AND and OR filter and apply that to a data extension
I'd like to create a Data Filter that has AND and OR conditions in it, like
x AND y AND (a OR b OR c)
I'm unable to merge two filters. Is this feasible?
0
votes
2answers
16 views
Can't pass 'greater than' or 'less than' operators in reportFilters via url
I have a lightning component that redirects to a custom report passing filters via url. This component is working inside a community and, as far as I know, you need to generate your url with a '...
0
votes
0answers
16 views
Escalation rule logic not working
I have a sequence of 4 rules in one Escalation with slightly different criteria primarily based on country. It is set to escalate on either 24 hrs or 24 & 48 based on the country. Currently, the ...
0
votes
0answers
31 views
Filter data by year w/o changes to SOQL?
Trying to filter data that is returned to me by the termination year. If any data that is pulled and has a termination date older then five years I do not want it to show up.
public static List<...
0
votes
1answer
59 views
Create a filtered list using 2 or more tags - MobilePush
We want to create a filtered list with few rules that contain few tags. I have a contact with a "fishing" tag and a "boating" tag, and another contact with only a "fishing tag". I want to create a ...
0
votes
0answers
7 views
Dashboard Filter - Pulling a different field value
On a dashboard i am creating (case object), i have added the filter options for edit date and edited by. When i select an option in the edit date filter, a filter is added to the report(s) for the ...
1
vote
1answer
40 views
Send a Second email to subscribers that didnt open 1st email sent via automation studio
I need to create an automation to:
1- Send and Email (from a created email template) to subscribers and informations from a Data Extension DocCobranca.
2- After 2 days has passed I need to make a ...
1
vote
2answers
67 views
Data Filters and Measures Error for Unique Opens
I am having an error when trying to implement a data filter using a measure I created. I am implementing this filter to create a filtered data extension. Here are the details:
I am using a data ...
0
votes
0answers
22 views
Filtering by date-field
I'm trying to create a report over "Faktura" filtering by its field "Dato for fakturering", but it's not showing up in the report maker. Can anyone explain why this is? Is there any way to fix it?
...
1
vote
1answer
37 views
Journey Builder Goal Criteria Error
I am creating a new version of an existing journey that I have as I noticed an error with the way contacts pass through (see image below):
The fluctuations of populations did not make any sense. I ...
0
votes
0answers
9 views
Grouping Filtered Records on a Visualforce Page by a Field
I have a custom object called "Availability" that has a couple of field that I'd like to display and I want to be able to filter them by a date range selected by the user through the VisualForce page ...
0
votes
1answer
20 views
Filter Opportunities with Contacts Report by Fields on Contact Lookup field
I'm looking to create a report of Opportunities with some native Opportunity filters. These Opportunities also have a custom Lookup field pointing to a Contact: Project Contact.
In the Opportunities ...
0
votes
0answers
7 views
Dashboard Filter within Tile - How to Change from “Equals” to “Contains”
there is a filter within a tile on one of my dashboards that appears to default to "Equals" and as a result, when I drill down there are no results pulling. Is there a way to change this to "Contains"?...
0
votes
0answers
18 views
How to add filter in to salesforce lightning app?
I have built an app with a geolocation feature. To easily filter the data I have used search term. But I have to add a search filter where user can easily select from the drop-down list or checkbox ...
0
votes
1answer
106 views
Search/Filter functionality in a lightning table without using jquery. Response from server side will be json
Json response:
{"rows":[{"vals":[{"val":"Abc Corp","cssClass":""},{"val":"GROUPA","cssClass":""},
{"val":"Eitan","cssClass":"responsiveHide"},
{"val":"9","cssClass":"responsiveHide"},
{"val":"$18.9K",...
1
vote
0answers
33 views
Multiple filters for same field in wave:update
I'm developing a Salesforce Aura component that updates an existing Wave Analytics dashboard whenever something changes within the component.
Those changes may affect same field with several values ...
0
votes
0answers
11 views
Annual revenue filters in the report
I'm trying to calculate the gross annual revenue for the last year. But my filters seem wrong to me. I consider the interval between starting and final dates. But what if the date started in 2017, and ...
0
votes
1answer
50 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 ...
1
vote
1answer
42 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 ...
1
vote
1answer
54 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 ...
0
votes
2answers
641 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
vote
1answer
35 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 ...
0
votes
1answer
61 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 ...
0
votes
0answers
15 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 ...
2
votes
1answer
20 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 ...
0
votes
0answers
57 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 ...
0
votes
1answer
31 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
2answers
43 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 ...
2
votes
1answer
68 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
24 views
Record Type field not visible for portal users when running a report
When running a report as a portal user, i cant see the Record Type field. The field also has no effect on Filters nor can it be added as a column.
admin (OK)
community user: (NOK)
0
votes
1answer
78 views
System.QueryException: value of filter criterion for field 'CreatedDate' must be of type dateTime
Below my code, I want to pass date value as a parameter but I facing an error as below,
message: System.QueryException: value of filter criterion for field 'CreatedDate' must be of type dateTime and ...
0
votes
0answers
41 views
Add Custome Relative filter Einstein Analytics studio
Is it possible to add another choice on the date filter? like
creating new Section Called "Date Ranges".
Under "Date Ranges" we have choices like "S1", "S2", or "S3".
If I select S1 it will filter ...
1
vote
1answer
43 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 "...
0
votes
1answer
29 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 ...
0
votes
1answer
231 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 ...
0
votes
1answer
98 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. ...
1
vote
1answer
974 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 ...
1
vote
1answer
317 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 ...
1
vote
1answer
343 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 ...
2
votes
1answer
27 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 ...
0
votes
2answers
58 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 ...
0
votes
1answer
39 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 ...
0
votes
1answer
56 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 ...
0
votes
0answers
16 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 ...
0
votes
1answer
264 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
...
1
vote
1answer
97 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 &...
0
votes
1answer
531 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 ...
0
votes
1answer
37 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 ...
