Skip to main content

Questions tagged [filters]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
12 votes
2 answers
4k 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 ...
Priyanka's user avatar
  • 1,909
12 votes
1 answer
1k views

Filter empty date field in SF analytics api

Using the analytics rest api we need to add a filter to a date field to get only the records where this field is empty. In json: { "column": "Account.Date_Field__c", "operator": "equals", ...
user9876's user avatar
  • 121
11 votes
4 answers
7k 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 ...
ctrl-z's user avatar
  • 397
8 votes
3 answers
3k 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 ...
George S.'s user avatar
  • 2,740
6 votes
4 answers
28k 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 ...
Sudipta Deb's user avatar
  • 1,261
6 votes
1 answer
2k views

How can i use Now as a time filter in reports?

How can i use Now as a time filter in reports? I need to look at records whose scheduled time < Now. How can i build this?
Ganesh's user avatar
  • 799
6 votes
1 answer
1k views

Is Lookup Auto-Completion really restricted to recent items?

We are using the Salesforce search setting "Lookup Auto-Completion" which provides auto-completed options as-you-type in lookup filters on your visual force pages. The suggested results that pop-up ...
Simon Lawrence's user avatar
6 votes
1 answer
2k views

Default Asset lookup field in Cases doesn't display every Assets

One of our user noticed that the default Asset lookup field in the Case isn't displaying every Asset tied to an Account in our organization. I verified that there were no lookup filter preventing ...
jpmonette's user avatar
  • 4,440
5 votes
2 answers
4k views

Is there a way to filter rows in an Apex:DataTable?

I've been playing around with an Apex:DataTable in the past few days and would ideally like to find a way to filter out rows from the table: Without using a controller and SOQL query to feed in a ...
Cdn_Dev's user avatar
  • 213
5 votes
1 answer
23k views

How to use ORDER BY and GROUP BY together in the same query

I am trying to retrieve a list of LoginHistory for a bunch of users, but only want the most recent LoginHistory for each user. I have been trying this query, but I keep getting an unknown parsing ...
TemporaryFix's user avatar
  • 2,946
5 votes
1 answer
205 views

How to get user's permission sets in Data Repeaters filters

I have custom field (multiselect picklist) on Question object, which we use to filter the displayed records in accordance with his permissoin sets. On visualforce pages it's implemented using SOQL ...
Hleb's user avatar
  • 397
5 votes
1 answer
795 views

SOQL query in managed package doesn't filter objects

I have a SOQL query in my Apex code similar to this: List<My_Packaged_Object__c> myMethod(Set<Id> targetIds) { return [ SELECT id, name, lookup_field_a__c, lookup_field_b__c, ...
Ivan Vrtarić's user avatar
4 votes
1 answer
184 views

Why Salesforce REST API List View Describe Method returns extra values in columns list?

When I try to execute this request GET /vXX.X/sobjects/{sobjectType}/listviews/{queryLocator}/describe which is described in documentation https://developer.salesforce.com/docs/atlas.en-us.api_rest....
Patlatus's user avatar
  • 17.2k
4 votes
1 answer
2k 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 ...
Andrew's user avatar
  • 43
4 votes
2 answers
2k views

Advanced APEX: Dynamic Filters to apply within a loop

I'm not sure if this is possible but I'm hoping an APEX ninja can help me with something I want to attempt. I have a class called Process and at different entry points I intend to make a List<...
Xtremefaith's user avatar
  • 4,570
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 ...
Thomas's user avatar
  • 2,310
4 votes
1 answer
712 views

How we can find that particular object has "Notes and Attachments" related list in it

I need to find that if selected sObject has included "Notes and Attachment". Is it possible through sObject Describe? I need to filter all sObject in organisation by availability of "Notes and ...
Ashwani's user avatar
  • 22.6k
4 votes
2 answers
3k views

Visual Force lookup Filter

I have a custom visual force page that let you create a new custom object. In this page there i have a custom lookup to choose the contact. Do you know if it's possible add a Filter condition to the ...
Enry's user avatar
  • 3,726
3 votes
1 answer
1k 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 ...
BlondeSwan's user avatar
  • 1,098
3 votes
1 answer
171 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 ...
PRANAV BHARDWAJ's user avatar
3 votes
4 answers
3k views

How do I delete data from a large-volume custom object in Sandbox

We have a Sandbox environment with storage limit 2 GB, while alone Order_item__c storage amount is 1.8 GB. We are trying to delete the record using the filter Year<=2013 from ...
Sylphes's user avatar
  • 157
3 votes
3 answers
1k views

Custom object list view filter criteria does not return results

This is a pretty basic question but I have a list view that I created on a custom object that should be returning results but is not. Object B has a lookup field to Object A,. So lets say I have 2 ...
MikeInOak's user avatar
3 votes
2 answers
2k views

Filter on Accounts that currently have one product but not another

I need a report that will list out all of our Accounts currently under contract and use one product, but do not have another. I feel like there might be an easy way to do this and that I am possibly ...
Liz's user avatar
  • 149
3 votes
4 answers
5k views

How to have 2 tabs for the same object, with different default filtering?

At our company, we want to create 2 tabs for the same object and call them differently. The object in question we want to use is the Opportunity object. By default, we want one of the tab to only ...
jpmonette's user avatar
  • 4,440
3 votes
1 answer
684 views

Can i filter records in a report with a criteria similar to limit n on SOQL?

I have a report pulling out multiple child records, grouped by parent, where i want just the first child record based on created date/time. In SOQL i would use "order by CreatedDate and limit 1". ...
Ganesh's user avatar
  • 799
3 votes
1 answer
3k 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 ...
Christian Harris's user avatar
3 votes
1 answer
7k views

De-activating a Dashboard's running user removes all the Dashboard Filters. Can I recover?

You know how when you're editing a Dashboard, there's a "View Dashboard As: " field on the top right of the page? Well, for several of our dashboards a previous admin had created, she had been listed ...
smohyee's user avatar
  • 3,846
3 votes
1 answer
844 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 ...
Liz Gordon's user avatar
3 votes
1 answer
3k views

How to create a Wave dashboard list filter?

I want to use a Wave dashboard in a page layout, and I want to pass a parameter to the dashboard, to use as a filter. The documentation states "To filter by a dimension, be sure to create a list ...
Sander de Jong's user avatar
3 votes
1 answer
4k views

SOAP API: Applying filter to a retrieve data from a data extension

I am trying to apply a filter to a soap call to get some data from a data extension below is the example soap body. <soapenv:Body> <par:RetrieveRequestMsg> <par:RetrieveRequest&...
JCS's user avatar
  • 205
3 votes
2 answers
678 views

SimpleFilterPart: today's date minus 180 Days

I have to create DataFilters using SOAP API, therefore I have to define FilterPart using Java code. I can create this properly using UI and define filter as: profile attributes match "Last Purchase ...
Grzegorz Gajos's user avatar
3 votes
1 answer
8k views

Advanced Filters on Related list

We'd like to be able to create filters on related lists (like creating custom views). For example, we would like people to have the ability to filter out contacts that we've marked as Inactive when ...
sfdc's user avatar
  • 13.7k
3 votes
1 answer
2k views

Is the "filtered lookup fields per objects" limit a hard one?

In our software we have a somewhat generic object which is extended by douzens of record types (we tried to somewhat simulate object oriented class extension/inheritance). We now reached the "You ...
Robert Sösemann's user avatar
3 votes
1 answer
1k views

SimpleFilterPart on date fields (EventDate)

I'm currently using the Java bindings of the Partner API to extract unsubs, clicks, bounces and other events. This is working as expected, however I'd like to slice my requests by a date range (...
martingrayson's user avatar
3 votes
1 answer
916 views

Filter for partner user

I have a lookup on Account, this is a lookup to a Account which related to Contacts who are Community Users. I want to create a filter for Account lookup so that it only show the related to Contacts ...
Anu's user avatar
  • 3,857
3 votes
1 answer
791 views

View a Dashboard by Different Years

I have created a Sales Dashboard that shows information on Fiscal Year. However, I need the same Dashboard to display data for previous years as well. I tried to use a filter on the Dashboard, but ...
Saariko's user avatar
  • 5,610
3 votes
1 answer
237 views

custom lookup filter using GeoLocation

Does anyone have any experience of creating a "roll your own" look-up filter? Essentially i'd like to be able to use the new geoLocation functions to restrict the options available to the user e.g. ...
paul's user avatar
  • 1,502
2 votes
2 answers
11k views

Primary Contact for Account

Is there any OOTB way of having a Primary Contact for an Account? One idea is to create a custom lookup field for Primary Contact on Account object. However, it will need validation such as the ...
Shumon Saha's user avatar
  • 4,632
2 votes
3 answers
2k views

Adding filters to my page

I am creating a visual force page which display Opportunities: <apex:page standardController="Opportunity" recordSetVar="opportunities" tabstyle="opportunity" sidebar="false"> <apex:...
dublintech's user avatar
  • 4,273
2 votes
2 answers
4k views

Is it possible to create a filter using LastModifiedDate < LAST 30 MIN ??

I have a custom object which is updated very often. I need to create a lookup filter to avoid records where updated before 30 min ago. I was trying something like:
Martin Borthiry's user avatar
2 votes
1 answer
2k 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 ...
Gortonington's user avatar
  • 30.7k
2 votes
1 answer
2k views

API SOAP: Method retrieve, combine 3 or more filter conditions

I am trying to apply 3 filter conditions to a soap call to get DataFolder info. Single conditions are (as SimpleFilterPart elements): <Filter xsi:type="SimpleFilterPart"> <Property>...
Andrea Messini's user avatar
2 votes
1 answer
1k views

Filter and search is not working

This is my first post .. Please Help me. Problem is i can update my selected data .. but search and filter fields are not working .. Please guide me how can i bind my wrap class with page reference ...
SF Dev's user avatar
  • 89
2 votes
1 answer
2k views

Can I create an index on a field to speed up searching?

I have a large table (10's of millions of records), I want to be able to filter reasonable quickly, can I create an index on a field to help speed up fitlering?
Bartley's user avatar
  • 5,277
2 votes
2 answers
877 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 ...
Patlatus's user avatar
  • 17.2k
2 votes
1 answer
826 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 ...
yeselkay's user avatar
  • 321
2 votes
2 answers
9k views

Can i compare two fields in report?

I need to compare if a certain date/time field is greater than/less than another date field. Can this be done in a report without calculating the same using formula/boolean fields?
Ganesh's user avatar
  • 799
2 votes
1 answer
332 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), ...
dab70's user avatar
  • 21
2 votes
1 answer
1k 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 ...
Bob Jordan's user avatar
2 votes
2 answers
3k views

Better way to parameterize Salesforce reports

I have created a new Salesforce report, added AccountID in the filter and left it blank. Then while generating the report url I append pv0 at the end with AccountID https://mydomain.salesforce.com/...
karthikselva's user avatar
  • 2,476

1
2 3 4 5
7