Questions tagged [filters]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
27 views

javascript filter child object fields

I have this JSON that I'm filtering js this.filteredMisc = this.missions.filter( mission => misc?.Name?.toLowerCase().includes(evt.target.value.toLowerCase()) ...
  • 593
-1 votes
0 answers
28 views

How to customize custom object contact lookup field to display email field name also

I have a requirement to customize custom object look up filter to display contacts. Kindly please check the attached screenshot. By searching I can see contact name only. will it be possible to ...
  • 1
0 votes
1 answer
37 views

How to filter a dashboard, with reports from several objects, using a text or picklist field?

As soon as you combine reports from accounts, leads, cases, etc. in a single dashboard, the available fields with which you can create a filter are quickly reduced to just date fields. Even when you ...
-1 votes
1 answer
24 views

Adding a new field to the product index

I'm looking to add a new field to the list of indexed fields on the product index so I can use it as a filter. I haven't been able to find this option anywhere. Any help would be appreciated!
0 votes
1 answer
18 views

Report - Show Group if One Value Equals

I have a report where groups are listed with their various products: Group Number Product 1 One 1 Two 1 Four 2 One 2 Two 2 Three 3 Two 3 Four How do I filter this report to show only groups ...
-1 votes
1 answer
36 views

Report on Contacts over 40 years old / which filter?

I was asked to create a report showing contacts and one of the filters requested is only contacts who are over 40 years old. The contacts have a Birthdate field. In the report filter, I can't figure ...
0 votes
1 answer
38 views

Content Document Parent ID Salesforce

I am completely lost on how to populate a ParentID for Content Documents. I would like to find the parent record (custom object record) linked to the Content Document. I have easily sorted it in the ...
0 votes
0 answers
116 views

"The request body is either invalid or incomplete."

I'm using the analytics studio to build a dashboard right now. I put 2 reports about campaign influence, that I created via "Reports", one for customers and one for prospects. I want to put ...
  • 1
0 votes
1 answer
193 views

Dashboard filter is ignored/not working on Einstein/CRM Analytics Dashboards embed in lighting page

I embedded an analytics dashboard in a lighting page by following the steps in this article: https://www.salesforceben.com/how-to-embed-analytics-dashboards-in-salesforce-lightning-pages/. As I would ...
0 votes
0 answers
41 views

Filter available Case Contacts from the Account Contact relationship table

We would like to filter Contacts available to a Case to be based on an Account-Contact association to the Account referenced in the Case. Example: Contact Bob is associated to Accounts A, B, C, D. ...
0 votes
0 answers
28 views

Set default filters on activities

Is there a way as a system admin to set values for activity filtering for all users?
  • 1
0 votes
0 answers
20 views

Dynamic chart titles for time filter

I have a time filter for different quarters/months/years. When I select the a value in the time filter dropdown, how do I update the chart title with similar value? Currently I have bucketed the ...
  • 3,142
0 votes
0 answers
187 views

How to assign multiple values to the filter value in list views through apex code

I've an requirement where I'm adding a new filter for the list views through apex code since we have 1000+ list views in prod. Below I've added a new filter where lead status not equal to closed and ...
0 votes
1 answer
25 views

Fastest way to add a filter to many reports

I've been tasked with adding a filter to literally hundreds of reports in Salesforce. As you can imagine, this is a very cumbersome task. Currently I am simply clicking into each report and manually ...
-1 votes
2 answers
250 views

Display Product Options with the selected Configuration Picklist attribute value

New to Salesforce CPQ. Below is a scenario I am trying to implement. There is a Product Bundle "PB" which has 2 Product Options PB1 and PB2. A Configuration attribute of Type Picklist is ...
  • 1
0 votes
0 answers
178 views

Using complex filters in a WSProxy.retrieve?

I'm trying to set up a proxy retrieve to return the status of all automations that run for a particular day. My current code is var prox = new Script.Util.WSProxy(); var cols = [ "Name", &...
  • 1
0 votes
1 answer
255 views

Report Filter Date

I am looking to filter a date to show appointment dates for only this month to todays date (so not the entire month). Is there a relative date formula i can use for this? Thanks
0 votes
0 answers
117 views

For custom report types with one-to-many object relationship, how to filter *after* join

