The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [filters]

The tag has no usage guidance.

67 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
12
votes
1answer
565 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", ...
2
votes
1answer
22 views

“Account Data Extension” with Account ID as proimary Key using for Order related Emails?

I created a "Account Data Extension" with AccountID as primary key, so every customer is just ones in the Data Extension. Now I want to send order related Emails/Journeys. Therefore I filter this Data ...
2
votes
1answer
68 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 ...
2
votes
0answers
217 views

Salesforce1 : Report navigation with url parameters not working

I need to filter the records display on report according to the logged in user. Therefor I am using URL parameters as, (which works fine on SF classic) /{REPORT_ID}?pv0={LOGGED_IN_USER_NAME} But ...
2
votes
0answers
2k views

Refresh Filtered Data Extensions automatically

In our system we have a ftp-triggered automation that imports a file into a data extension that is the source for hundreds of filtered data extensions which will be used for sending (and of course ...
2
votes
2answers
111 views

Error in Inline Visualforce Page

I have summary report chart. which is to be displayed in visual force page. Report is geting displayed. but when I try to add filter criteria it shows Error [For the filter 1: Specify a valid ...
2
votes
1answer
49 views

Passing a personalize string in RetrieveRequest to get the data from DataExtesnion

I am trying to use the filter part and Retrieve Request to get the data from data extension. RetrieveRequest request1 = new RetrieveRequest(); request1.ObjectType = "...
2
votes
0answers
173 views

Filter Not Working For List

I'm trying to start using the Fuel SDK in Rails, but I can't seem to get a simple filter to work. Retrieving without a filter works fine, and returns the whole set (all 36 or whatever lists). I need ...
1
vote
0answers
43 views

Multiple filters for same field in wave:update

I'm developing a Salesforce Aura component that updates an existing Wave Analytics dashboard whenever something changes within the component. Those changes may affect same field with several values ...
1
vote
1answer
365 views

Lightning Filter Component

We are building a component that allow user to search for list of records. Was wondering if there is a standard filter component that can be applied with the possibility to apply multiple fields and ...
1
vote
0answers
168 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 ...
1
vote
0answers
95 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 ...
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 ...
1
vote
0answers
31 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 ...
1
vote
1answer
1k views

Filter Reports by the Time of their CreatedDate

I figured that the CreatedDate will not show the time in the reports section. So I made a DateTime formula field to take the value from CreatedDate. Now this shows the time value inside the reports. ...
1
vote
2answers
254 views

Cross filter and custom report link

In custom report link, I can substitute the values in the filter using pv0, pv1 & so on.... but what if my filter rules include cross filer ? Will I still be able to use pv0, pv1 etc. E.g. ...
1
vote
2answers
356 views

Using the Send Log for Filter Criteria in Journey Builder

We have a requirement to not flow down a path if the subscriber has received a specific email (ex. Email1) in the past 7 days. We are using the Send Log, this contains the EMAILNAME and SENDDATE. The ...
1
vote
0answers
140 views

How to work with FilterActivity via SOAP API

I have some issues when I try to create a FilterActivity via API. In the Marketing Cloud I usually define a DataFilter, then from Interactions I create a Filter having that DataFilter as ...
1
vote
2answers
521 views

Using User 's Alias/Username in Workflow/Approval Process Entry Criteria & Validation Rules

Many time we have some requirement in Approval Process field Criteria, Workflow Entry Criteria and Validation rules where some checks are required specific to users. For e.g. Take Some workflow ...
1
vote
0answers
380 views

Creating Lookup Filter - Insert Field not showing field

I am trying to create a lookup filter from a custom object (FormProduct) to Product on the FormProduct object lookup field and set the criteria on a field on the FormProduct (ProductType__c) but this ...
1
vote
0answers
65 views

Filter Count on each SOQL Data Category Passed to Query

I have the following query that returns the total count: SELECT Count() FROM X__kav WHERE PublishStatus = 'Online' AND Language = 'en_US' WITH DATA CATEGORY Foo_c AT (Bar_c, Baz__c) How would I ...
1
vote
0answers
161 views

Dashboard filter for data sources with different objects

I have a large dashboard with info on Cases. This dashboard can be filtered by the Case Record Type field and this is good. Also, I have a custom object with some additional data which is explicitly ...
1
vote
0answers
63 views

Filtering dashboard by non-predefined date range

Is it possible in Salesforce to select non-predefined date range as a filter on a dashboard? The limitations I found are: Max 10 values available for one filter Max 3 filters Only predefined values ...
1
vote
1answer
319 views

What is the best way to build filtering functionality similar to Report filters in Salesforce using just visualforce

This is more of an architectural question. I am trying to build a filter function similar to what Salesforce has whereby I click an Add filter button and this displays a drop down. Based on the choice ...
0
votes
0answers
15 views

Filter picklist values based on other objects field values

Is it possible to filter picklist values based on the 2 other object fields relation? In that case I mean for example: I have an Order Type field which on junction object is related to Region (e.g. ...
0
votes
0answers
40 views

Create the look filter for custom field in lighting

I have created the custom case component for the community and I have to apply the lookup criteria to create a filter to limit the records available to users. In my salesforce org (standard case ...
0
votes
0answers
18 views

Escalation rule logic not working

I have a sequence of 4 rules in one Escalation with slightly different criteria primarily based on country. It is set to escalate on either 24 hrs or 24 & 48 based on the country. Currently, the ...
0
votes
0answers
32 views

Filter data by year w/o changes to SOQL?

Trying to filter data that is returned to me by the termination year. If any data that is pulled and has a termination date older then five years I do not want it to show up. public static List<...
0
votes
0answers
8 views

Dashboard Filter - Pulling a different field value

On a dashboard i am creating (case object), i have added the filter options for edit date and edited by. When i select an option in the edit date filter, a filter is added to the report(s) for the ...
0
votes
0answers
23 views

Filtering by date-field

I'm trying to create a report over "Faktura" filtering by its field "Dato for fakturering", but it's not showing up in the report maker. Can anyone explain why this is? Is there any way to fix it? ...
0
votes
0answers
10 views

Grouping Filtered Records on a Visualforce Page by a Field

I have a custom object called "Availability" that has a couple of field that I'd like to display and I want to be able to filter them by a date range selected by the user through the VisualForce page ...
0
votes
0answers
8 views

Dashboard Filter within Tile - How to Change from “Equals” to “Contains”

there is a filter within a tile on one of my dashboards that appears to default to "Equals" and as a result, when I drill down there are no results pulling. Is there a way to change this to "Contains"?...
0
votes
0answers
20 views

How to add filter in to salesforce lightning app?

I have built an app with a geolocation feature. To easily filter the data I have used search term. But I have to add a search filter where user can easily select from the drop-down list or checkbox ...
0
votes
0answers
11 views

Annual revenue filters in the report

I'm trying to calculate the gross annual revenue for the last year. But my filters seem wrong to me. I consider the interval between starting and final dates. But what if the date started in 2017, and ...
0
votes
0answers
15 views

View my cases and all new cases (other owner)

as an agent I need to see the tickets I managed (the owner is me) and also the new tickets (other owner). I tried to filter in the lists of views but it doesn't allow me to do what I want. Any ...
0
votes
0answers
103 views

Filter Data Based On Values Matching In Two Columns

Is it possible to filter data based on values in two columns matching in Einstein Analytics? For example, I have one column named BO Qty and another named Supply Qty. If BO Qty is 1 and Supply Qty is ...
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
0answers
25 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)
0
votes
1answer
104 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 ...
0
votes
0answers
56 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
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
74 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 ...
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 ...
0
votes
1answer
305 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
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 ...
0
votes
1answer
91 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
376 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 ...
0
votes
1answer
571 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
0answers
102 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?