Questions tagged [filters]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
58 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 ...
3
votes
1answer
88 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
33 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
1answer
519 views

Date Filter with AMPScript

I am trying to pull out Tracking Event data, using the "TrackingEvent" Object Type. I need to find tracking event data for a subscriber within the last 30 days. How do I create a simplefilterpart ...
0
votes
0answers
30 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)
11
votes
2answers
2k views

Lightning - retrieve picklist values available for RecordType

How can I show only picklist values allowed for a specific Record Type? For example: Case.Status values are "Pending", "Open", "Closed" Case RecordType1 only allows the Pending value Case ...
1
vote
1answer
1k 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 ...
0
votes
1answer
131 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 ...
3
votes
1answer
245 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 ...
0
votes
0answers
65 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 ...
0
votes
2answers
709 views

Filtering two Data Extensions against each other

I'm trying to create a filtered Data Extension where the source Data Extension filters out records using corresponding records in another Data Extension. Does anyone have any idea on how to do this? ...
1
vote
1answer
53 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 ...
2
votes
3answers
8k views

Relative Date Value (THIS WEEK,NEXT WEEK,LAST WEEK)

I have below filter in List view for my custom object and client's locale is US English. Scheduled Date equals THIS WEEK List view retrieves all records with scheduled date from Sunday to Saturday....
0
votes
1answer
379 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
141 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
426 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
0answers
97 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 ...
2
votes
1answer
28 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
72 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
40 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
77 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
20 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 ...
4
votes
1answer
1k 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 ...
0
votes
2answers
365 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 ...
0
votes
1answer
307 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
100 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
733 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
41 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
1answer
28 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 ...
1
vote
1answer
214 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. ...
1
vote
0answers
176 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 ...
7
votes
3answers
2k views

ENTERING_MANAGED_PKG logging level

I want to debug a test method, but the debug log is mostly taken up by "ENTERING_MANAGED_PKG" lines. In the Setting Debug Log Filters page, it suggests that this line is only shown if "Apex Code" is ...
-2
votes
1answer
374 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 ...
1
vote
1answer
133 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 ...
11
votes
2answers
2k views

How to Report a Salesforce Issue

While creating report in Salesforce, we can add the date filter to filter the records. This is allowing from date as today and to date as past date. The Salesforce should throw validation error in ...
0
votes
1answer
357 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
2answers
379 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
310 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
vote
0answers
32 views

Can we restrict the fields to filter in Products Lookup Dialogs?

Hi, In the above image of lookup dialog window of Products object(Standard), I have to filter the records by using filter by. Here I want only selected fields to be visible in the dropdown but not all ...
0
votes
2answers
1k 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.
-1
votes
1answer
128 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
1answer
377 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 ...
0
votes
1answer
184 views

Multi join filters

I would like to run a filter that involves data from more than one data extension. Eg. I have three Data Extensions A, B, C and I would like to filter A by an attribute of C but A and C have not ...
1
vote
0answers
29 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 ...
0
votes
1answer
35 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 ...
1
vote
1answer
164 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
1answer
204 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 ...