The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
13 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 (...
0
votes
2answers
28 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 ...
0
votes
1answer
31 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 ...
1
vote
1answer
53 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 ...
0
votes
1answer
39 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 ...
1
vote
1answer
22 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 ...
0
votes
0answers
24 views

Add custom filters to apex:enhancedList

I am trying to make a new visualforce page that displays one of the list views of Opportunity and add an additional filter to that (based on a picklist custom field of Opportunity) so the user can ...
3
votes
1answer
95 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 ...
1
vote
0answers
53 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
1answer
70 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 ...
1
vote
2answers
52 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 ...
2
votes
4answers
122 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 ...
-1
votes
1answer
73 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!, ...
1
vote
1answer
70 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 (...
0
votes
0answers
335 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 ...
0
votes
2answers
39 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 ...
0
votes
1answer
50 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 ...
2
votes
1answer
244 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 ...
0
votes
1answer
60 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 ...
3
votes
2answers
40 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....
0
votes
0answers
19 views

Create (clone) filtered dashboard but with only one hard-wired filter (no drop down)

Hi I am aware you can create 'filtered' dashboards as described here and you can also create 'dynamic' dashboards which filter on user as described here. However neither of these really fit my ...
0
votes
1answer
218 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 ...
0
votes
0answers
19 views

Apply look up filter on memberid field of case team member object

I want to apply a look up filter to member id field on case team member object. I am not able to find any way around same. I know there is standard filter available but I want some pre defined filters....
0
votes
1answer
42 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 ...
3
votes
2answers
59 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 ...
0
votes
0answers
47 views

How to validate a Logic Filter input Text

I need to implement a Logic Filter Text field in my VF page. The value of the input field can be anything, like (A AND B) OR (C AND D) or A OR (C AND B) etc. I have 6 filter fields. I would like to ...
1
vote
1answer
75 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 ...
0
votes
0answers
29 views

Fuel API - Java Error Using Filter With Special Character

I am using the filter object in java API against a data extension text field. When I run the filter I get an exception. Please could anyone advise what is wrong here and how I can work around it? My ...
1
vote
0answers
86 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
42 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 ...
0
votes
1answer
216 views

ExactTarget/Marketing Cloud - 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
2answers
31 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 ...
1
vote
1answer
92 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 ...
0
votes
1answer
76 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
0answers
68 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,...
1
vote
1answer
163 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 ...
0
votes
1answer
487 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
1answer
79 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 ...
0
votes
1answer
156 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
1answer
79 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 ...
1
vote
1answer
212 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 ...
-1
votes
1answer
70 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
0answers
69 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
43 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
votes
1answer
38 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 = "...
1
vote
1answer
205 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.
0
votes
1answer
77 views

set dashboard filter by record type

i have multiple dashboards and i would like to know how can i add dashboard filter by record type? I don see this option in my filter list. I tried added a formula field in my Account & ...
1
vote
1answer
152 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
vote
1answer
200 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 ...
1
vote
1answer
525 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?