Questions tagged [criteria-filter]
The criteria-filter tag has no usage guidance.
32
questions
0
votes
2
answers
105
views
Bypass lookup filter
I have a lookup filter which I want to bypass as a system administrator when doing i.e. data imports.
I found possible solutions but they dont seem to be working.
Added a second filter condition OR ...
- 2,294
0
votes
0
answers
46
views
How to filter to latest date of Opportunities on an Account
I’ve spent a good amount of time trying to figure out or find this answer -
I created a report showing fields from both Accounts and Opportunities and there are sometimes multiple Opportunities tied ...
0
votes
0
answers
44
views
how to display filtering option for picklist values to successfully get records in visualforce page,Also how to provide grouping for same record name
I am trying to build one Visualforce page where I am able to get all approval history information. But I am not able to provide users the opportunity to filter records based on "Status". ...
- 1
0
votes
0
answers
57
views
how to display filtering option for picklist values to successfully get the records in visualforce page
I am trying to build one Visualforce page where I am able to get all approval history information. But I am not able to provide users the opportunity to filter records based on "Status". ...
- 1
0
votes
0
answers
23
views
List only accounts with documents attached
I have the following query to get the list of accounts with documents attached to them. I need to filter by opportunity StageName:
select id, (Select Id, StageName From Opportunities),(Select ...
1
vote
0
answers
189
views
Show Dynamic Field Section only on Clone
When you enable Dynamic Forms, the 'New Record' form is determined by the Field Sections on your Record Page, instead of using the traditional Page Layout. I like to design custom forms when a user ...
- 355
1
vote
2
answers
15k
views
How to compare date field is lesser than today in record triggered flow?
I have create record triggered flow in which i need to filter the records based on the below conditions
Status is equal to Done and Completion Date is lesser than TODAY.
I am not able to obtain this ...
- 39
0
votes
0
answers
368
views
Error while trying to activate matching rule
I've been struggling with activating a matching rule but I keep getting this error I can't get rid of:
I have attached my matching rule with requested criteria + duplicate rule as per the ...
- 13
1
vote
1
answer
2k
views
Filtering by Date (Last 7 days) while editing data extension filter
My data extension has a date field stamped at a certain point in a journey and I need to filter it weekly to see who has been stamped in the last 7 days. I have tried a number of ways to configure the ...
- 11
0
votes
1
answer
96
views
How to filter on specific value when subquery
I am not a SOQL developer. I do have SQL experience. I have to take over a process that a non-SOQL developer who's no longer here.
I have the following query they wrote:
SELECT AccountNumber
FROM ...
1
vote
1
answer
5k
views
Using TODAY() in filter criteria field for roll-up summary
I've read that TODAY() can't be used in filter criteria for a roll-up summary. Is there any way around this? I have a field on a detail that tells whether it is from this year, last year, or longer ...
- 171
0
votes
1
answer
2k
views
I need a report filter with many account names
I have 128 Accounts. Each account name, for example "account1", has up to 50 identically named accounts for a total of 1313 unique Account IDs.
I need to run a report that lists all 1313 ...
- 1
1
vote
1
answer
3k
views
Lightning Screen Flow Component Visibility - Hide If Resource Field Is Blank
I'm trying to only show a component in my lightning screen flow, when a field in my resource is not blank.
Specifically, when the ParentId field of the account returned by the Get Records element is ...
- 163
3
votes
0
answers
241
views
In Process Builder -> Customize the Logic, does short circuit evaluation occur?
Suppose I have a process builder for the Account object. In my criteria, I've selected "Customize the Logic",
Custom logic: (1 AND 2 AND 3) OR (4 AND 5)
Conditions:
1- IsPersonAccount :: equals :: ...
- 45
0
votes
1
answer
214
views
Is there a way to filter results in a lookup for certain record types?
I have a lookup on a custom object to the standard object 'Products'. My custom object has 3 record types, and requires an input from the Products. But I would like to filter which Products are ...
- 63
1
vote
2
answers
1k
views
Journey filter logic for decision split based on month range after birthdate (mm/dd/yyyy)
I am looking for help with an age based journey. The journey has a decision split that needs the proper filter logic using the birthdate (ex. 12/21/1983) field that includes the year. The entry source ...
- 51
1
vote
1
answer
887
views
Filtered Data Extension bug
I have an issue when applying filters in a Data Extension for a few days ago. Basically it doesn't work.
For example, if I did a filter from a Data Extension adding the criteria 'Email is not null' ...
- 1,039
5
votes
2
answers
2k
views
Marketing Cloud Journey Data Not Available for Exit Criteria?
Why can't I define journey exit criteria using attributes from journey data, instead of only attributes from contact data, which seem to be all that's available?
I ask because I need to use the ...
- 128
1
vote
1
answer
400
views
How to compare two IDs of different objects in testing? [closed]
Getting a failure error after running the test class...
System.DmlException: Insert failed. First exception on row 0; first error: FIELD_FILTER_VALIDATION_EXCEPTION, Value does not exist or does not ...
0
votes
1
answer
3k
views
Process Builder Formula Conditions are met
Sorry I've been drilling this for 8 hours and I'm stuck...
I can get this to work using "Formula Evaluates to to True"
NOT(CONTAINS([User].Email, 'gmail') )
But I can't get it to work using "...
- 103
0
votes
1
answer
167
views
Profile List View Filteration
What filetrs can I apply to profile list view to get Profiles that have access to particular record type of Case?
Please suggest
- 106
1
vote
1
answer
619
views
How to filter data in a pageBlockTable through an inputCheckbox
I have a pageBlockTable that returns data from any query, in that result one of the columns returned is a picklist.
I added an InputCheckbox just above the pageBlockTable and I would like that when ...
- 125
0
votes
1
answer
663
views
How to make a fieldname dynamic in a javascript filter
I have a javascript filter which works fine. I have a field on which I filter an array. What I would like to do is to make this fieldname "Categorie__c" dynamic.
I tried with a concatenate but this ...
- 2,294
3
votes
1
answer
7k
views
How to bind dynamic checkboxes to id
I have a couple of checkboxes which I dynamically create trough an iteration. In want to use these to trigger a function.
My issue is when I select/check 1 checkbox all the others get checked ...
- 2,294
1
vote
1
answer
602
views
Checkboxes not working with javascript function
I am trying to make a dynamic filter on accounts. What I want to achieve is to show only the records where the checkboxes are true.
The issue I have is that my function is not working based on a ...
- 2,294
0
votes
1
answer
3k
views
How to filter a list of records on clietndside based om checkbox criteria
I have tried using filters in a lightning component which filters records based on criteria. How can I toggle the filter based on true or false of a checkbox.
The issue I have currently is when ik ...
- 2,294
1
vote
2
answers
422
views
Pass a list collection from a search to new filtered list lightning controller
I have followed a tutorial to create a custom search lightning component to search a list of contacts based on an event search which works fine. What I would like to achieve is to get the result of ...
- 2,294
0
votes
1
answer
551
views
Show records that haven't been updated for more than a week in reports
To show records in report that haven't been updated for a week or more do is the following criteria correct?
LatModifiedDate__c - Less than - THIS WEEK
- 335
0
votes
1
answer
918
views
Quotation marks in Workflow rule criteria
In a workflow rule I need to check for specific strings within a text field. A simple substring match using "contains" cannot work as it would lead to ambiguity, I put the strings inside of quotation ...
- 915
1
vote
1
answer
368
views
Is it possible to use encrypted fields in filter criteria in list views and reports with shield platform after winter'17 release
In earlier versions, using encrypted fields in filter criteria in list views, reports and communities were not allowed.
I want to know if encrypted fields in filter criteria are now available in list ...
- 441
2
votes
1
answer
1k
views
Relative date range in reports filter
I am trying to generate a report for my end user based on date range.
I used the filter in reports
e.g.
Issused date greater or equal 01/01/2016 (start date)
AND
Issused date less or equal 31/12/...
- 43
1
vote
1
answer
101
views
Need a Report that shows all objects where a string field has more than 50 chars
So,
I'm trying to build a report in SalesForce that will return all objects that have 50 or more characters in one designated string field.
The objects are called Items.
The field that I'm looking at ...
- 11