Questions tagged [filters]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
29 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
84 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
41 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
84 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
21 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
323 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
101 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
797 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
43 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
29 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 ...
0
votes
2answers
395 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 ...
3
votes
1answer
265 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 ...
1
vote
1answer
244 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. ...
2
votes
1answer
75 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 ...
1
vote
0answers
186 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
1answer
408 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
134 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 ...
0
votes
1answer
390 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
405 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 ...
1
vote
0answers
103 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 ...
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 ...
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
1answer
322 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 ...
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
129 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
411 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 ...
1
vote
0answers
30 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 ...
1
vote
1answer
166 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
215 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 ...
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 ...
2
votes
1answer
303 views

Creating relationships between custom objects with data from dataloader

I've been going through this for nearly a week and can't figure it out - any ideas are appreciated. I'm trying to create a relationship between two custom objects that will eventually be populated ...
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
1answer
92 views

Can i automate the process of filters?

I have a data extension in which I have 2 columns: Email CategoryType The CategoryType column gets data like this: Category A, Category B, Category C So for email test@test.com, I can get this - ...
0
votes
1answer
416 views

Filtering records in a Napili Community Page?

I have a checkbox: Archive on a Custom object which gets checked on the records which were two hours old. I wanted to pull these records in a separate tab: Archived Records in a community page. I can ...
1
vote
2answers
5k views

Filter NULL values in reports?

How can I filter out NULL values from within the reports editor for a text field?
0
votes
1answer
117 views

How to find out the number of subscribers who match criteria?

I have Marketing Cloud synchronized with Sales Cloud for sending email communications, therefore I have all data in sync Data Extensions. When creating an audience for an Email Send, I would like to ...
3
votes
1answer
83 views

How to create List View for Service Contract with only My Records?

I want to create a custom list view for showing only my created records. As in Account or any other sobject there is an option of "Filter By Owner:" under "Step 2. Specify Filter Criteria" section but ...
0
votes
2answers
784 views

Global Search Filter Error: Picklist value does not exist

I have set up a global search filter on a custom object that includes the Record Type field. This allows our users to filter down results by Record Type. However, when choosing one of the Record ...
0
votes
1answer
1k views

Create a Complex Filter Definition via SSJS

I am looking to do a 'Create Filter Definition' (to initially create these filters) and then an iterative 'Update Filter Definition' to mostly automate our constantly changing campaign requirements - ...
0
votes
1answer
608 views

Wave Einstein Analytics filter relative dates in dataflow with filter node

I need to filter opportunities in my dataflow that have a date 'last month' to 'end of current year'. I cannot use filters in the sfdcDigest node as I am doing a couple of calculations later that need ...
0
votes
2answers
731 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? ...
0
votes
1answer
49 views

Is it possible to have degrees of separation with data relationships? [closed]

I have three data extensions: Member Info, Policy Info, and Event. Member and Policy DE's are related on a field called Account ID. The Policy and Event DE's are related on a field called Policy ...
0
votes
3answers
325 views

Filtering a Query

Is it better to create a query with filtering within the query to populate a data extension - or - do you create a query and then create a filtered extension based on your parameters? My use case is ...
4
votes
1answer
1k views

How to use Contact Builder Data Model and Data Filters for Email Sends?

Thanks in advance for any advice! Imagine we have an All Subscribers list and a few data extensions with the following attributes: All Subscribers => Subscrber Key, Email Address, First Name, Last ...
0
votes
1answer
51 views

Timing out or taking forever? RE: Journey Audience Filter

I have a Data Extension called [Users] that is 3.4MM records. I am applying filters from linked data extensions. The result should be about 4,300 records (as pulled from a query). When I test ...
0
votes
0answers
112 views

Data Filter on time

I have a data extension with a date field. I want to create a filtered data extension that filters data for the past hour. Can I create a filer that filters on the time part of the date field?
0
votes
1answer
66 views

Combine FTP and Sales Cloud data through Data Filter?

This Marketing Cloud setup is integrated with Sales Cloud via Connect and FTP import activity. So there are Contacts in separate DE's that are from FTP and there is data from SF via Synchronised Data ...
0
votes
2answers
15 views

How to use user custom field value in custom object field in filter in Reports?

I am Trying to create a report on Object__c, I have custom field(projectName__c) value on the current user. So while creating the reports, I am planning to filter like below:. Object__c....
0
votes
1answer
298 views

How to use user's custom field value or current user record value from parent(i.e: custom-obj) (single user having single record) in report filter?

I am creating a report on Object1__c. I have more than 3 users in my account. When I create a report, I am trying to filter with the value of current user's custom field value. User is the parent ...
0
votes
0answers
37 views

How to filter views with referring user?

I am trying to create list Views. I have 3 objects User, Object2 and Object3. Object2 having lookup with user & object3 having lookup with Object2. I save the object2 record with the user. ...