Questions tagged [filters]
The filters tag has no usage guidance.
297
questions
5
votes
1
answer
713
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,
...
- 345
0
votes
1
answer
1k
views
SSJS row retrieve keeps pulling 0 length
I am building a SSJS data extension row retrieve filter to pull out the values a person scored on a survey for certain areas. This is all taking place on a landing page in the SFMC microsites feature (...
- 29.9k
0
votes
2
answers
1k
views
How to create a random data extension that can refresh?
I have a DE that holds all of the subscribers to our email newsletter. What I need is a filter that will randomly take one subscriber from the DE and move it to a different DE. Most importantly, I ...
- 35
0
votes
1
answer
2k
views
SFMC Filter Activity - Date + -
When creating a filter in the Marketing Cloud, say when filtering a Data Extension, you can base any of the statements in the filter off of a date field. The question I have relates to when using the ...
- 2,113
1
vote
1
answer
774
views
Simple Automation studio question
Hi can anyone assist with some basic automation studio questions?
I am new to Marketing Cloud but simply want to trigger an automated email send to those who do not open an email in 7 days time.
i ...
- 23
0
votes
1
answer
237
views
how to write formula filter and how use it in SOQL
Iam newbie to salesforce. Iam trying to write formula field for below filter:
Filtered By: not (1 or (2 AND 3 AND 4))
1. Price greater than "25,000"
2. SF greater than 20
3. PF Number not equal to 1
...
- 13
0
votes
1
answer
58
views
Case Auto Creation to disable from Noreply@saleforce [closed]
I've created a workflow with field on Case Object.
Case:WebEmail not equal to noreply@salesforce.com
but yet I'm still receiving cases created although the filter is set to eliminate the cases ...
- 109
5
votes
1
answer
20k
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 ...
- 2,827
1
vote
0
answers
182
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 ...
- 11
1
vote
1
answer
2k
views
Newly created field not appearing on object filter criteria
I've created a new field in the Order object, it's a text field that is filled with a Name from another custom object.
I want to use the text field in the filter but it doesn't appear in the list of ...
- 11
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 ...
- 157
-1
votes
1
answer
502
views
Trailhead - "Using the Report Builder" challenge. "Stage" field not available in reporting?
I'm doing trailhead "Using the Report Builder" module and I'm stuck on the challenge since I cannot add Stage as a Filter and I don't know wth is going on.
Anyone went trough this?.
Thanks!, Nahuel
- 303
1
vote
1
answer
266
views
Remote Object Query Filter Criteria for Cross-Object Formula
So I am working to create a VF page that pulls a list of records from a custom object (Individual_Account__c) and I am also trying to filter this list of records based on a cross-object formula field (...
- 65
2
votes
0
answers
3k
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 ...
- 21
0
votes
2
answers
378
views
How Do I Create an EmailSendDefinition That Uses a Filter?
I'm trying to create an EmailSendDefinition which makes use of a filter, but am getting the following exception: Exception occurred during [CreateEmailSendDefinition] ErrorID = 1719440099.
I based my ...
- 23
0
votes
1
answer
384
views
Java Fuel-SDK searching Data Extension for Email
We are using the Java Fuel-SDK 1.0.3 to select a row with a specific email address from a Data Extension.
The existing documentation either says ‘Coming soon!’ or points to the Javadoc.
While the ...
- 11
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 ...
- 3,668
0
votes
1
answer
763
views
Date Filter with AMPScript
I am trying to pull out Tracking Event data, using the "TrackingEvent" Object Type. I need to find tracking event data for a subscriber within the last 30 days.
How do I create a simplefilterpart ...
2
votes
2
answers
2k
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/...
- 2,416
0
votes
1
answer
2k
views
Exacttarget API how to create a filtered data extension
I already know how to create a data filter, I would like to know how to create a data extension with selected data filter via API call. It should create a new data extension with same schema as the ...
- 789
0
votes
1
answer
172
views
Opportunity Notification based on Related Object
Our Opportunities have a related object, named Billing Schedules. These house individual billing entries for Opportunities. What I'd like to do is spawn an email notification using a workflow that ...
- 213
1
vote
2
answers
126
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 ...
- 707
1
vote
1
answer
3k
views
Measures and filters
I'm trying to find who ever got and specific email 3 days ago.
So I made a Measure:
Event source: Sent
Condition: Email name == 2015-11-11_Praeaktiveerede_kort_invitation
I know I have sent 46 ...
- 493
1
vote
0
answers
436
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 ...
- 11
1
vote
0
answers
140
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 ...
- 111
1
vote
1
answer
1k
views
De-duplicating when sending to data filters?
When I send to a data extension, I get the 'de-duplicate subscribers by email address' checkbox, which is great.
However, you can't do that when sending to a data filter.
Anyone know how you might? ...
-1
votes
2
answers
46
views
Search on product when either area or customer is assigned and subsequently return the product in a search result - Not working
I have a search page with a search box which returns a product (Sku) based on the product name the user enters or the description of the product itself.
With present code, the product is only ...
- 125
1
vote
1
answer
5k
views
Unable to filter out blank fields
I've read many topics, but still couldn't solve this problem:
I need to create a report that shows number of activities on each account total AND also shows accounts with no activity at all.
The ...
- 139
0
votes
1
answer
362
views
Birthday campaign with Mobile connect(sms)
My team was working on a SMS birthday campaign which expected to use Mobile Connect and the Automation studio send out daily.
So far we successfully fire the event hence the data extension in Email ...
0
votes
0
answers
223
views
Salesforce Controller Test: getAccounts method not filtering by profile
I have a custom controller that is intended to return a results set to a visualforce page for customized viewing. It works fine in production. When building my unit test for this controller, however,...
- 31
1
vote
1
answer
1k
views
Customize result of of lookup field search
Can I customize result of a lookup field search?
For example, I want to see only the contact related with an account. This account is selected by another lookup. Only way that I find is to flag the ...
- 25
0
votes
1
answer
3k
views
Exacttarget - Sending email to filters VS sending email to filtered data extension
I would like to send emails to a group of subscribers. I would like to filter them from the data extension subscriver_all, where all my subscribers are.
From what I know there are two ways of doing ...
0
votes
1
answer
607
views
Object Filter in SSIS Salesforce Source
I need to move all records from salesforce to a DWH using SSIS.
After the initial run I need to move only the records that either got inserted or updated after the last run into SFDC.
I learnt that ...
- 1
0
votes
1
answer
2k
views
SOAP API: Applying filter to a retrieve data in Apex
I generated Apex code from the ExactTarget SOAP Api:
Exacttarget Wsdl URL
I am trying to make webservicecallouts using apex to retrieve "SentEvent" for an specific subscriber. Using SOAPUi it works ...
0
votes
1
answer
802
views
Report time filter based on two different fields
I am attempting to build a report filter for a custom object which shows contracts in my company. I would like the filter to allow me to show only the contracts which were opened (Open Date) within 30 ...
- 3,824
1
vote
1
answer
2k
views
Show only previous Business Day on a report
I am attempting to show the previous Business Day's new Accounts in a report. I am unable to simply use Yesterday as the filter because Monday will then show Sunday results, not Friday.
The only ...
- 3,824
-2
votes
1
answer
318
views
How to filter todays date from a timestamp field?
We have a field in a data extension with a timestamp value e.g. "2015-04-30 12:46". The data type is text. We would like to filter that column for todays date, preferably using a data filter (sending ...
1
vote
0
answers
415
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 ...
- 571
1
vote
0
answers
78
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
...
- 2,346
2
votes
1
answer
60
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 = "...
- 163
1
vote
1
answer
847
views
can i mass update/insert report criteria
we have built around 100+ reports and now I would like add a filter criteria to all these 100+ reports, is there a quick way to add the filter instead of going 1 by 1?
Thanks.
- 905
1
vote
1
answer
346
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 ...
- 1,381
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 ...
- 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?
- 5,226
3
votes
1
answer
6k
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 ...
- 3,682
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 (...
0
votes
1
answer
2k
views
Report Filter for CloseDate is from Past Month
I have following Formula on my Validation Rules, I want to find out which of my Existing Records comes under these validation rules, So, I am creating Report for it. I am unable to FILTER Following ...
- 2,140
1
vote
1
answer
1k
views
Filtered related list in Salesforce
How to get a filtered related list in Salesforce? I know that we can get a custom Related List using PageBlock Table in a VF page but i don't know how to get hyperlinks around records in related lists ...
- 15
1
vote
3
answers
4k
views
Custom field lookup not returning all matching values for filter criteria
I have created a lookup field with required filter type that filters on specific criteria within the lookup objects. During testing I noted the lookup field only returning 1 value as an option when ...
- 13
1
vote
1
answer
574
views
How do I stop the creation of a particular object's records from appearing in my chatter feed?
I use a rollup app that creates a new rollup queue record every few minutes. Each time one of these records is created, it appears in my chatter feed. Is there a way to filter these out?
I found ...
- 830