(NB: As per comments, this is specifically a technical question around Salesforce reporting capabilities.) Reports using the standard report type "Opportunities with Products" will include ...
  • 1
0 votes
1 answer
36 views

Filter do not work. What is wrong with my code?

VF page: <apex:page standardController="Position__c" extensions="PositionsForJobApplications" recordSetVar="lineitems" lightningStylesheets="true"> &...
0 votes
0 answers
129 views

Salesforce Lightning Dashboard Filters - using a list/group of users in the filter criteria

I have a lightning dashboard where I'd like to add a filter on the opportunity owner. I can use the existing logic and do something similar to Owner equals User1, User2 etc. However, I'd like to ...
  • 101
0 votes
0 answers
80 views

How to filter a data table on selecting a picklist value in aura components?

So I have got different picklists in my aura component and I want to filter the visible data on selection of some value/values. I have three picklists in my component for selecting values and I have ...
  • 1
0 votes
0 answers
155 views

LWC Filter contacts

I have the following drawback: my parent LWC shows a list of contacts with their related details. But I need to filter these contacts based on an input, typed in by the user. In this case, the channel ...
0 votes
1 answer
200 views

How to filter by custom object field?

Please help. I want to filter fields by Status, but nothing works. What am I doing wrong? Controller: public class PositionsForJobApplications { public List<Position__c> position {get; ...
-1 votes
2 answers
2k views

how to convert a list to list of lists in Javascript

I'm trying to turn a list into a list of lists. In this case I have a list similar to the following: a = [ 1, 1, 1, 2, 3, 3] and I would like to separate the same items for another list, like: a = [[1,...
0 votes
0 answers
1k views

How do I filter data related to selected field box in my lightning data table in LWC

Hello Guys._ Guys, I have an issue with my lightning datatable Current table The problem is when I want to show the data with the current broker selected, for example, if I select "Accurate ...
0 votes
0 answers
127 views

NOT IN filter does not work when querying External Object

I have an external object from which I want to retrieve certain values avoiding some other ones depending on certain conditions. The problem is that when I apply the NOT IN filter like in the ...
  • 825
0 votes
1 answer
257 views

Looking for a solution to have more than 50+ filter values ​in Dashboard

I'm building a dashboard which will have Products as one of it's filters. And there are more than 10k different values while a standard dashboard filter can only allow 50 values. Is there any work ...
0 votes
0 answers
218 views

Not able to pass a filter value to report from 'URL which navigates to a report'

I want to pass a 'parent object record id' to a URL which navigates to a 'report of child object records', and the report should be filtered out by the passed parent record Id as parameter. I'm ...
0 votes
1 answer
348 views

Dynamic Action filter not Correctly Filtering by User Role

I'm trying to hide the 'Edit CFR' button from all users with the 'NOW Engineer' Role, but with the following filter the button is still available to users who have the role: Here is the Role in ...
  • 11
2 votes
1 answer
99 views

Automated bulk refresh of filtered DEs - API or data filters?

I work for an organization with a very decentralized model, and we have 25-30 departments/teams sending out of SFMC. Each of these teams has their own set of filtered DEs (probably 30-50 per team), ...
  • 21
0 votes
0 answers
392 views

Customize list filter

I have a list filter in dashboard there I have around 50 values. Now out of 50 there are five values which ‘Japan 20’, ‘Japan20’, ‘Japan2020’, ‘Japan-20’, ‘Japan_20’. Now in list filter I want to ...
  • 109
0 votes
2 answers
198 views

how to write a query to filter the multiple input field of account

public with sharing class SearchComponent{ @AuraEnabled(cacheable=true) public static List<Account> getAccountList(String searchKey) { String key = '%' + searchKey + '%'; return [...
0 votes
0 answers
174 views

Restrict duplicate entry in Journey Builder when there is a multiple order updates in trigger

We have scenario that, we are using Trigger Data extension in journey builder as entry source. Was planned to avoid duplicates. further we came to know that there multiple orders so using journey ...
2 votes
0 answers
488 views

Filtering an Action button on a record based on active User

I am trying to display a Create a Record button only if the user looking at the page is the same user in a related user field. I currently have a formula checkbox field that is true if the active user ...
2 votes
0 answers
74 views

Capturing Filter Data on Interaction Studio

We are trying to capture the filters a user clicks on in the website and use those filters to build some form of affinity towards certain products. We tried making it a user attribute and a product ...
  • 21
-2 votes
1 answer
133 views

Filter Logic Simplification Help

Is there a way to simplify the below filter logic as it exceeds what is allowed character wise in SalesForce? I tried (1 AND 2 AND 6 AND 7 AND (5 AND 9 AND 3 OR 4)) OR (1 AND 2 AND 3 AND 8 AND 10) but ...
0 votes
1 answer
2k views

Filter list view on related object fields

I'd like to be able to filter list views with related object fields. Something that is easily feasible in reports, however I'd like to be able to do the same for list views. I have noticed in my org ...
-2 votes
1 answer
42 views

Sortable and Filterable java script for visualforce table [closed]

I have a visualforce page which displays the activities (events, tasks, notes, files) from a account in a table. Some accounts have a huge number of activities and it would be comfortable to sort or ...
  • 95
-1 votes
3 answers
390 views

Want to differentiate between two Date/Time fields without involvement of second

I have one scenario where I have to display cases in report whose lastmodifieddate is greater than closeddate So everything is working fine but there is one issue I have a case and I closed it. In my ...
0 votes
0 answers
78 views

Marketing Cloud Simple Query with filter Bad Request - Need Help

I am making the following REST GET call: https://{{et_subdomain}}.rest.marketingcloudapis.com/asset/v1/content/assets?$page=1&$pagesize=50&$orderBy=AssetType asc&$filter=AssetType.Views....
0 votes
1 answer
125 views

Need help with Subquery in parent-child relationship query

I have a query where I have to query contacts and their cases only if case status != "Completed" or "Pending". But in my Parent-child query, cases are getting retrieved ...
0 votes
1 answer
92 views

Can a created report automatically assign a subscription based on a specific filter within the report?

Can a created report automatically assign a subscription based on a specific filter within the report? For example, a report based on a ticketing system with case owners of the ticket(s) (which would ...
0 votes
1 answer
33 views

Journey not firing when adding filters

I am trying to set up a journey that our patients start when their opportunity enters a certain stage. However, I want it filtered to a specific list of treatment options. When I leave off the filters ...
0 votes
1 answer
43 views

Report Filter: Parent Case Number behaving oddly

This seems like it should be simple but I'm stuck - I don't know Salesforce very well so hoping someone here can help. I have a set of parent cases, and each of those has a number of child cases. ...
  • 121
-1 votes
1 answer
59 views

Performing filter based Queries on Salesforce using SOQL [duplicate]

I want to write an SOQL Query to ensure that contacts with the name John Johnson , together with all contacts with Last name Smith (excluding Benjamin Smith) will be selected. Please advise how to ...
  • 1
2 votes
2 answers
388 views

Is there a way to distinguish Long Text Area field or Rich Text Area field from a regular Text Area?

I need to build an interface to allow a user to filter record by the field chosen by the user. I know that I can use Text Area fields in the WHERE Clause but I can't use Long Text Area field or Rich ...
  • 14.8k
0 votes
3 answers
137 views

Salesforce Report Visibility Customization

I want to implement a feature for customizing report visibility based on a User(Logged in user) field value. For e.g - A is report of record B ; C & D are particular field values of B & User ...
3 votes
1 answer
1k views

Marketing Cloud - API - Data Extension - Filter by Date

I'm retrieving values from a Data Extension using the GET method on https://[YOUR SUBDOMAIN].rest.marketingcloudapis.com/data/v1/customobjectdata/key/[EXTERNAL_KEY]/rowset without any filter the ...
1 vote
0 answers
46 views

How to sort the Activity Panel by Profile/User on an Account?

I am a relative novice with the Salesforce interface and platform itself so if I misuse some terminology, I apologize. In my current role, I am undertaking the challenge of learning APEX and one of ...
  • 11
-1 votes
1 answer
1k views

How do I add "Closed/Lost" as filter option for opportunity status?

Why is "Closed/Lost" not showing up as an option? In the report, I know that we have opportunities that are closed/lost.

1
2 3 4 5 6