Views FAQ
A SPoC can go to
and open the appropriate View record. The owner is listed at the bottom of the view record, next to last field labeled User.Yes, this can be done by copying the "Current Contacts" View and adding the following to the existing criteria:
AND Display_Name LIKE N'%''%' OR Last_Name LIKE N'%''%' OR First_Name LIKE N'%''%'
The N before the single-quotes designates it as Unicode. The odd character is between wildcards (%) to identify all instances.
When creating a custom view, to have a field filter on a list of criteria (like a handful of Groups), use the IN comparison and list your terms separated by commas.
Yes, you can set a default Page View on a Page. This sets the default Page View for all users (it's not possible to have the default Page View vary by user). To set a default Page View, a system administrator should:
- Go to and open the appropriate Page.
- Click Edit.
- Change the Default View field as needed.
- Click Save.
Yes. The Default View must be a Sub-Page View selected in the Sub-Page. It cannot be a Shared View; rather, it must be shared system-wide.
Yes, you can filter a View based on audit log entries, including fields edited and dates. See "Contact Changes Past 7 Days" View Example. Here is an example for Marital Status changes in the past 30 days:
EXISTS( SELECT 1FROM dp_Audit_Detail AD INNER JOIN dp_Audit_Log AL ON AD.Audit_Item_ID = AL.Audit_Item_IDWHERE AL.Audit_Description IN ('Updated','Mass Updated') AND AL.Table_Name = 'Contacts' AND AD.Field_Name = 'Marital_Status_ID' AND AL.Record_ID = Contacts.Contact_ID AND AL.Date_Time > GETDATE()-30 )
Yes. The simplest approach is to use DATENAME(dw,[Date_Field]) to return the name of the weekday. For example, Events that start on Sunday: DATENAME(dw,[Event_Start_Date])='Sunday'.
First, it's important to make sure you're creating the view on the correct page, as there are specific items in the data tree based on which page you're on. If you are on the correct page, has a filtered page been created based off the page you're working on? You want to make sure that your filtered page has a Filter Clause. When the Platform sees two pages without the filter clause on the same page, it arbitrarily uses one of them to build the data tree in the advanced search. Lastly, ensure you have appropriate permissions to the fields or pages you need.
Once you make a selection, it is saved with the format (that is, column order) of the All Records view for that page. If you need your selection to stay in a certain format, you'll want to Export it to Excel as the Current View.
A view could be created with a correlated subquery to see file attachments. See the Files on Contacts View Example.
Include a second single quote in your SQL. So if the group name is 2's, have your criteria use 2''s (using two single quotation marks, not a double quotation mark).
This depends on who you want to share the View with, whether it be a group of users or all users. The best way to share a personal View to a select group of users is to assign it to a User Group, and add Users to that User Group. You can do this by opening the View in the Advanced Search Tool and selecting the appropriate User Group. See Sharing Your View with Other Users Using Advanced Search for more information. Alternatively you can modify the Page View record on the Page Views page within the System Setup Section. Open the record for the View, click Edit and change the User Group field to the appropriate User Group.
To share the View with all Users, open the View from the Page Views Page and remove the User from the User field, then save the record. This makes the View a standard view that will show up for all users who have access to that Page.