Pages

Saturday, December 12, 2015

Promoted Links in SharePoint 2013


In this post you going to know that how to create and work with promoted links in SharePoint 2013. Simply follow the steps below.

1. Open your site and go the Site Contents.
2. Click add an app.
3. Scroll down in Your Apps page and in Apps you can add section click Promoted Links.
4. Type a name for your promoted links list and click Create.

Now you have created the promoted links list. Let’s see how to add links to the promoted list.

5. Go to Site Contents and click on the promoted links list that you created in previous step.
6. Go to New in Items tabs and click New Item.
7. Insert the information for the promoted link as following:

- Title – [Title for the Link to display when in Tiles View]
- Background Image Location – [Background image URL for the Link to display when in Tiles view.   This Image should store in SharePoint Picture Library]
- Description – [Description for the Link to display when in Tiles View].
- Link Location – [Navigate URL of the Link when click on it.]
- Launch Behavior – [Launching behavior of the Link]
- Order – [Order of the Link to display when in Tiles View]
 
8. Click Save when you done.

Now you have added a link to your promoted links list. Follow the same steps as above to add more links. 

Note: You can switch between Tiles view and All Promoted Links (List edit mode) view anytime by selecting the view from Current View dropdown under Manage Views section in List tab.

Sunday, November 29, 2015

CAML Query with Lists in SharePoint 2013


Single Line of Text
<Where><Eq><FieldRef Name="Name" /><Value Type="Text">EmployeeName</Value></Eq></Where>
__________________________________________________________________

Multiple Lines of Text
<Where><Eq><FieldRef Name="Address" /><Value Type="Text">EmployeeAddress</Value></Eq></Where>
__________________________________________________________________

Choice
<Where><Contains><FieldRef Name='Province'/><Value Type='Choice'>East</Value></Contains></Where>
__________________________________________________________________

Number
<Where><Contains><FieldRef Name='Quantity'/><Value Type='Number'>0</Value></Contains></Where>
__________________________________________________________________

Date and Time
<Where><Eq><FieldRef Name="CurrentDate" /><Value Type="DateTime" IncludeTimeValue='FALSE'>2001-01-01</Value></Eq></Where>
__________________________________________________________________

Lookup By Lookup Name
<Query><Where><Eq><FieldRef Name="State" /><Value Type="Lookup">Arizona</Value></Eq></Where></Query>

Lookup By Lookup Id
<Query><Where><Eq><FieldRef Name="State" LookupId="TRUE" /><Value Type="Lookup">4</Value></Eq></Where></Query>
__________________________________________________________________

Yes/No
<Where><Eq><FieldRef Name="Active" /><Value Type="Boolean">1</Value></Eq></Where>
__________________________________________________________________

Person or Group By SPUser.Name
<Query><Where><Eq><FieldRef Name="Author" />Value Type="Text">Josh McCarty</Value></Eq></Where></Query>

Person or Group By SPUser.ID
<Query><Where><Eq><FieldRef Name="Author" LookupId="TRUE" /><Value Type="Integer"><UserID /></Value></Eq></Where></Query>
__________________________________________________________________

Hyperlink or Picture
<Where><Contains><FieldRef Name='URL'/><Value Type='URL'>http://facebook.com</Value></Contains></Where>
__________________________________________________________________

Calculated
<Where><Eq><FieldRef Name='Status' /><Value Type='Calculated'>Completed</Value></Eq></Where>
__________________________________________________________________

CAML Operators
<Eq> – Equals
<Neq> – Not Equals
<Gt> – Greater than
<Geq> – Greater than or Equals
<Lt> – Less Than
<Leq> – Less Than or Equals
<sNull> – Is Null (Is Empty)
<BeginsWith> – Begins with a string
<Contains> – Contains a string
__________________________________________________________________

ORDER BY
<OrderBy> <FieldRef Name="[Field_Name]" Ascending="True" /></OrderBy>

Ex: <Where><Eq><FieldRef Name="Name" /><Value Type="Text">EmployeeName</Value></Eq></Where><OrderBy> <FieldRef Name="Name" Ascending="True" /></OrderBy>

The default value of Ascending is TRUE (By Default Order is in Descending)

Sunday, November 15, 2015

Common SharePoint URLs

Sometimes you want to jump right to a specific system list, page or go to the edit mode in a SharePoint site. The following is a list of SharePoint URLs to get to commonly used administrative functions on a SharePoint site. The majority of the URLs require administrator permissions on the site and a few require administrator permissions on the SharePoint server.

(For SharePoint 2013/ 2016 you might want to add "15", "16" respectively after "/_layouts/")

Site settings page:
/_layouts/settings.aspx

View all site content page (Site content):
/_layouts/viewlsts.aspx

Site content and structure page:
/_layouts/sitemanager.aspx

Manage site collection features - CASE SENSITIVE
/_layouts/ManageFeatures.aspx?Scope=Site

Manage site features:
/_layouts/ManageFeatures.aspx

Sign in as a different user:
/_layouts/closeConnection.aspx?loginasanotheruser=true

Welcome Page (Default page settings):
/_layouts/AreaWelcomePage.aspx

User Information List:
 _catalogs/users
_catalogs/users/simple.aspx

Change Site Master Page:
/_layouts/ChangeSiteMasterPage.aspx

Page Layouts and Site Templates:
/_Layouts/AreaTemplateSettings.aspx

Master Page’s library:
/_catalogs/master page/Forms/AllItems.aspx

User Information list per Site Collection:
/_catalogs/users/simple.aspx 
/_catalogs/users/detail.aspx (also see)
/_layouts/userdisp.aspx?id={UserID}&Force=True

Login using Windows credentials:
/_windows/default.aspx

Web Part Maintenance Page:
? Contents=1

Also see: