The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
1answer
68 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
44 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
36 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
31 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
111 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
40 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
46 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
114 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
28 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
33 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
89 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
42 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
30 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 ...
0
votes
0answers
17 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
112 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
15 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 ...
0
votes
1answer
38 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
57 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
31 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
42 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
23 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
66 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
40 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
126 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
28 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
83 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
58 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
51 views

Automation error in step 2

I am building an automation in Automation Studio. In order to prepare to do so I: Created a standard data extension Created a filter to segment the standard data extension Created an interaction ...
0
votes
0answers
55 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, ...
0
votes
0answers
18 views

Restricting Contact Lookup on a Log A Call Task

We create a Log A Call task from the Account, so the account field is usually populated. When I choose the contact, I want to filter the contacts to just those that are related to the account. Is this ...
1
vote
1answer
123 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
278 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
56 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
134 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
67 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
136 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
59 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
67 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
40 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
33 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
172 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
66 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
129 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
178 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
426 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?
2
votes
1answer
349 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
votes
1answer
104 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
1answer
769 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 ...
1
vote
1answer
513 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 ...
0
votes
1answer
337 views

LAST n WEEKS Cross-Filter Not Working As Expected - Opportunities & Activities

I tried to create a report based on Opportunities with an Activities cross-filter, so that the report would show Opportunities that haven't had an Activity created in the last 8 weeks. My filter looks ...