tag:blogger.com,1999:blog-32232898849322520332024-03-18T20:03:14.495-07:00sharepointchakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.comBlogger33125tag:blogger.com,1999:blog-3223289884932252033.post-66408121267428385332013-07-07T23:29:00.000-07:002013-07-07T23:29:08.092-07:00Sharepoint list search using Visualstudio<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white; line-height: 161%; margin: 0in 0in 10pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<span lang="EN" style="color: red; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman';">Reference URL</span><span lang="EN" style="color: #548dd4; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text2; mso-themetint: 153;">:</span><span lang="EN"><span style="font-family: Calibri;"> </span></span><span lang="EN" style="color: #548dd4; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text2; mso-themetint: 153;">http://jasear.wordpress.com/2012/04/19/sharepoint-2010-basic-list-search-filter-webpart/<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 161%; margin: 0in 0in 10pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<b style="mso-bidi-font-weight: normal;"><span lang="EN" style="color: #548dd4; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text2; mso-themetint: 153;">.ascx<u><o:p></o:p></u></span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Assembly</span> <span style="color: red;">Name</span><span style="color: blue;">="$SharePoint.Project.AssemblyFullName$"</span><span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Assembly</span> <span style="color: red;">Name</span><span style="color: blue;">="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"</span> <span style="background: yellow; mso-highlight: yellow;">%></span> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span> <span style="color: red;">Tagprefix</span><span style="color: blue;">="SharePoint"</span> <span style="color: red;">Namespace</span><span style="color: blue;">="Microsoft.SharePoint.WebControls"</span> <span style="color: red;">Assembly</span><span style="color: blue;">="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"</span> <span style="background: yellow; mso-highlight: yellow;">%></span> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span> <span style="color: red;">Tagprefix</span><span style="color: blue;">="Utilities"</span> <span style="color: red;">Namespace</span><span style="color: blue;">="Microsoft.SharePoint.Utilities"</span> <span style="color: red;">Assembly</span><span style="color: blue;">="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span> <span style="color: red;">Tagprefix</span><span style="color: blue;">="asp"</span> <span style="color: red;">Namespace</span><span style="color: blue;">="System.Web.UI"</span> <span style="color: red;">Assembly</span><span style="color: blue;">="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Import</span> <span style="color: red;">Namespace</span><span style="color: blue;">="Microsoft.SharePoint"</span> <span style="background: yellow; mso-highlight: yellow;">%></span> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Register</span> <span style="color: red;">Tagprefix</span><span style="color: blue;">="WebPartPages"</span> <span style="color: red;">Namespace</span><span style="color: blue;">="Microsoft.SharePoint.WebPartPages"</span> <span style="color: red;">Assembly</span><span style="color: blue;">="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: yellow; font-family: Consolas; font-size: 9.5pt; mso-highlight: yellow;"><%</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">@</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: maroon;">Control</span> <span style="color: red;">Language</span><span style="color: blue;">="C#"</span> <span style="color: red;">AutoEventWireup</span><span style="color: blue;">="true"</span> <span style="color: red;">CodeBehind</span><span style="color: blue;">="ListSearchUserControl.ascx.cs"</span> <span style="color: red;">Inherits</span><span style="color: blue;">="SearchWebpart.ListSearch.ListSearchUserControl"</span> <span style="background: yellow; mso-highlight: yellow;">%></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">script</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: red;">type</span><span style="color: blue;">="text/javascript"</span> <span style="color: red;">src</span><span style="color: blue;">="/sites/new1/_layouts/scripts/jquery-1.6.3.min.js"</span> <span style="color: red;">src</span><span style="color: blue;">="/sites/new2/_layouts/scripts/jquery-1.6.3.min.js"></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>$(document).ready(<span style="color: blue;">function</span> () {<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> base_RefreshPageTo = RefreshPageTo;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>RefreshPageTo = <span style="color: blue;">function</span> (event, url) {<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> filterName = getQuerystring(<span style="color: maroon;">'FilterName'</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> filterValue = getQuerystring(<span style="color: maroon;">'FilterMultiValue'</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> newUrl = url + <span style="color: maroon;">'&FilterName='</span> + filterName + <span style="color: maroon;">'&FilterMultiValue='</span> + filterValue;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (filterName != <span style="color: maroon;">''</span> && filterValue != <span style="color: maroon;">''</span>) {<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>base_RefreshPageTo(event, newUrl);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">else</span> {<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>base_RefreshPageTo(event, url);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">return</span>;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>});<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">function</span> getQuerystring(key, default_) {<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (default_ == <span style="color: blue;">null</span>) default_ = <span style="color: maroon;">""</span>;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>key = key.replace(/[\[]/, <span style="color: maroon;">"\\\["</span>).replace(/[\]]/, <span style="color: maroon;">"\\\]"</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> regex = <span style="color: blue;">new</span> RegExp(<span style="color: maroon;">"[\\?&]"</span> + key + <span style="color: maroon;">"=([^&#]*)"</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">var</span> qs = regex.exec(window.location.href);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (qs == <span style="color: blue;">null</span>)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">return</span> default_;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">else</span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">return</span> qs[1];<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">script</span><span style="color: blue;">></span> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: maroon; font-family: Consolas; font-size: 9.5pt;">table</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">></span><span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">strong</span><span style="color: blue;">></span>Search Criteria:<span style="color: blue;"></</span><span style="color: maroon;">strong</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TextBox</span> <span style="color: red;">ID</span><span style="color: blue;">="TbSearchText"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Width</span><span style="color: blue;">="300px"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">TextBox</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: red;">&nbsp;</span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">strong</span><span style="color: blue;">></span>Field name:<span style="color: blue;"></</span><span style="color: maroon;">strong</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">DropDownList</span> <span style="color: red;">ID</span><span style="color: blue;">="DdlListFields"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">DropDownList</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: red;">&nbsp;</span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">div</span> <span style="color: red;">align</span><span style="color: blue;">="right"></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Button</span> <span style="color: red;">ID</span><span style="color: blue;">="BtnSearch"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">OnClick</span><span style="color: blue;">="BtnSearch_Click"</span> <span style="color: red;">Text</span><span style="color: blue;">="Search"</span> <span style="color: blue;">/></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"><</span><span style="color: maroon;">asp</span><span style="color: blue;">:</span><span style="color: maroon;">Button</span> <span style="color: red;">ID</span><span style="color: blue;">="BtnClearFilter"</span> <span style="color: red;">runat</span><span style="color: blue;">="server"</span> <span style="color: red;">Visible</span><span style="color: blue;">="false"</span> <span style="color: red;">OnClick</span><span style="color: blue;">="BtnClearFilter_Click"</span> <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="color: red;">Text</span><span style="color: blue;">="Clear Criteria"</span> <span style="color: blue;">/></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">div</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">td</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">tr</span><span style="color: blue;">></span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;"></</span><span style="color: maroon;">table</span><span style="color: blue;">><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 161%; margin: 0in 0in 10pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: 161%; margin: 0in 0in 10pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;">
<b style="mso-bidi-font-weight: normal;"><u><span lang="EN" style="color: #548dd4; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text2; mso-themetint: 153;">.ascx.cs</span></u></b><b style="mso-bidi-font-weight: normal;"><span lang="EN" style="color: #548dd4; font-family: Consolas; font-size: 12pt; line-height: 161%; mso-ansi-language: EN; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text2; mso-themetint: 153;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI.WebControls;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Web.UI.WebControls.WebParts;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> Microsoft.SharePoint;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Text;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Specialized;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Collections.Generic;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">using</span><span style="font-family: Consolas; font-size: 9.5pt;"> System.Drawing;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">namespace</span><span style="font-family: Consolas; font-size: 9.5pt;"> SearchWebpart.ListSearch<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">partial</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">ListSearchUserControl</span> : <span style="color: #2b91af;">UserControl</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPSite site = SPContext.Current.Site;</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPWeb web;</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPList list;</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">class</span> <span style="color: #2b91af;">OptionEntity</span><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">string</span> Id { <span style="color: blue;">get</span>; <span style="color: blue;">set</span>; }<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> Gets or sets the title.<span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"></summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><value></span><span style="color: green;">The title.</span><span style="color: grey;"></value></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">string</span> Title { <span style="color: blue;">get</span>; <span style="color: blue;">set</span>; }<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">string</span> To { <span style="color: blue;">get</span>; <span style="color: blue;">set</span>; }<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> OptionEntity()<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>} <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">private</span> <span style="color: #2b91af;">List</span><<span style="color: #2b91af;">OptionEntity</span>> GetSharePointListFieldItems()<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">List</span><<span style="color: #2b91af;">OptionEntity</span>> fieldItems = <span style="color: blue;">new</span> <span style="color: #2b91af;">List</span><<span style="color: #2b91af;">OptionEntity</span>>();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>fieldItems = <span style="color: blue;">new</span> <span style="color: #2b91af;">List</span><<span style="color: #2b91af;">OptionEntity</span>>();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">OptionEntity</span> item;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">SPField</span> field;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">StringCollection</span> viewFieldCollection = <span style="color: #2b91af;">SPContext</span>.Current.ViewContext.View.ViewFields.ToStringCollection();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">foreach</span> (<span style="color: blue;">string</span> viewField <span style="color: blue;">in</span> viewFieldCollection)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPSite site = SPContext.Current.Site;</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPWeb web = site.OpenWeb();</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPList list = web.Lists["peoplepicker"];</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>field = <span style="color: #2b91af;">SPContext</span>.Current.List.Fields.GetFieldByInternalName(viewField);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item = <span style="color: blue;">new</span> <span style="color: #2b91af;">OptionEntity</span>();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item.Id = field.InternalName;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item.Title = field.Title;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>fieldItems.Add(item);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">return</span> fieldItems;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">protected</span> <span style="color: blue;">override</span> <span style="color: blue;">void</span> CreateChildControls()<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">base</span>.CreateChildControls();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">List</span><<span style="color: #2b91af;">OptionEntity</span>> items = GetSharePointListFieldItems();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>DdlListFields.DataSource = items;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>DdlListFields.DataTextField = <span style="color: #a31515;">"Title"</span>;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>DdlListFields.DataValueField = <span style="color: #a31515;">"Id"</span>;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>DdlListFields.DataBind(); <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> Raises the </span><span style="color: grey;"><see cref="E:System.Web.UI.Control.Load"/></span><span style="color: green;"> event.<span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"></summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><param name="e"></span><span style="color: green;">The </span><span style="color: grey;"><see cref="T:System.EventArgs"/></span><span style="color: green;"> object that contains the event data.</span><span style="color: grey;"></param></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">protected</span> <span style="color: blue;">override</span> <span style="color: blue;">void</span><span style="mso-spacerun: yes;"> </span>OnLoad(<span style="color: #2b91af;">EventArgs</span> e)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">base</span>.OnLoad(e);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (!IsPostBack)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (Request.QueryString[<span style="color: #a31515;">"FilterName"</span>] != <span style="color: blue;">null</span>)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>DdlListFields.SelectedValue = Request.QueryString[<span style="color: #a31515;">"FilterName"</span>].ToString();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (Request.QueryString[<span style="color: #a31515;">"FilterMultiValue"</span>] != <span style="color: blue;">null</span>)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>TbSearchText.Text = Request.QueryString[<span style="color: #a31515;">"FilterMultiValue"</span>].ToString().Replace(<span style="color: #a31515;">"*"</span>, <span style="color: #a31515;">""</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>BtnClearFilter.Visible = <span style="color: blue;">true</span>; <span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> Handles the Click event of the BtnSearch control.<span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"></summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><param name="sender"></span><span style="color: green;">The source of the event.</span><span style="color: grey;"></param></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><param name="e"></span><span style="color: green;">The </span><span style="color: grey;"><see cref="System.EventArgs"/></span><span style="color: green;"> instance containing the event data.</span><span style="color: grey;"></param></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">protected</span> <span style="color: blue;">void</span> BtnSearch_Click(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">EventArgs</span> e)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">string</span> redirectUrlFormat = <span style="color: #a31515;">"{0}?FilterName={1}&FilterMultiValue={2}"</span>;<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">string</span>[] selectionCollection = TbSearchText.Text.ToString().Split(<span style="color: blue;">new</span> <span style="color: blue;">string</span>[] { <span style="color: #a31515;">";"</span> }, <span style="color: #2b91af;">StringSplitOptions</span>.RemoveEmptyEntries);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">StringBuilder</span> sbValues = <span style="color: blue;">new</span> <span style="color: #2b91af;">StringBuilder</span>();<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">foreach</span> (<span style="color: blue;">string</span> selection <span style="color: blue;">in</span> selectionCollection)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>sbValues.Append(<span style="color: #a31515;">"*"</span> + selection.Trim() + <span style="color: #a31515;">"*;"</span>);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">string</span> urlToRedirectTo = <span style="color: blue;">string</span>.Format(redirectUrlFormat, Request.Url.GetLeftPart(<span style="color: #2b91af;">UriPartial</span>.Path), DdlListFields.SelectedValue, sbValues.ToString());<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>Response.Redirect(urlToRedirectTo);<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> Handles the Click event of the BtnClearFilter control.<span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"></summary></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><param name="sender"></span><span style="color: green;">The source of the event.</span><span style="color: grey;"></param></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: grey;">///</span><span style="color: green;"> </span><span style="color: grey;"><param name="e"></span><span style="color: green;">The </span><span style="color: grey;"><see cref="System.EventArgs"/></span><span style="color: green;"> instance containing the event data.</span><span style="color: grey;"></param></span><span style="color: green;"><span style="mso-spacerun: yes;"> </span></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">protected</span> <span style="color: blue;">void</span> BtnClearFilter_Click(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">EventArgs</span> e)<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>Response.Redirect(Request.Url.GetLeftPart(<span style="color: #2b91af;">UriPartial</span>.Path));<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;">}<o:p></o:p></span></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-47439162072995631512013-07-07T23:24:00.001-07:002013-07-07T23:24:27.004-07:00sharepoint list Search using jquery<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u>Search using jquery:</u></strong><br />
<br />
<strong><u>Reference </u><a href="http://geekswithblogs.net/SoYouKnow/archive/2011/01/26/sharepoint-list-views-ndashquick-amp-easy-jquery-filter.aspx">url:</a></strong><span style="color: red; font-family: 'Calibri','sans-serif'; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">http://geekswithblogs.net/SoYouKnow/archive/2011/01/26/sharepoint-list-views-ndashquick-amp-easy-jquery-filter.aspx</span></div>
<br />
<script src="/sites/testingsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script type="text/javascript"><br />
<br />
jQuery(document).ready(function($){<br /> $('#filterInput').keyup(function() <br /> {<br /> DynamicFilter($('#filterInput').val());<br /> });<br />})<br />function stripHTML (field) {<br /> return field.replace(/<([^>]+)>/g,'');<br />}<br />
function DynamicFilter(text)<br />{<br /> $('table [class="ms-listviewtable"]').find('tr').each(function()<br /> {<br /> <br /> if ($(this).attr("class") != "ms-viewheadertr ms-vhltr")<br /> {<br /> source = stripHTML($(this).html());<br /> text = text.toLowerCase();<br /> source = source.toLowerCase();<br /> if (source.indexOf(text) < 0)<br /> {<br /> $(this).hide();<br /> } else {<br /> <br /> $(this).show();<br /> }<br /> }<br /> }<br /> );<br />}</script><div id="mainDiv"><table><tbody><tr><td width="125" class="Filter">Search:&#160; <input id="filterInput" type="text"/></td></tr></tbody></table></div><br />&#160;chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-65198444044004292532013-07-07T23:10:00.000-07:002013-07-07T23:10:03.269-07:00Remider mail using Sharepoint designer<div dir="ltr" style="text-align: left;" trbidi="on">
Reminder screenshot<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTczfziGHO84ASMmHYyJCG27tTHfvKqohy9ce9ORC_W7ZeFHfP8TA03D3XnM3F7UEDeOKXtFLNWqWu9m21vD8gLmuoomJxB6bcQBWSYuXv8VOctrmNS7MJUoc6XBHxn0xvA6bJ0UnWKhI/s1600/New+Bitmap+Image+(3).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" oya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTczfziGHO84ASMmHYyJCG27tTHfvKqohy9ce9ORC_W7ZeFHfP8TA03D3XnM3F7UEDeOKXtFLNWqWu9m21vD8gLmuoomJxB6bcQBWSYuXv8VOctrmNS7MJUoc6XBHxn0xvA6bJ0UnWKhI/s1600/New+Bitmap+Image+(3).bmp" /></a></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-40326128376905052132013-07-07T23:06:00.003-07:002013-07-07T23:06:38.806-07:00Dropdown issue in infopath<div dir="ltr" style="text-align: left;" trbidi="on">
Sometime we will face issue with dropdown selection in infopath(binding the data from list)<br />
<br />
After creating dropdown if two values will be ID <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6g_gSz5tR3xkFKr9_ao2P1fixY_oTkAoGVstpidEcZT-pEAhG1rchSWt1vePbOdrkbc5FsPyZWP2BJneAMDe3L0UInUOP2OojMHcLUtkCGQO9ZHNnZM7FrRHx0zeqVdLQD6GnsDwNaZk/s1600/New+Bitmap+Image.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" oya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6g_gSz5tR3xkFKr9_ao2P1fixY_oTkAoGVstpidEcZT-pEAhG1rchSWt1vePbOdrkbc5FsPyZWP2BJneAMDe3L0UInUOP2OojMHcLUtkCGQO9ZHNnZM7FrRHx0zeqVdLQD6GnsDwNaZk/s320/New+Bitmap+Image.bmp" width="259" /></a></div>
<br />
<br />
<br />
that time after infopath preview it will show like this<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9nc5aPEn289kWwRh6MVkDlTJqj0jt9s0pNhtDfhz4SeWa5gvWXyV7PpWKkLHXOsDPV5-ROOkr4aDpKYBnwpAmONApso7U4-IJEthX1Ia8VDdPhe3UVgHGw-2fCLzrTpy0NRdl4gc272M/s1600/New+Bitmap+Image+(2).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" oya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9nc5aPEn289kWwRh6MVkDlTJqj0jt9s0pNhtDfhz4SeWa5gvWXyV7PpWKkLHXOsDPV5-ROOkr4aDpKYBnwpAmONApso7U4-IJEthX1Ia8VDdPhe3UVgHGw-2fCLzrTpy0NRdl4gc272M/s1600/New+Bitmap+Image+(2).bmp" /></a></div>
<br />
<br />
<br />
TO RESOLVE this remove this control and first add textbox and change it to dropdown after change datatype to Number(after that change the dataentries if u want shown in first image)<br />
<br />
<br /><br />
<br /></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-72601989640565900452013-06-25T00:44:00.000-07:002013-06-25T02:22:31.925-07:00Jquery with sharepoint list basics<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u>Jquery basics with sharepoint list</u></strong><br />
<br />
<strong>Reference urls: <a href="http://geekswithblogs.net/SoYouKnow/archive/2011/08/20/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-amp-setting-sharepoint.aspx">http://geekswithblogs.net/SoYouKnow/archive/2011/08/20/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-amp-setting-sharepoint.aspx</a> </strong><br />
<br />
<a href="http://geekswithblogs.net/SoYouKnow/archive/2011/07/28/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-started.aspx">http://geekswithblogs.net/SoYouKnow/archive/2011/07/28/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-started.aspx</a><br />
<br />
<a href="http://geekswithblogs.net/SoYouKnow/archive/2011/04/06/setting-sharepoint-drop-down-lists-w-jquery---20-items.aspx">http://geekswithblogs.net/SoYouKnow/archive/2011/04/06/setting-sharepoint-drop-down-lists-w-jquery---20-items.aspx</a><br />
<br />
<br />
<br />
<input type=”text” id=”myText”><br />
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style><br />
<pre class="csharpcode"><strong>$(“#myText”)--->calling id</strong> </pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style><br />
“title” is an ATTRIBUTE of the element, and the value of that attribute is our SharePoint field’s display name. <br />
<strong>$(“input[title=’My Text Field’]”)-->calling sharepoint field (My Text Field)</strong><br />
<br />
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style>So, the above jQuery says “Search all the input elements for one with the attribute of title with a value of “My Text Field”. <br />
<br />
<strong>Getting & Setting SharePoint Form Fields</strong><br />
<br />
//getting the value from list field My Text Field<br />
<pre class="csharpcode"><span class="kwrd">var</span> textValue = $(“input[title=’My Text Field’]”).val();</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style>To set the value we would use:<br />
<pre class="csharpcode">$(“input[title=’My Text Field’]”).val(textValue);</pre>
<div class="csharpcode">
<br /></div>
<div class="csharpcode">
<br /></div>
<div class="csharpcode">
<span style="color: red;">the value is equal to some text that time(Similar to all the senerios)</span></div>
<div class="csharpcode">
<br /></div>
//getting the value from list field My Text Field is No<br />
<pre class="csharpcode"><span class="kwrd">var</span> textValue = $(“input[title=’My Text Field’]”.val=="NO");</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style>To set the value we would use:<br />
<pre class="csharpcode">$(“input[title=’My Text Field’]”).val(textValue);</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style><br />
<h3>
Lookup and Choice fields</h3>
getting and setting this field are:<br />
<pre class="csharpcode"><span class="kwrd">var</span> mySelectValue = $(“select[title=’My Choice’]”).val();
$(“select[title=’My Choice’]”).val(mySelectValue);</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style>It is important to note that you are setting and getting the option Value, not the displayed text. Also, if you go above 20 items things get really funky if you are using IE. Luckily I already did a whole blog post on that:<br />
<a href="http://sharepointhillbilly.com/archive/2011/04/06/setting-sharepoint-drop-down-lists-w-jquery---20-items.aspx"><em><strong>Setting SharePoint Lookup Lists w/ jQuery (+/- 20 items)</strong></em></a><br />
<h3>
Date Fields</h3>
<br />
Getting and setting that value would be:<br />
<pre class="csharpcode"><span class="kwrd">var</span> myDateValue = $(“input [title=’My Date Field’]”).val();
$(“input [title=’My Date Field’]”).val(myDateValue);</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style><br />
<h3>
Checkboxes</h3>
<span class="kwrd">if</span>( $(<span class="str">"input[title='My Check box']"</span>).<span class="kwrd">is</span>(<span class="str">':checked'</span>)) <br />
{ <br />
alert(<span class="str">"it's checked"</span>); <br />
} <br />
If you want to check or uncheck a checkbox programmatically you simply need to set or remove the “checked” attribute of the element. To uncheck a checkbox:<br />
<pre class="csharpcode">$(<span class="str">"input[title='My Check box']"</span>).removeAttr(<span class="str">'checked'</span>);</pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style>To check a checkbox:<br />
<pre class="csharpcode">$(<span class="str">"input[title='My Check box']"</span>).attr(<span class="str">'checked'</span>,<span class="str">'checked'</span>); </pre>
<style type="text/css"><![CDATA[
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }]]></style><br />
<h3>
Dropdowns </h3>
<span style="background-color: white; color: #444444;">$(document).ready(function(){</span><br />
<span style="background-color: white; color: #444444;"> //Define which columns to show/hide by default</span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld1")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld2")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;">$('nobr:contains("fld3")').closest('tr').hide();</span><br />
<br />
<span style="background-color: white; color: #444444;">//Show/hide columns based on Drop Down Selection </span><br />
<span style="background-color: white; color: #444444;">$("select[title='dp3']").change(function() {</span><br />
<span style="background-color: white; color: #444444;"> if ($("select[title='dp3']").val() == "NO") { </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld3")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> } else if($("select[title='dp3']").val() == "YES"){ </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld3")').closest('tr').show();</span><br />
<span style="background-color: white; color: #444444;"> } </span><br />
<span style="background-color: white; color: #444444;"> });</span></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com1tag:blogger.com,1999:blog-3223289884932252033.post-32703373666848255062013-06-21T04:03:00.002-07:002013-06-21T04:03:22.469-07:00color coading to sharepoint list columns using javascript(with out calculate columns)<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u>color coading to sharepoint list columns using javascript(with out calculate columns)</u></strong><br />
<br />
i have Status column with three status Red,Amber,Green<br />
<br />
Add this code in sharepoint list(ALLITEMS.ASPX) content editor webpart.different column is having any of this status (Red,Amber,Green) that place also color coading will work automatically<br />
<br />
<br />
<strong><u>Code</u></strong><br />
<br />
<script src="/sites/testingsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><br /><script type="text/javascript">$(document).ready(function(){<br />
$(".ms-formbody:contains('Red')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" redstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-formbody:contains('Amber')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" amberstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
$(".ms-formbody:contains('Green')").each(function()<br />{<br />
if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" greenstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
$(".ms-vb2:contains('Red')").each(function()<br />{<br />if( $(this).text()=="Red")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" redstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-vb2:contains('Amber')").each(function()<br />{<br />if( $(this).text()=="Amber")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" amberstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />$(".ms-vb2:contains('Green')").each(function()<br />{<br />
if( $(this).text()=="Green")<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" greenstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />});</script><br /><style type="text/css"><br />.redstatus{<br />padding:2px; border: 1px red; background-color:red;color:#FFFFFF;width:80px;<br />}<br />.amberstatus{<br />padding:2px; border: 1px orange; background-color:orange;color:#FFFFFF;width:80px;<br />}<br />.greenstatus{<br />padding:2px; border: 1px green; background-color:green;color:#FFFFFF;width:80px;<br />}<br /></style><br />
<br />
Screenshot<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYY-YNSfGkkpnNEvIPPvlxSdf_RL8ePZQ9QFQFg9PDhIWk19qsR4oQlz2B1lv02Jf6PIJR7uazcpWWWQe0VSPTIo0ziWZXcqWp4K_7POB6jr0MnNmkQtiPDgfNHHwQeHPStjf2GgU0Hro/s1600/New+Bitmap+Image.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYY-YNSfGkkpnNEvIPPvlxSdf_RL8ePZQ9QFQFg9PDhIWk19qsR4oQlz2B1lv02Jf6PIJR7uazcpWWWQe0VSPTIo0ziWZXcqWp4K_7POB6jr0MnNmkQtiPDgfNHHwQeHPStjf2GgU0Hro/s320/New+Bitmap+Image.bmp" width="320" wya="true" /></a></div>
<br />
<br />
After adding the different status Processcheck with statuses Inprogress,Completed,Resolved<br />
<br />
<strong><u>Here is the code</u></strong><br />
<br />
<script src="/sites/magellanreporting/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><br /><script type="text/javascript">$(document).ready(function(){<br />
$(".ms-formbody:contains('Red')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" redstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-formbody:contains('Amber')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" amberstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
$(".ms-formbody:contains('Green')").each(function()<br />{<br />
if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" greenstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />$(".ms-formbody:contains('Inprogress')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" inprogresstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-formbody:contains('Completed')").each(function()<br />{ <br />if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" completedstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
$(".ms-formbody:contains('Resolved')").each(function()<br />{<br />
if( $(this).html().toLowerCase().indexOf("div")==-1)<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+="resolvedstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />$(".ms-vb2:contains('Red')").each(function()<br />{<br />if( $(this).text()=="Red")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" redstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-vb2:contains('Amber')").each(function()<br />{<br />if( $(this).text()=="Amber")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" amberstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />$(".ms-vb2:contains('Green')").each(function()<br />{<br />
if( $(this).text()=="Green")<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" greenstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />$(".ms-vb2:contains('Inprogress')").each(function()<br />{<br />if( $(this).text()=="Inprogress")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" inprogressstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV); <br />}<br />});<br />
$(".ms-vb2:contains('Completed')").each(function()<br />{<br />if( $(this).text()=="Completed")<br />{<br /> var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" completedstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />$(".ms-vb2:contains('Resolved')").each(function()<br />{<br />
if( $(this).text()=="Resolved")<br />{<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.className+=" resolvedstatus";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />}<br /> });<br />
<br />});</script><br /><style type="text/css"><br />.redstatus{padding:2px; border: 1px red; background-color:red;color:#FFFFFF;width:80px;}<br />.amberstatus{padding:2px; border: 1px orange; background-color:orange;color:#FFFFFF;width:80px;}<br />.greenstatus{padding:2px; border: 1px green; background-color:green;color:#FFFFFF;width:80px;}<br />.inprogressstatus{padding:2px; border: 1px blue; background-color:blue;color:#FFFFFF;width:80px;}<br />.completedstatus{padding:2px; border: 1px Brown; background-color:Brown;color:#FFFFFF;width:80px;}<br />.resolvedstatus{padding:2px; border: 1px Purple; background-color:Purple;color:#FFFFFF;width:80px;}<br /></style><br />
<br />
<br />
Screenshot<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlRYGMt6_eP7OIs8avSuKpG_N_x4DlXz1rUv6g6YaJomC0yfg5xhYCP72vV5l3KNbxPHKvC_xxgkvMmHPvpJaEYINKbarM2KDFOdNxVRFlLdUI-fn1TjN5WzedqyeMc1r-GGrs-IITR9I/s1600/New+Bitmap+Image+(2).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="87" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlRYGMt6_eP7OIs8avSuKpG_N_x4DlXz1rUv6g6YaJomC0yfg5xhYCP72vV5l3KNbxPHKvC_xxgkvMmHPvpJaEYINKbarM2KDFOdNxVRFlLdUI-fn1TjN5WzedqyeMc1r-GGrs-IITR9I/s320/New+Bitmap+Image+(2).bmp" width="320" wya="true" /></a></div>
<br />
<br />
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-27494738228044280202013-06-21T02:44:00.002-07:002013-06-21T02:47:27.598-07:00Groupby choice column using dataview webpart<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u>Groupby choice column using dataview webpart</u></strong><br />
<br />
<strong>Reference url: <a href="http://technology.feedfury.com/content/38130758-solved-can-t-group-by-choice-column-in-sharepoint-list-view.html">http://technology.feedfury.com/content/38130758-solved-can-t-group-by-choice-column-in-sharepoint-list-view.html</a></strong><br />
<br />
<span style="color: #6fa8dc;"><span style="color: #3d85c6;">To group by a Choice field which allows multiple selections (checkboxes), convert the Web Part to a Data View using SharePoint Designer, then apply grouping doing the following: 1. From the "Common Data View Tasks" menu for the Data View Web Part, select "Sort and Group:" from the options to open the Sort and Group Dialog, add any field into the Sort Order section to activate the "Edit Sort Expression..." button. Click the "Edit Sort Expression..." button to open the Advanced Sort Dialog. 2. From the list of fields, add the Choice field, and make sure that the field reference is the only value in the "Edit the XPath expression" input. The field reference should begin with an @ symbol followed by the internal name of the SharePoint column/field (example: @Location). The value from the selected column will display in the Preview box if items in the list/library match the specified criteria, which in this case is a simple column/field value (no conditions or calculations required). 3. Press OK on to close the Advanced Sort Dialog. Select the Choice Field from the list of fields in the "Sort Order:" box, then select "Show Group Header" under Group Properties. This will result in items being grouped by the value in the choice field which allows multiple selections.</span></span><br />
<strong><u>Steps to follow for Dataview webpart</u> (Ignore Above)</strong><br />
<br />
1)By defaultly<strong> </strong>list comes with xslt list view webpart (use allitems.aspx or create custom view for all items.aspx(make it as default view)) <br />
<br />
remove that xslt webpart-->goto insert add -->empty data view--> select datasource that list name---><br />
<br />
after that screen visible like this.in this select appropriate fields using ctrl button shown in the form(data source details)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX7fmzJKFFCNdp4QmyArCxNCkIabGM0pt4wsHWkH6QOxxxX0pfZagXmYFpW0evkBZmvAnqFoJo0lj_EO6lMQgtZXPb5gdLjwMDv6zf5KnGIHVLatdlMtHLaRpgLXoduXVwBYoPnToNA88/s1600/New+Bitmap+Image.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjX7fmzJKFFCNdp4QmyArCxNCkIabGM0pt4wsHWkH6QOxxxX0pfZagXmYFpW0evkBZmvAnqFoJo0lj_EO6lMQgtZXPb5gdLjwMDv6zf5KnGIHVLatdlMtHLaRpgLXoduXVwBYoPnToNA88/s400/New+Bitmap+Image.bmp" width="400" wya="true" /></a></div>
<br />
<br />
After that select multiple field view from Insert select field as aashown in the above diagram<br />
<br />
select the dtaview webpart and select the sort and group from the Options in Menu<br />
<br />
it will show one popup from there select Add sort expression<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTU1lDFE1zzi3o9lQ929spiZLsKbB6Uu_3qJ4JewWbOoXwUhLZ9vfFHj4eNb-_qz9lJbXdJrRFO7Sem46YJLQZWkGkhuDxFFX3ezbw0i6zW9a1_xPgV9hVCPNXio0wbs7aVSbwWt82VQA/s1600/New+Bitmap+Image+(2).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTU1lDFE1zzi3o9lQ929spiZLsKbB6Uu_3qJ4JewWbOoXwUhLZ9vfFHj4eNb-_qz9lJbXdJrRFO7Sem46YJLQZWkGkhuDxFFX3ezbw0i6zW9a1_xPgV9hVCPNXio0wbs7aVSbwWt82VQA/s320/New+Bitmap+Image+(2).bmp" width="320" wya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Clixk on add and select the choice field<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaP9thL72DzyrnxUxYfjrwDqxrNETnWogIcpotZ788mHPaLtwy2v5tVYW3lDL4MZ667qrlQXQd5vOIAlDQ4Arsa-hDc60Ff3H2UbRTKDFwUMCfY5ncsHURxwdD7RamuLIyRrN9yi7hnWY/s1600/New+Bitmap+Image+(3).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaP9thL72DzyrnxUxYfjrwDqxrNETnWogIcpotZ788mHPaLtwy2v5tVYW3lDL4MZ667qrlQXQd5vOIAlDQ4Arsa-hDc60Ff3H2UbRTKDFwUMCfY5ncsHURxwdD7RamuLIyRrN9yi7hnWY/s320/New+Bitmap+Image+(3).bmp" width="320" wya="true" /></a></div>
<br />
<br />
Click on ok. Select group header after that(shown below)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6hiFbcTckGDA9WKhOHI35CJUxqvWL5K2veoURT2poc5wR5MG82F7chyphenhyphen6wYDkY4ghLM_nEnGgzn55SJr-uAGMwaZX7gT7asV2HfIuwbsB4J33aBpcRRp7FG6A3dgzVRlLFndxbuyypA4c/s1600/New+Bitmap+Image+(4).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6hiFbcTckGDA9WKhOHI35CJUxqvWL5K2veoURT2poc5wR5MG82F7chyphenhyphen6wYDkY4ghLM_nEnGgzn55SJr-uAGMwaZX7gT7asV2HfIuwbsB4J33aBpcRRp7FG6A3dgzVRlLFndxbuyypA4c/s1600/New+Bitmap+Image+(4).bmp" wya="true" /></a></div>
<br />
after that it will show like below.if you want to enable insert, delete, edit, operations inside the form then select the options inside the inline editing<br />
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqCs164BclJ_-H6OHaaW3ctUuA86jPzqOPKs8jJZ1ppuj5sG8XeSr5O2o2_qHk6F66jQJChTzg7a5iHzyusRlbmASZxvbZoCnkNjNRVdllUChUEvBtROagl8eE0qH-cyeEnz1cKaYAjJM/s1600/New+Bitmap+Image+(5).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqCs164BclJ_-H6OHaaW3ctUuA86jPzqOPKs8jJZ1ppuj5sG8XeSr5O2o2_qHk6F66jQJChTzg7a5iHzyusRlbmASZxvbZoCnkNjNRVdllUChUEvBtROagl8eE0qH-cyeEnz1cKaYAjJM/s320/New+Bitmap+Image+(5).bmp" width="320" wya="true" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvUSxP3sGr0tawIUvQ2MyeDHbV3nM7xVzu88qIxBtv5h9BY73b6PlSBehOnWNVDRTyGD8F6oDnedEXD6bQiWGO5LEc4lBbyjFNhndrQwRhNta9-IfRaS1N9dtxA13Rgbh9x3JbirnBNfI/s1600/New+Bitmap+Image+(6).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvUSxP3sGr0tawIUvQ2MyeDHbV3nM7xVzu88qIxBtv5h9BY73b6PlSBehOnWNVDRTyGD8F6oDnedEXD6bQiWGO5LEc4lBbyjFNhndrQwRhNta9-IfRaS1N9dtxA13Rgbh9x3JbirnBNfI/s320/New+Bitmap+Image+(6).bmp" width="320" wya="true" /></a></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com1tag:blogger.com,1999:blog-3223289884932252033.post-50956749020979054192013-06-20T23:13:00.001-07:002013-06-20T23:14:23.698-07:00Page loading status or progressbar using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u><span style="color: #45818e;">Page loading status or progressbar using javascript</span></u></strong><br />
<br />
<strong><span style="color: #45818e;">Reference url: <a href="http://spjsblog.com/2013/05/06/dynamic-forms-for-sharepoint-now-with-field-tooltip/">http://spjsblog.com/2013/05/06/dynamic-forms-for-sharepoint-now-with-field-tooltip/</a></span></strong><br />
<br />
<span style="color: #45818e;">Add this code in page content editor webpart</span><br />
<br />
<style type="text/css"><br />
.dffsOverlay{<br />
font-size:16px;<br />
padding-top:100px;<br />
text-align:center;<br />
width:100%;<br />
height:100%;<br />
background-color:#F5F5F5;<br />
position:absolute;<br />
top:0;<br />
left:0;<br />
z-index:9999;<br />
cursor:default;<br />
}<br />
</style><br />
<div id='dffs_loadingOverlay' class='dffsOverlay'>Loading, please wait...</div><br />
<script type="text/javascript"><br />
setTimeout(function(){<br />
var oDiv = document.getElementById("dffs_loadingOverlay");<br />
if(oDiv !== null){<br />
oDiv.innerHTML = "<span style='font-size:20px'><br><br>Click to View the Form.</span>";<br />
oDiv.onclick = function(){<br />
this.parentNode.removeChild(this);<br />
};<br />
}<br />
},5000);<br />
</script></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-41230629452681544302013-06-20T06:09:00.002-07:002013-06-21T00:21:00.151-07:00Assign sharepoint list field values using javascript(Ecmascript)<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
Refer the below link<span style="color: red;">:http://spjsblog.com/2010/05/28/get-or-set-value-for-sharepoint-field-in-newform-editform-and-dispform-get-only-in-dispform/</span><br />
<br />
<a href="http://www.c-sharpcorner.com/UploadFile/anavijai/get-and-set-the-list-item-value-in-sharepoint-2010-using-ecm/">http://www.c-sharpcorner.com/UploadFile/anavijai/get-and-set-the-list-item-value-in-sharepoint-2010-using-ecm/</a><br />
<br />
<br />
Add the script in List newform.aspx or editform.aspx(after editing the item) or dispform.aspx Content editor webpart.(sometimes functionality doesnt work that time add the content editor webpart below the form<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje0SZwOaW2TQ0r393Ybw2HkSd3yTg6___Pmoc59pI-DoBm9GvUsjRX1fPBfh0cjmett8I4wVnZyse1xvdUn1IbD8hic_cQbB0LqVEFqMZCQgBXTml_0W4_h9lwJmjjuwt2qhvNNj1NEp4/s1600/New+Bitmap+Image+(3).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje0SZwOaW2TQ0r393Ybw2HkSd3yTg6___Pmoc59pI-DoBm9GvUsjRX1fPBfh0cjmett8I4wVnZyse1xvdUn1IbD8hic_cQbB0LqVEFqMZCQgBXTml_0W4_h9lwJmjjuwt2qhvNNj1NEp4/s320/New+Bitmap+Image+(3).bmp" width="320" wya="true" /></a></div>
<br />
<br />
<br />
<br />
<br /><br />
Maintain both Content editor webpart and form into single div)<br />
<br />
<br />
<span style="color: #6aa84f;"><</span><span style="color: black;">script src="/sites/newsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script src="/sites/newsite/SiteAssets/spjs-utility.js" type="text/javascript"></script><script type="text/javascript"></span><br />
<span style="color: black;">function PreSaveAction() <br />{<br />fields = init_fields_v2();</span><br />
<span style="color: black;">// Get value from a multicheck field(multi selection check box value)<br />var myRichTextValue = getFieldValue('Statuscheck');</span><br />
<span style="color: black;">// set the value to assignfield(single line text field)<br />setFieldValue('assignedfield',myRichTextValue);<br />return true;<br />}</script></span><br />
<br />
<br />
Presaveaction(will save the form actions at the time of clicking the save button)<br />
<br />
Statuscheck:checkbox with multiple selection<br />
assignedfield':single line text field<br />
<br />
Download the spjs-utility.js :<strong><span style="color: red;">http://spjsfiles.com/index.php?dir=SharePoint+JavaScripts%2Fspjs-utility%2F </span></strong><br />
<br />
<span style="color: black;">code to itterating through each and choice in checkbox using jquery</span><br />
<br />
Follow the same steps like above<br />
<br />
<span style="color: black;"><script src="/sites/newsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script src="/sites/newsite/SiteAssets/spjs-utility.js" type="text/javascript"></script><script type="text/javascript"></span><br />
<br />
<span style="color: black;">function PreSaveAction() <br />{<br />fields = init_fields_v2();</span><br />
<span style="color: black;">// Get value from a multicheck field(multi selection check box value)<br />var myRichTextValue = getFieldValue('Statuscheck');<br />if (myRichTextValue == "A") {<br /> setFieldValue('assignedfield',"A");<br /> }<br /> else if (myRichTextValue == "B") {<br /> setFieldValue('assignedfield',"B");<br /> }<br /> else if (myRichTextValue == "C") {<br /> setFieldValue('assignedfield',"C");<br /> }<br />// set the value to assignfield(single line text field)<br />setFieldValue('assignedfield',myRichTextValue);<br />alert(myRichTextValue);<br />return true;<br />}</script></span><br />
<br />
<br />
<br />
<strong><u>Assign sharepoint list field values using Ecmascript</u></strong><br />
Refer the below link:<a href="http://www.c-sharpcorner.com/UploadFile/anavijai/get-and-set-the-list-item-value-in-sharepoint-2010-using-ecm/">http://www.c-sharpcorner.com/UploadFile/anavijai/get-and-set-the-list-item-value-in-sharepoint-2010-using-ecm/</a><br />
Add this code in list content editor webpart(Allitem.aspx page) or content place holder main in sharepoint designer allitems.aspx page<br />
<br />
<script language="ecmascript" type="text/ecmascript"><br />
var listItem;<br />
var list;<br />
var clientContext;<br />
function getSetListItem() {<br />
var uid=document.getElementById('textbox1').value;<br />
this.clientContext = SP.ClientContext.get_current();<br />
if (this.clientContext != undefined && clientContext != null) {<br />
var webSite = clientContext.get_web();<br />
this.list = webSite.get_lists().getByTitle("Assignvalue");<br />
this.listItem = list.getItemById(uid);<br />
clientContext.load(this.listItem);<br />
this.clientContext.executeQueryAsync(Function.createDelegate(this, this.OnLoadSuccess),<br />
Function.createDelegate(this, this.OnLoadFailed));<br />
}<br />
} <br />
function OnLoadSuccess(sender, args) {<br />
var value = this.listItem.get_item("Multicheck");<br />
alert("value");<br />
this.listItem.set_item("assignfield", value);<br />
this.listItem.update();<br />
this.clientContext.load(this.listItem);<br />
this.clientContext.executeQueryAsync(Function.createDelegate(this, this.OnLoadSuccess1),<br />
Function.createDelegate(this, this.OnLoadFailed));<br />
} <br />
function OnLoadSuccess1(sender, args) {<br />
alert(this.listItem.get_item("assignfield"));<br />
} <br />
function OnLoadFailed(sender, args) {<br />
alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());<br />
}</script><input id="textbox1" type="text"/>&#160; <input id="btnGetSetListItem" onclick="getSetListItem()" type="button" value="Get &amp; Set List Item"/> <br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKW5bWT5DBBKXBg84oDCV7qhl4o00-v0rcywkIbCWivzzX-gzOFazh6EmAG-Ords-R9hwL2Kii33YCK7VmdPrE3Px3gACusrp5562bv9S399WNJ5pz9bX4K9Gt0m7nMbHLF_ydgu7VDU/s1600/New+Bitmap+Image+(4).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKW5bWT5DBBKXBg84oDCV7qhl4o00-v0rcywkIbCWivzzX-gzOFazh6EmAG-Ords-R9hwL2Kii33YCK7VmdPrE3Px3gACusrp5562bv9S399WNJ5pz9bX4K9Gt0m7nMbHLF_ydgu7VDU/s320/New+Bitmap+Image+(4).bmp" width="320" wya="true" /></a></div>
<br /><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
<br />
<br />
<br /></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-53910554525266956312013-06-19T04:39:00.001-07:002013-06-19T04:39:12.938-07:00Hiding perticular controls based on sharepoint group<div dir="ltr" style="text-align: left;" trbidi="on">
Hiding perticular controls based on sharepoint group<br />
<br />
<a href="http://ankursharepoint.blogspot.in/2012/11/hide-controls-for-particular-sharepoint.html">http://ankursharepoint.blogspot.in/2012/11/hide-controls-for-particular-sharepoint.html</a></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-89437860993767239822013-06-19T04:38:00.001-07:002013-06-19T04:38:23.489-07:00Getting the user details using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
<strong><u>Getting the user details using javascript</u></strong><br />
<br />
<strong><u>Refer the below urls</u></strong><br />
<br />
<a href="http://spjsblog.com/2012/01/08/pull-user-list-property-from-people-picker-and-write-to-separate-textfield/">http://spjsblog.com/2012/01/08/pull-user-list-property-from-people-picker-and-write-to-separate-textfield/</a><br />
<br />
<br />
<a href="http://spjsblog.com/2011/09/18/pull-e-mail-from-people-picker-and-write-to-a-separate-textfield-updated-version/">http://spjsblog.com/2011/09/18/pull-e-mail-from-people-picker-and-write-to-a-separate-textfield-updated-version/</a><br />
<br />
<br />
<a href="http://spjsblog.com/2010/04/06/pull-e-mail-from-people-picker-and-write-to-a-separate-textfield/">http://spjsblog.com/2010/04/06/pull-e-mail-from-people-picker-and-write-to-a-separate-textfield/</a><br />
<br />
<br />
<a href="http://spjsblog.com/2010/02/16/filter-list-view-based-on-membership-in-sharepoint-group/" rel="bookmark" title="Permanent Link to Filter list view based on membership in SharePoint group"><strong><span style="color: black;">Filter list view based on membership in SharePoint group</span></strong></a> <br />
<br />
<br />
<a href="http://spjsblog.com/2010/02/16/filter-list-view-based-on-membership-in-sharepoint-group/">http://spjsblog.com/2010/02/16/filter-list-view-based-on-membership-in-sharepoint-group/</a><br />
<br />
<br />
Hiding perticular controls based on sharepoint group<br />
<br />
<a href="http://ankursharepoint.blogspot.in/2012/11/hide-controls-for-particular-sharepoint.html">http://ankursharepoint.blogspot.in/2012/11/hide-controls-for-particular-sharepoint.html</a></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-10013973163736903662013-06-19T03:26:00.002-07:002013-06-19T03:47:47.656-07:00Sharepoint list item querystring id using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><strong><u>Sharepoint list item querystring id using javascript</u></strong></span></div>
<div dir="ltr">
</div>
<div dir="ltr">
</div>
<div dir="ltr">
<br />
<span style="font-family: Segoe UI; font-size: x-small;">Easy way</span><br />
<br />
<span style="font-family: Segoe UI; font-size: x-small;">Add this code in content editor webpart or content placeholder main in sharepoint designer(dispform.aspx or editform.aspx)</span><br />
<br />
<script type="text/javascript"><br />
<br />
var itemId = GetUrlKeyValue("ID");<br />alert(itemId);</script><br />
<br />
<br />
<span style="color: red; font-family: Segoe UI; font-size: x-small;">(OR)</span><br />
<br />
<div dir="ltr">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;">Add this code in content place holder main(allitems.aspx,dispform.aspx.......) or content editor webpart</span></div>
<div dir="ltr">
</div>
<div dir="ltr">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><script type="text/javascript"><br />//Call the javascript function in page load<br />onload=function()<br />{<br /> var query = location.search.substring(1);<br /> var SplitQuerry=query.split('&');<br /> var SplitId= SplitQuerry[0];<br /> var Id=SplitId.split('=');<br /> alert(Id);<br />}<br /></script></span><br />
<br />
<br />
<br />
</div>
</div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-72788732136617699832013-06-13T05:47:00.003-07:002013-06-17T02:45:24.908-07:00Parent-child data filter using query string id<div dir="ltr" style="text-align: left;" trbidi="on">
<u><strong>Firstway:</strong></u>(will work only for by default list dispform.doesnt work to the custom dispform.aspx)<br />
<br />
Create two lists one is parent and another one is child .child list contains a lookup as parent list<br />
<br />
list advanced settings -->set modal popup to-->No(last option)<br />
after that goto parent list -->click on any item dispform-->Edit page-->Click on list below-->insert Related list<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyE2qobhw766CyzcEbdJ68e2qtV3XlryCa2yHB-l87yRHGkM0avHakzmDtyvu1HlF06qmy74Eb3QOBQyw05OIoO5AHwJhSUXi8nqj7FMCf8TTFa8zNGE7v_BgNkAC9M8g9QCGpJTb9Zvg/s1600/New+Bitmap+Image.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyE2qobhw766CyzcEbdJ68e2qtV3XlryCa2yHB-l87yRHGkM0avHakzmDtyvu1HlF06qmy74Eb3QOBQyw05OIoO5AHwJhSUXi8nqj7FMCf8TTFa8zNGE7v_BgNkAC9M8g9QCGpJTb9Zvg/s1600/New+Bitmap+Image.bmp" /></a></div>
After that data directly filter based on parent item<br />
<br />
<strong><u>Secondwayway:</u></strong>(will work custom dispform and by default list form)<br />
<br />
Create two lists one is parent and another one is child .child list contains a lookup as parent list<br />
<br />
Given lookup parent title with id in childlist<br />
<br />
list advanced settings -->set modal popup to-->No(last option)<br />
<br />
after that goto parent list -->click on any item dispform-->Edit page-->Addwebpart-->list and libraries-->select child list<br />
<br />
here the child list will come above parent in dispform .if u want below then goto Sharepoint designer -->parentlist dispform-->design-->cut the child list content-->paste below the parent (both the parent and child will be in single table and single div)-->save<br />
<br />
Goto parent dispform in desigener and follow the below steps<br />
In side of "xsltListviewwebpart, on your page add below lines....<br />
<br />
Add below line in <ParameterBindings<a href="http://www.blogger.com/null"></a>><br />
<br />
<ParameterBinding<a href="http://www.blogger.com/null"></a> Name="Param1<a href="http://www.blogger.com/null"></a>" Location="QueryString<a href="http://www.blogger.com/null"></a>(ID)" DefaultValue<a href="http://www.blogger.com/null"></a>="" /><br />
<br />
After that add below line in "<Query>"<br />
<Where><br />
<Eq<a href="http://www.blogger.com/null"></a>><br />
<FieldRef<a href="http://www.blogger.com/null"></a> Name="Workstream_x003a_ID<a href="http://www.blogger.com/null"></a>"/><br />
<Value Type="Text">{Param1<a href="http://www.blogger.com/null"></a>}</Value><br />
</Eq<a href="http://www.blogger.com/null"></a>><br />
</Where><br />
<br />
<br />
<span style="color: red;">Workstream_x003a_ID</span>---->Child llokup parent ID field in child list. child list thename isWorkstream_x003a_ID<br />
<span style="color: red;">Param1:</span><span style="color: black;">query string id in the url</span><br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhY8-jKF7GLdBQSzJCPF9tOLVmh23gGZCEiC-9DtM0aSMUoBm2D4wfDBx8d4t6BmV3R3b0LUe4CoSgkw_UR9pUn6ZnBsnPgpD15wKmrZBu7IpCxtlYKjfBXcOKcN8YQBbbW3qpjq60MWWs/s1600/New+Bitmap+Image+(2).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhY8-jKF7GLdBQSzJCPF9tOLVmh23gGZCEiC-9DtM0aSMUoBm2D4wfDBx8d4t6BmV3R3b0LUe4CoSgkw_UR9pUn6ZnBsnPgpD15wKmrZBu7IpCxtlYKjfBXcOKcN8YQBbbW3qpjq60MWWs/s1600/New+Bitmap+Image+(2).bmp" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-45956749909637445072013-06-12T03:34:00.003-07:002013-06-21T03:37:36.929-07:00Color code status indicator to sharepoint list column using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
Reference url:<br />
<a href="http://www.sharepointkings.com/2010/04/sharepoint-custom-so-called-kpi.html">http://www.sharepointkings.com/2010/04/sharepoint-custom-so-called-kpi.html</a><br />
<br />
<g_vml_:shape coordsize="6170,26950" fillcolor="white" filled="t" path=" m0,100 l0,26770 at0,26770,200,26970,-950,26820,50,27820 l6010,26970 at6010,26770,6210,26970,6060,27820,7060,26820 l6210,100 at6010,0,6210,200,7060,50,6060,-950 l100,0 at0,0,200,200,50,-950,-949,100 e" stroked="f" style="height: 2694px; left: 0px; position: absolute; top: 0px; width: 618px;"><g_vml_:fill opacity="1"></g_vml_:fill></g_vml_:shape><g_vml_:shape coordsize="6170,26950" fillcolor="black" filled="f" path=" m0,95 l0,26875 at0,26770,200,26970,-950,26820,297,27789 e" strokecolor="#ddd" stroked="t" strokeweight=".75pt" style="height: 2694px; left: 0px; position: absolute; top: 0px; width: 618px;"><g_vml_:stroke endcap="flat" joinstyle="miter" miterlimit="10" opacity="1"></g_vml_:stroke></g_vml_:shape><g_vml_:shape coordsize="6170,26950" fillcolor="black" filled="f" path=" m100,26970 l6115,26970 at6010,26770,6210,26970,6060,27820,7060,26820 e" strokecolor="#ddd" stroked="t" strokeweight=".75pt" style="height: 2694px; left: 0px; position: absolute; top: 0px; width: 618px;"><g_vml_:stroke endcap="flat" joinstyle="miter" miterlimit="10" opacity="1"></g_vml_:stroke></g_vml_:shape><g_vml_:shape coordsize="6170,26950" fillcolor="black" filled="f" path=" m6210,26870 l6210,95 at6010,0,6210,200,7060,50,6060,-950 e" strokecolor="#ddd" stroked="t" strokeweight=".75pt" style="height: 2694px; left: 0px; position: absolute; top: 0px; width: 618px;"><g_vml_:stroke endcap="flat" joinstyle="miter" miterlimit="10" opacity="1"></g_vml_:stroke></g_vml_:shape><g_vml_:shape coordsize="6170,26950" fillcolor="black" filled="f" path=" m6110,0 l100,0 at0,0,200,200,297,-919,-919,297 e" strokecolor="#ddd" stroked="t" strokeweight=".75pt" style="height: 2694px; left: 0px; position: absolute; top: 0px; width: 618px;"><g_vml_:stroke endcap="flat" joinstyle="miter" miterlimit="10" opacity="1"></g_vml_:stroke></g_vml_:shape><br />
<div class="post-outer" closure_uid_597227320="5" style="background: none transparent scroll repeat 0% 0%; border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; left: 1px; margin: 0px; position: relative; top: 1px;">
<div class="post hentry" itemprop="blogPost" itemscope="itemscope" itemtype="http://schema.org/BlogPosting">
<a href="https://www.blogger.com/null" name="8231563679017032192"></a><br />
<h3 class="post-title entry-title" itemprop="name">
Sharepoint Custom so called KPI </h3>
<div class="post-header">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" itemprop="description articleBody">
Hay Guys,<br />
<br />
In general KPI most of the time we are having simple requirement.<br />
<br />
Like if Risk is high or status is incomplete then it should show in RED.<br />
If Low then Green and Medium then orange.<br />
<br />
Same functionality we had done for listview webpart which show Red/green/yellow icon based on status.<br />
<br />
Here is the example<br />
In our list we had a column called criticality with dropdown values <br />
<br />
High<br />
Low<br />
Medium<br />
<br />
Check the screenshot below<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOq29tHkZK2xrpy7Eetmr_8Jw8zBChTp2v0Uo0Yl34ahgkxHjIzhvegctUH6WCruauW5lUTuc9cuudDJAj7AJG-OPFCSvDFI0oaAq53NFBsYjV0H-en1ynFvpoxvBsMGmNkGe7mums9NE/s1600/New+Bitmap+Image+(4).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOq29tHkZK2xrpy7Eetmr_8Jw8zBChTp2v0Uo0Yl34ahgkxHjIzhvegctUH6WCruauW5lUTuc9cuudDJAj7AJG-OPFCSvDFI0oaAq53NFBsYjV0H-en1ynFvpoxvBsMGmNkGe7mums9NE/s1600/New+Bitmap+Image+(4).bmp" /></a></div>
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
<br />
<br />
And check another one after what we had done.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhKXv5IJHrG1DQV9j54tqoxtPiaEuiLoxPkP3D4m46imu6zsGl62nhISnLQRGzhvHF1B_rcrPqIfxZ7pZkQniOvwbBkhvYO-vh9JIUPpD6BJdIAQ0fovy4-m74lBdVCySuEf9gzBG91fw/s1600/New+Bitmap+Image+(3).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhKXv5IJHrG1DQV9j54tqoxtPiaEuiLoxPkP3D4m46imu6zsGl62nhISnLQRGzhvHF1B_rcrPqIfxZ7pZkQniOvwbBkhvYO-vh9JIUPpD6BJdIAQ0fovy4-m74lBdVCySuEf9gzBG91fw/s1600/New+Bitmap+Image+(3).bmp" /></a></div>
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
<br />
<br /></div>
<br />
<br />
So you can see it looks like KPI<br />
This is similar like <br />
<a href="http://www.sharepointkings.com/2008/12/highlight-sharepoint-list-rows.html" target="_blank"><span style="color: #771100;">http://www.sharepointkings.com/2008/12/highlight-sharepoint-list-rows.html</span></a><br />
but everyone is asking regarding this KPI so we had done this.<br />
<br />
Now, What we had done <br />
It’s nothing just a trick of javascript/jquery<br />
Here is the code<br />
<blockquote>
<br />
$(document).ready(function() {<br />
var strURL = window.location.href;<br />
if ((strURL.toUpperCase().indexOf("Lists/Risk%20Management".toUpperCase()) != -1) ||<br />
(strURL.toUpperCase().indexOf("Lists/Risk Management".toUpperCase()) != -1)) {<br />
//alert('pp');<br />
$(".ms-vb2:contains('High')").each(function() {<br />
var tempDIV = document.createElement("DIV");<br />
tempDIV.style.cursor = "pointer";<br />
tempDIV.innerHTML = "<img src='_LAYOUTS/SPKings/Images/Red.gif' />"; //$(this).text();<br />
//alert($(this).html());<br />
$(this).text("");<br />
$(this).append(tempDIV);<br />
<br />
});<br />
$(".ms-vb2:contains('Low')").each(function() {<br />
var tempDIV = document.createElement("DIV");<br />
tempDIV.style.cursor = "pointer";<br />
tempDIV.innerHTML = "<img src='_LAYOUTS/SPKings/Images/Green.gif' />"; //$(this).text();<br />
//alert($(this).html());<br />
$(this).text("");<br />
$(this).append(tempDIV);<br />
<br />
});<br />
$(".ms-vb2:contains('Medium')").each(function() {<br />
var tempDIV = document.createElement("DIV");<br />
tempDIV.style.cursor = "pointer";<br />
tempDIV.innerHTML = "<img src='_LAYOUTS/SPKings/Images/Amber.gif' />"; //$(this).text();<br />
//alert($(this).html());<br />
$(this).text("");<br />
$(this).append(tempDIV);<br />
<br />
});<br />
$(".ms-vb2:contains('No Criticality')").each(function() {<br />
var tempDIV = document.createElement("DIV");<br />
tempDIV.style.cursor = "pointer";<br />
tempDIV.innerHTML = "<img src='_LAYOUTS/SPKings/Images/NoData.gif' />"; //$(this).text();<br />
//alert($(this).html());<br />
$(this).text("");<br />
$(this).append(tempDIV);<br />
<br />
});<br />
}<br />
<br />
});</blockquote>
<br />
<br />
What we had done is we are checking URL<br />
If it is out target list, then we apply javascript and as you can see we are finding High and replacing that with Red.gif.<br />
<br />
Same way for other criticality also<br />
<br />
You can use image from image library also. We had used images from layouts.<br />
<br />
Don’t forget to include jquery.JS to make it work.<br />
<br />
Guys, this is not recommended way for authentic KPI but for time being or for demo purpose where we are not having time and have to show a lot of thing this will act as icings on the cake</div>
</div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-52187870598908961352013-06-12T02:24:00.005-07:002013-06-13T02:31:47.938-07:00Show/Hide Columns based on dropdown selection<div dir="ltr" style="text-align: left;" trbidi="on">
<u><strong>Code:-</strong></u> <span style="color: #45818e;">Add this code in list dispform.aspx as a content editor webpart</span><br />
<br />
<span style="background-color: white; color: #444444;"><script src="/sites/Newsite1/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script type="text/javascript"></span><br />
<br />
<span style="background-color: white; color: #444444;">// Execute the following JavaScript after the page has fully loaded, when it's ".ready"</span><br />
<span style="background-color: white; color: #444444;">$(document).ready(function(){</span><br />
<span style="background-color: white; color: #444444;"> //Define which columns to show/hide by default</span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld1")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld2")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;">$('nobr:contains("fld3")').closest('tr').hide();</span><br />
<br />
<span style="background-color: white; color: #444444;">//Show/hide columns based on Drop Down Selection </span><br />
<span style="background-color: white; color: #444444;">$("select[title='dp3']").change(function() {</span><br />
<span style="background-color: white; color: #444444;"> if ($("select[title='dp3']").val() == "NO") { </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld3")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> } else if($("select[title='dp3']").val() == "YES"){ </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld3")').closest('tr').show();</span><br />
<span style="background-color: white; color: #444444;"> } </span><br />
<span style="background-color: white; color: #444444;"> });</span><br />
<span style="background-color: white; color: #444444;"> $("select[title='dp1']").change(function() {</span><br />
<span style="background-color: white; color: #444444;"> if ($("select[title='dp1']").val() == "NO") { </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld1")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> } else if($("select[title='dp1']").val() == "YES"){ </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld1")').closest('tr').show();</span><br />
<span style="background-color: white; color: #444444;"> } </span><br />
<span style="background-color: white; color: #444444;"> });</span><br />
<span style="background-color: white; color: #444444;">$("select[title='dp2']").change(function() {</span><br />
<span style="background-color: white; color: #444444;"> if ($("select[title='dp2']").val() == "NO") { </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld2")').closest('tr').hide();</span><br />
<span style="background-color: white; color: #444444;"> } else if($("select[title='dp2']").val() == "YES"){ </span><br />
<span style="background-color: white; color: #444444;"> $('nobr:contains("fld2")').closest('tr').show();</span><br />
<span style="background-color: white; color: #444444;"> } </span><br />
<span style="background-color: white; color: #444444;"> });</span><br />
<br />
<span style="background-color: white; color: #444444;">});</script></span><br />
<br />
<br />
<span style="color: #444444;">Default value for the dropdown is no.so currently fields are hided once you select the YES corresponding fields will be enable...</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQ_SGIrVJ-55Cp9H6ytR6G0yx0qSjbgnqUSqQlxcLQa9n-TGFiDR8c7NzDN-ibGQzUcMB-p97KKb3QCHzldrEEPxE_MoKrXHEpey-3N4GkJEAjEN0KtC6kUrdkKs4xkj0Z8PfkOUcXdnk/s1600/New+Bitmap+Image.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQ_SGIrVJ-55Cp9H6ytR6G0yx0qSjbgnqUSqQlxcLQa9n-TGFiDR8c7NzDN-ibGQzUcMB-p97KKb3QCHzldrEEPxE_MoKrXHEpey-3N4GkJEAjEN0KtC6kUrdkKs4xkj0Z8PfkOUcXdnk/s1600/New+Bitmap+Image.bmp" height="58" width="320" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigFJx8YV7z6geviGfvSNnYlbP0EVxEfSUKewle4XWc7WxJWEjk4qvdTIxzTmkZ2MfzCpLQNaRaqiiNdLx2Pnk0x8co7v9Mx5NlDUe0uRZ5KSn2_P1dlSPU9A0K3lAuXG4_ADJaQJaqwE4/s1600/New+Bitmap+Image+(2).bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" cya="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigFJx8YV7z6geviGfvSNnYlbP0EVxEfSUKewle4XWc7WxJWEjk4qvdTIxzTmkZ2MfzCpLQNaRaqiiNdLx2Pnk0x8co7v9Mx5NlDUe0uRZ5KSn2_P1dlSPU9A0K3lAuXG4_ADJaQJaqwE4/s1600/New+Bitmap+Image+(2).bmp" height="86" width="320" /></a></div>
<br />
<br />
<br />
Reference URL:<br />
<div dir="ltr" id="imcontent">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><a href="http://bingggg.blogspot.in/2011/11/showhide-columns-based-on-drop-down.html" title="http://bingggg.blogspot.in/2011/11/showhide-columns-based-on-drop-down.html">http://bingggg.blogspot.in/2011/11/showhide-columns-based-on-drop-down.html</a></span></div>
<div dir="ltr">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><div dir="ltr" id="imcontent">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><a href="https://www.nothingbutsharepoint.com/sites/eusp/pages/showhide-lookup-fields-with-jquery.aspx" title="https://www.nothingbutsharepoint.com/sites/eusp/pages/showhide-lookup-fields-with-jquery.aspx">https://www.nothingbutsharepoint.com/sites/eusp/pages/showhide-lookup-fields-with-jquery.aspx</a></span></div>
<div dir="ltr">
</div>
<div dir="ltr">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"></span> <a href="https://www.nothingbutsharepoint.com/sites/eusp/pages/showhide-lookup-fields-with-jquery.aspx">https://www.nothingbutsharepoint.com/sites/eusp/pages/showhide-lookup-fields-with-jquery.aspx</a></div>
</span></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-37928320333299995982013-06-11T04:45:00.003-07:002013-06-11T04:45:17.097-07:00Print preview using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: black; font-family: 'Segoe UI','sans-serif'; font-size: 10pt; mso-fareast-font-family: 'Times New Roman';"><script type="text/javascript"><br />function displayMessage(printContent) {<br />var inf = printContent;<br />win = window.open("print.htm", 'popup');<br />win.document.write(inf);<br />win.document.close(); // new line<br />}<br /></script><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: black; font-family: 'Segoe UI','sans-serif'; font-size: 10pt; mso-fareast-font-family: 'Times New Roman';"><a href="javascript:void<span id="oc_preserve">(0)</span>;" onclick="displayMessage(printarea.innerHTML)"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: black; font-family: 'Segoe UI','sans-serif'; font-size: 10pt; mso-fareast-font-family: 'Times New Roman';"><a href="javascript:void<span id="oc_preserve">(0)</span>;" onclick="displayMessage(printarea.innerHTML)"><br />Print Preview</a><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: black; font-family: 'Segoe UI','sans-serif'; font-size: 10pt; mso-fareast-font-family: 'Times New Roman';"><div id="printarea"></div><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: black; font-family: 'Segoe UI','sans-serif'; font-size: 10pt; mso-fareast-font-family: 'Times New Roman';"><div id="printarea">print the text</div></span><span style="color: black; font-family: 'Segoe UI','sans-serif'; mso-fareast-font-family: 'Times New Roman';"><o:p></o:p></span></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com1tag:blogger.com,1999:blog-3223289884932252033.post-46843123140990723822013-06-10T03:16:00.003-07:002013-06-10T03:17:08.091-07:00Color coading to SharePoint List rows conditionally <div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name">
Reference Url:<a href="http://www.sharepointkings.com/2008/12/highlight-sharepoint-list-rows.html">http://www.sharepointkings.com/2008/12/highlight-sharepoint-list-rows.html</a></h3>
<h3 class="post-title entry-title" itemprop="name">
</h3>
<h3 class="post-title entry-title" itemprop="name">
Highlight SharePoint List rows conditionally </h3>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjVO05F2mSwSCr6lMHwHvpajmEU2E6HJeiimEmR4psAABG3eXIFn3pFljuGxgctEaLp5HKprlIBCZbfPPEYjjwANtE1MziBWNvESZY2ZPGTRSK-yzX0av_msRfmYqMgwEsA2kDNBu9jJc/s1600/hc1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjVO05F2mSwSCr6lMHwHvpajmEU2E6HJeiimEmR4psAABG3eXIFn3pFljuGxgctEaLp5HKprlIBCZbfPPEYjjwANtE1MziBWNvESZY2ZPGTRSK-yzX0av_msRfmYqMgwEsA2kDNBu9jJc/s1600/hc1.bmp" yya="true" /></a></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-title entry-title" itemprop="name">
<br /></div>
<div class="post-header">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-2159499846070308240" itemprop="description articleBody">
Hi All,here is some JQuery Stuff that will help you to highlight rows of SharePoint List items based on some condition. <br />
<blockquote>
<br />
<script type="text/javascript"><br />
if(typeof jQuery=="undefined"){<br />
var jQPath="http://ajax.googleapis.com/ajax/libs/jquery/1.3.1/";<br />
document.write("<script src='",jQPath,"jquery.min.js' type='text/javascript'><\/script>");<br />
}<br />
</script><br />
<script> <br />
$(document).ready(function(){<br />
$Text = $("td .ms-vb2:contains('Sales')");<br />
$Text.parent().css("background-color", "green");<br />
$Text =$("td .ms-vb2:contains('Account')");<br />
$Text.parent().css("background-color", "orange"); <br />
}); <br />
</script> <br />
<br />
above JQuery code will highlight if Column has 'Sales' then row will highlight with color green.if column has value Account then it will highlight with orange color.<br />
<br />
Look at second Post <a href="http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html"><span style="color: #771100;">http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html</span></a></blockquote>
</div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-45836258027147757092013-06-10T03:04:00.002-07:002013-06-10T03:06:01.899-07:00color coading to sharepoint list columns with screen shots<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name">
SharePoint calculated column and jQuery Highlight row </h3>
<div class="post-header">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-7782747795477113922" itemprop="description articleBody">
Hi All,<br />
Here I am writing new blog after long time I highly apologies to our all regular SharePointKings readers. I have explore what you can do by SharePoint calculated column and jQuery here is small practical stuff follow the instructions and do it yourself you will surely enjoy this work I am sure.<br />
Sometimes you need to represent SharePoint List in terms of legend like in map. Say for example you have result list and you want to show those Student who got less than 35% marks Should Have “Red” Legend, those who got 100% marks with “Blue” Legend , those who got >65% with “Pink” Legend , those who got >70% with Yellow, marks > 60 with Green.<br />
<br />
Follow the steps<br />
1. Create Result SharePoint custom list</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZzZCti8wfHlvK2O5uzHyydkG9P5Y9w1YWjOQSIgMXH1wZ0rWL8ZjrpWfGEpdNs9kl7Tn2G5NAPYRjUFaBAUBmuQYNP4nbzLDcLk67rqkUW6m8Dl5-4PLBesEQc50dUACvuJCqXeN-TMo/s1600/c1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZzZCti8wfHlvK2O5uzHyydkG9P5Y9w1YWjOQSIgMXH1wZ0rWL8ZjrpWfGEpdNs9kl7Tn2G5NAPYRjUFaBAUBmuQYNP4nbzLDcLk67rqkUW6m8Dl5-4PLBesEQc50dUACvuJCqXeN-TMo/s1600/c1.bmp" yya="true" /></a></div>
<div class="post-body entry-content" itemprop="description articleBody">
2. Create column StudentName single line text.<br />
<br />
3. Create Column Color with Calculated Column.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXY67TDG7ZT5r-6DvdUeKI-wdeRTQ2eHoJbg_F49RWx550ne0Gc4q0NVWZxSBoAvry4aWHZMj6G6QGDseaEH7geHzIGw3C1r-dBtQyUJo4NDj2gqPfR5Mp_97WsAdP5Yv-0SsqUUWWvWM/s1600/c2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXY67TDG7ZT5r-6DvdUeKI-wdeRTQ2eHoJbg_F49RWx550ne0Gc4q0NVWZxSBoAvry4aWHZMj6G6QGDseaEH7geHzIGw3C1r-dBtQyUJo4NDj2gqPfR5Mp_97WsAdP5Yv-0SsqUUWWvWM/s1600/c2.bmp" yya="true" /></a></div>
<div class="post-body entry-content" itemprop="description articleBody">
Copy and Paste following code in formula.<br />
<blockquote>
=IF((Marks*100)>=100,"#0000FF",IF((Marks*100)>=70,"#FFFF00",IF((Marks*100)>60,"#FF00FF",IF((Marks*100)>=35,"#00FF00","#FF0000"))))</blockquote>
<br />
4. Create another column called Display</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVHMZUoiUxp4Tuh5C9mH3F4iCBh8TO0hYK1Kph6bzs6EF8g65VabWQ-FZsdjnpaZcs0XRfjCVIIYwSojTby2-8OMWvCwzWoq8lK1HdTYx5WDZiBeUPdMXXQCmq69dI-ZCEMwHzenkXHH8/s1600/c3.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVHMZUoiUxp4Tuh5C9mH3F4iCBh8TO0hYK1Kph6bzs6EF8g65VabWQ-FZsdjnpaZcs0XRfjCVIIYwSojTby2-8OMWvCwzWoq8lK1HdTYx5WDZiBeUPdMXXQCmq69dI-ZCEMwHzenkXHH8/s1600/c3.bmp" yya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="post-body entry-content" itemprop="description articleBody">
Copy and paste following formula<br />
<blockquote>
="<DIV style='border: 1px "&Color&" solid;background-color:"&Color&";color:#FFFFFF;'>"&Marks*100&"<DIV>"</blockquote>
<br />
5. Now your fields looks like this <br />
<div class="separator" style="clear: both; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJtIyKLgnLjEKHN6Q8aYNTVLdBmbDSc74E6OLs6ElKn_qNY3gbNyc1psBh2NgppBhsa9lpITMf8P6zs473mJceLLYOiCE_9Ef7S-D-v8BbThNq01wDAVuS5pEA3PmLReNbIja2t3eTujk/s1600/c4.bmp" yya="true" /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
6. Open new form and Add Student Name and Marks obtained by him.</div>
7. Once you enter marks for student your SharePoint list looks like this<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvPZgh-ROvLfz82zvsMKFVcDf4rOiG2Xnp5SAa-ljrFAAuSYl-d8nt6tePkBm0Igcs2y9_pPX2KDknNwZ-LIFPOAFotWw8RZ0xAxORIblcMwKTDw-5EBQQyaprGtQsPdGIFmLjWiqn0xU/s1600/c5.bmp" yya="true" />8. Edit Page and add the below script in content editor webpart</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<script src="/sites/testingsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script type="text/javascript"></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
$(document).ready(function(){<br />
$(".ms-vb2:contains('<DIV')").each(function(){<br />
var tempDIV = document.createElement ("DIV");<br />
tempDIV.style.cursor = "pointer";<br />
tempDIV.innerHTML = $(this).text();<br />
$(this).text("");<br />
$(this).append(tempDIV);<br />
});}); </script><br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
9) finally look like this</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikeIlYiN0uuaAGMaONJlnd-FUh6RsKbbJJU2qo7JCCBJxnlIwMvfqXcecr7SRrtBE0WNu9jLCmjp1dQkLahBlt_AzKkInM3s4Fb54QWKJ6eiQUsJzBcyWl272k09iRGVsjJIGTmieFIcU/s1600/c7.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikeIlYiN0uuaAGMaONJlnd-FUh6RsKbbJJU2qo7JCCBJxnlIwMvfqXcecr7SRrtBE0WNu9jLCmjp1dQkLahBlt_AzKkInM3s4Fb54QWKJ6eiQUsJzBcyWl272k09iRGVsjJIGTmieFIcU/s1600/c7.bmp" yya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
</div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-65584635760102117662013-06-10T01:00:00.001-07:002013-06-10T01:00:15.685-07:00Color coading to sharepoint list column<div dir="ltr" style="text-align: left;" trbidi="on">
Reference url:<br />
<a href="http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html">http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html</a><br />
<br />
I have five status shown below based on status selection we need to highlight the color to perticular column<br />
<br />
Steps:<br />
1)Create status field(Status)<br />
2)we need color to perticuar status based on status selection .create one more column(status color) for displaying color<br />
<br />
status color =IF([Issue Status]="Awaiting SME Action","#4682B4",<br />IF([Issue Status]="Consultation Provided","#1E90FF",<br />IF([Issue Status]="Document review /Approval Provided","#2F4F4F",<br />IF([Issue Status]="Awaiting Seed Funding","#008080",<br />IF([Issue Status]="Recevied Seed funding","#33CC33",<br />IF([Issue Status]="No Impacted","#A0522D",<br />IF([Issue Status]="Closed Request","#FF9999",<br />IF([Issue Status]="Estimation provided","#008000"))))))))<br />
<br />
<br />
3)Create one more column for displaying the div tag(replace the status color and status column names in DIV tag)<br />
<br />
<br />
="<DIV style='border: 1px "&status color&" solid;background-color:"&Color&";color:#FFFFFF;'>"&Status&"<DIV>"<br />
<br />
4)Add this below code in content editor webpart<br />
<br />
<script src="/sites/testingsite/SiteAssets/jquery-1.9.0.min.js" type="text/javascript"></script><script type="text/javascript"><br />
<br />
$(document).ready(function(){<br />$(".ms-vb2:contains('<DIV')").each(function(){<br />var tempDIV = document.createElement ("DIV");<br />tempDIV.style.cursor = "pointer";<br />tempDIV.innerHTML = $(this).text();<br />$(this).text("");<br />$(this).append(tempDIV);<br />});}); </script><br />
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-20725822522290766212013-06-10T00:14:00.000-07:002013-06-12T03:40:15.405-07:00Calculated column examples<div dir="ltr" style="text-align: left;" trbidi="on">
1)Currentagreed date is greater than now and status equal to something that time display <span style="color: #cc0000;">Yes</span> and Currentagreed date is less than now and status equal to something that time display <span style="color: red;"> Invalid</span> <br />
I have totally four status(red,amber,green,completed).Now means current date<br />
<strong>Formula:</strong> =IF(OR(AND(CurrentAgreed>Now,Status="Red"),AND(CurrentForecast>Now,Status="Red")),"Yes",<br />
IF(OR(AND(CurrentAgreed>Now,Status="Green"),AND(CurrentForecast>Now,Status="Green")),"Yes",<br />
IF(OR(AND(CurrentAgreed>Now,Status="Amber"),AND(CurrentForecast>Now,Status="Amber")),"Yes",<br />
IF(OR(AND(CurrentAgreed>Now,Status="Completed"),AND(CurrentForecast>Now,Status="Completed")),"Yes",<br />
IF(OR(AND(CurrentAgreed<Now,Status="Red"),AND(CurrentForecast<Now,Status="Red")),"Invalid",<br />
IF(OR(AND(CurrentAgreed<Now,Status="Green"),AND(CurrentForecast<Now,Status="Green")),"Invalid",<br />
IF(OR(AND(CurrentAgreed<Now,Status="Amber"),AND(CurrentForecast<Now,Status="Amber")),"Invalid",<br />
IF(OR(AND(CurrentAgreed<Now,Status="Completed"),AND(CurrentForecast<Now,Status="Completed")),"Invalid"))))))))<br />
<br />
<br />
2)And combination with multiple conditions<br />
<br />
=IF(OR(AND(CurrentAgreed<Now,Status="Red"),AND(CurrentForecast<Now,Status="Red"),AND(CurrentAgreed<Now,Status="Green"),AND(CurrentForecast<Now,Status="Green"),AND(CurrentAgreed<Now,Status="Amber"),AND(CurrentForecast<Now,Status="Amber")),"Invalid","Yes")<br />
<br />
3)Using Two if conditions with multiple and conditions<br />
=IF(OR(AND(CurrentAgreed<Now,Status="Red"),AND(CurrentForecast<Now,Status="Red"),<br />
AND(CurrentAgreed<Now,Status="Green"),AND(CurrentForecast<Now,Status="Green"),<br />
AND(CurrentAgreed<Now,Status="Completed"),AND(CurrentForecast<Now,Status="Completed"),<br />
AND(CurrentAgreed<Now,Status="Amber"),AND(CurrentForecast<Now,Status="Amber")),"Invalid",<br />
IF(OR(AND(CurrentAgreed>Now,Status="Red"),AND(CurrentForecast>Now,Status="Red"),<br />
AND(CurrentAgreed>Now,Status="Green"),AND(CurrentForecast>Now,Status="Green"),<br />
AND(CurrentAgreed>Now,Status="Completed"),AND(CurrentForecast>Now,Status="Completed"),<br />
AND(CurrentAgreed>Now,Status="Amber"),AND(CurrentForecast>Now,Status="Amber")),"Yes"))<br />
<br />
4)Using div tag inside the if condition<br />
<div dir="ltr" id="imcontent">
<span dir="ltr" style="color: black; direction: ltr; font-family: 'Segoe UI'; font-size: 10pt; word-wrap: break-word;"><div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span id="100732840.0" style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;">1.</span><span id="100732856.0" style="color: #1f497d; font-family: Calibri,sans-serif;"> </span><span id="100732856.0" style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;">IF CurrentAgreed>=Today AND CurrentForecast >= Today THEN IsValid.Text=”Yes”, IsValid.Backgroundcolor=”none”</span></span></div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span id="100732856.0" style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;">2.</span><span id="100732856.0" style="color: #1f497d; font-family: Calibri,sans-serif;"> </span><span id="100732856.0" style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;">No. The IsValid and Status columns are entirely separate. If CurrentAgreed<Today OR CurrentForecast <today THEN IsValid.Text=”No”, IsValid.Backgroundcolor=”Amber”</span></span></div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;"></span></span> </div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;">Formula:=<strong>IF(AND(CurrentForecast>Now,CurrentAgreed>Now),"Yes",IF(OR(CurrentForecast<Now,CurrentAgreed<Now),"<DIV style='border: 1px #FFC200 solid;background-color:#FFC200;color:#FFFFFF;'>No<DIV>"))</strong></span></span></div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;"></span></span> </div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;"></span></span> </div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;"></span></span> </div>
<div>
<span style="font-family: Times New Roman,serif; font-size: 12pt; margin: 0px 0px 0px 36pt; text-indent: -18pt;"><span style="color: #1f497d; font-family: Calibri,sans-serif; font-size: 11pt;"></span></span> </div>
</span></div>
<br />
5)Using Multiple if conditions<br />
=IF([Issue Status]="Awaiting SME Action","#4682B4",<br />
IF([Issue Status]="Consultation Provided","#1E90FF",<br />
IF([Issue Status]="Document review /Approval Provided","#2F4F4F",<br />
IF([Issue Status]="Awaiting Seed Funding","#008080",<br />
IF([Issue Status]="Recevied Seed funding","#33CC33",<br />
IF([Issue Status]="No Impacted","#A0522D",<br />
IF([Issue Status]="Closed Request","#FF9999",<br />
IF([Issue Status]="Estimation provided","#008000"))))))))<br />
<br />
6)Calculating the difference between two times with hours,minutes and seconds<br />
<br />
=TEXT(Opentime-Completedtime,"h:mm:ss")<br />
<br />
7)Getting the total time with hours,minutes and seconds<br />
<br />
=TEXT(H1time+H2time+H3time+Hcwtime+Hwatime+Hactime,"h:mm:ss")<br />
<br />
<br />
<br />
<br />
<br /><br />
<br />
<br />
<br /></div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-86917373590738642162013-06-07T04:09:00.002-07:002013-06-07T04:09:18.122-07:00Workrequest creation<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Workrequest num: =(LEFT(TEAM,1)&Year&CONCATENATE("WR-",REPT(0,4-LEN(incrementid)),incrementid))<span style="mso-spacerun: yes;"> </span>ex: A12WR-0251<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">(hear both incremented above through workflow only)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Year: =RIGHT(Filteryear,2)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Filteryear =TEXT(Created,"yyyy")<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Incremented: (number field(number of decimal fields:automatic))<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Incremented:through auto increment workflow<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<o:p><span style="font-family: Calibri;"> </span></o:p><span style="font-family: Calibri;">Auto increment id workflow:</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzUvE2WgFiDAIg4v0hc276bgLFH2gTCS1QPAzeCo_MTHyFiIiRiStvVxcP1wFjpHZBtVCuRcuqm-mGLPRhfhGAOBtodW9TgKg2o0wniNMk0Mz347vV8_Pu_LDAVQaCaXCHiO1UIuyNvkg/s1600/Autoincrement+id.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzUvE2WgFiDAIg4v0hc276bgLFH2gTCS1QPAzeCo_MTHyFiIiRiStvVxcP1wFjpHZBtVCuRcuqm-mGLPRhfhGAOBtodW9TgKg2o0wniNMk0Mz347vV8_Pu_LDAVQaCaXCHiO1UIuyNvkg/s1600/Autoincrement+id.bmp" yya="true" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<o:p><span style="font-family: Calibri;"></span></o:p></div>
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">One more scenario for workrequest num creation<o:p></o:p></span></u></b><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">Workrequest no:</b> =(Title&Filtermonth&Filterdate&Year&CONCATENATE("R",REPT(0,4-LEN(Autonumber)),Autonumber)) <span style="mso-spacerun: yes;"> </span>ex:</span><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 8pt; line-height: 115%;"> CSP042613R0000 (csp means title)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Filterdate:</span></b><span style="font-family: Calibri;"> </span><b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">=TEXT(Created,"dd")<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">FilterYear:<span style="mso-spacerun: yes;"> </span>=TEXT(Created,"yyyy")<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Last two digits in year<span style="mso-spacerun: yes;"> </span>year:</span></b><span style="font-family: Calibri;"> </span><b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">=RIGHT(Filteryear,2)<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Filtermonth :<span style="mso-spacerun: yes;"> </span>=TEXT(Created,"mm")<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #6d6f72; font-family: 'Verdana','sans-serif'; font-size: 10pt; line-height: 115%;">Autonumber :Through designer workflow as specified above<o:p></o:p></span></b></div>
</div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-78690056081773949072013-06-07T03:50:00.003-07:002013-06-07T03:50:37.160-07:00Event reciver examples in sharepoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Consolas; font-size: 14pt;">Itemdeleting event reciver <o:p></o:p></span></u></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">public</span> <span style="color: blue;">override</span> <span style="color: blue;">void</span> ItemDeleting(<span style="color: #2b91af;">SPItemEventProperties</span> properties)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">base</span>.ItemDeleting(properties);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//listitem title name equal new that time event will fire </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (properties.ListItem[<span style="color: #a31515;">"Title"</span>].ToString() == <span style="color: #a31515;">"new"</span>)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>properties.ErrorMessage = <span style="color: #a31515;">"Dont delete the item title starts with new"</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: green; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>//</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: #00b050;">firing event will restrict the user any action will happen</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>properties.Cancel = <span style="color: blue;">true</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span><span style="color: blue;">else</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>properties.Cancel = <span style="color: blue;">false</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//SPUtility.Redirect(properties.Web.Url, SPRedirectFlags.DoNotEndResponse, HttpContext.Current);</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Consolas; font-size: 14pt;">Itemadded event reciver<o:p></o:p></span></u></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">public</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">override</span> <span style="color: blue;">void</span> ItemAdded(<span style="color: #2b91af;">SPItemEventProperties</span> properties)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">base</span>.ItemAdded(properties);<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">SPListItem</span> item = properties.ListItem;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: green;">//update only date for this column.if u add or update any data in the new date column..</span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item[<span style="color: #a31515;">"newdate"</span>] = <span style="color: #2b91af;">DateTime</span>.Now.ToString();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item.Update();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-50164503744003506222013-06-07T03:37:00.000-07:002013-06-07T03:37:05.109-07:00Sharepoint feature example<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<a href="http://weblogs.asp.net/sreejukg/archive/2011/10/27/developing-sharepoint-2010-features-using-visual-studio-2010.aspx"><span style="color: blue; font-family: Calibri;">http://weblogs.asp.net/sreejukg/archive/2011/10/27/developing-sharepoint-2010-features-using-visual-studio-2010.aspx</span></a><span style="font-family: Calibri;"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">1.Create sharepoint empty project(deploy it as farm solution)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">2.right click on feature add feature<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Contains<span style="mso-spacerun: yes;"> </span>feature1.feature need to specify feature Title,description,scope(web=subsite,site=sitecollection,webapplication,farm)-</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">feature.xml in moss 2007.called as feature manifest file<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">3.right click on the main application add empty element…this is elements.xml</span><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: Calibri;">elements.xml in moss 2007. called as Element<span style="mso-spacerun: yes;"> </span>manifest file<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">4. right click on the main application add application page..<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">5. go to elements.xml add the below code..<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><?</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">xml</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt;">version</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">1.0</span>"<span style="color: blue;"> </span><span style="color: red;">encoding</span><span style="color: blue;">=</span>"<span style="color: blue;">utf-8</span>"<span style="color: blue;">?></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">Elements</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt;">xmlns</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">http://schemas.microsoft.com/sharepoint/</span>"<span style="color: blue;">></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">CustomAction</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"> </span><span style="color: red; font-family: Consolas; font-size: 9.5pt;">Id</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">SiteActionsToolbar</span>"<span style="color: blue;"> </span><span style="color: red;">GroupId</span><span style="color: blue;">=</span>"<span style="color: blue;">SiteActions</span>"<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: red; font-family: Consolas; font-size: 9.5pt;">Location</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">Microsoft.SharePoint.StandardMenu</span>"<span style="color: blue;"> </span><span style="color: red;">Sequence</span><span style="color: blue;">=</span>"<span style="color: blue;">100</span>"<span style="color: blue;"> </span><span style="color: red;">Title</span><span style="color: blue;">=</span>"<span style="color: blue;">Welcome Page</span>"<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: red; font-family: Consolas; font-size: 9.5pt;">Description</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">Welcome to the site</span>"<span style="color: blue;">></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><!--</span><span style="color: green; font-family: Consolas; font-size: 9.5pt;">exact site collection<span style="mso-spacerun: yes;"> </span>url http://syncgdc1412:9999/sites/newsite1 here am adding the application page</span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: green; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>url(what i added in the application) from the site collection name in url section.</span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: green; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>otherwise its taking from<span style="mso-spacerun: yes;"> </span>http://syncgdc1412:9999/_layouts/Featureex/exwelcome.aspx (not taking the site collection name). </span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: green; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>need this url http://syncgdc1412:9999/sites/newsite1/_layouts/Featureex/exwelcome.aspx</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">--> </span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">UrlAction</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span></span><span style="color: red; font-family: Consolas; font-size: 9.5pt;">Url</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">=</span><span style="font-family: Consolas; font-size: 9.5pt;">"<span style="color: blue;">/sites/newsite1/_layouts/Featureex/exwelcome.aspx</span>"<span style="color: blue;">/></span><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span></span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span></span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span></</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">CustomAction</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">></span><span style="font-family: Consolas; font-size: 9.5pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;"></</span><span style="color: #a31515; font-family: Consolas; font-size: 9.5pt;">Elements</span><span style="color: blue; font-family: Consolas; font-size: 9.5pt;">><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">6.Build deploy<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQlWtT-OVriGVtDRoRFqg6vcysh_15RtsAKBD498r4I9c7J_Zb6GlETPtuyz-YihodEAZSqLeCqPoLY4oIahviDChwMej7uH2Q7qfs5E7WMZdpeqot2yA6UY_hmSvZJ9SdxohOb8XvxM4/s1600/6p.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQlWtT-OVriGVtDRoRFqg6vcysh_15RtsAKBD498r4I9c7J_Zb6GlETPtuyz-YihodEAZSqLeCqPoLY4oIahviDChwMej7uH2Q7qfs5E7WMZdpeqot2yA6UY_hmSvZJ9SdxohOb8XvxM4/s1600/6p.bmp" yya="true" /></a></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">7.After clicking will redirect to application page..<o:p></o:p></span></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-90642320962214731612013-06-07T03:26:00.002-07:002013-06-07T03:26:19.113-07:00Sequential workflow example<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-size: 14pt; line-height: 115%;"><span style="font-family: Calibri;">Sequential workflow<o:p></o:p></span></span></u></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<a href="http://www.codeproject.com/Articles/416393/Create-a-Workflow-using-Visual-Studio-2010"><b style="mso-bidi-font-weight: normal;"><span style="font-size: 14pt; line-height: 115%;"><span style="color: blue; font-family: Calibri;">http://www.codeproject.com/Articles/416393/Create-a-Workflow-using-Visual-Studio-2010</span></span></b></a><b style="mso-bidi-font-weight: normal;"><u><span style="font-size: 14pt; line-height: 115%;"><o:p></o:p></span></u></b></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-size: 14pt; line-height: 115%;"><span style="font-family: Calibri;">ex code:<o:p></o:p></span></span></u></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt;">private</span><span style="font-family: Consolas; font-size: 9.5pt;"> <span style="color: blue;">void</span> codeActivity1_ExecuteCode(<span style="color: blue;">object</span> sender, <span style="color: #2b91af;">EventArgs</span> e)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">SPSite</span> site = <span style="color: #2b91af;">SPContext</span>.Current.Site;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">SPWeb</span> web = site.OpenWeb();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: #2b91af;">SPList</span> list = web.Lists[<span style="color: #a31515;">"Sequentialwfex"</span>];<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">foreach</span> (<span style="color: #2b91af;">SPListItem</span> item <span style="color: blue;">in</span> list.Items)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="color: blue;">if</span> (item[<span style="color: #a31515;">"Saddress"</span>] == <span style="color: blue;">null</span>)<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item[<span style="color: #a31515;">"Saddress"</span>] = <span style="color: #a31515;">"Please enter correct address value"</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>item.Update();<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>web.AllowUnsafeUpdates = <span style="color: blue;">true</span>;<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0tag:blogger.com,1999:blog-3223289884932252033.post-11547683475395599692013-06-07T03:04:00.002-07:002013-06-07T03:05:19.620-07:00Displaying the user details(dropdown selection) in InfoPath based on dropdown selection without code:<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_5cOosShpQx9soCdcJJqXHFYENsjkKa8Lny1NNSU0ja0aYWYeiKkJ5jzgSBn3pZDQs0gF-17uaV6_8SYMFYEnwGuN0p39fwPKcc87MqTFuX59akhDbX3QpT0Nv6ZmVpxSSWnIxslBJNs/s1600/dp1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_5cOosShpQx9soCdcJJqXHFYENsjkKa8Lny1NNSU0ja0aYWYeiKkJ5jzgSBn3pZDQs0gF-17uaV6_8SYMFYEnwGuN0p39fwPKcc87MqTFuX59akhDbX3QpT0Nv6ZmVpxSSWnIxslBJNs/s1600/dp1.bmp" height="172" width="320" yya="true" /></a></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="mso-no-proof: yes;"><span style="font-family: Calibri;">2.After selecting the Username from dropdown its Automatically<span style="mso-spacerun: yes;"> </span>displaying the corresponding user details(Originating GroupName,Designation,Account…etc .As shown belw)<o:p></o:p></span></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhucSpKeW6CFd0IwIehluYJ8jUcqhxUjiTCfdkKFZQpCszjr1j55nI8FFvCHH8wYgjQvU2zo05St2LRV6A8mhI0FHtS05dmQWHeyMjp-DmouRLcw6i9_1zFwdQQ6KSZPssXpbfIlWsx5Mc/s1600/dp2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhucSpKeW6CFd0IwIehluYJ8jUcqhxUjiTCfdkKFZQpCszjr1j55nI8FFvCHH8wYgjQvU2zo05St2LRV6A8mhI0FHtS05dmQWHeyMjp-DmouRLcw6i9_1zFwdQQ6KSZPssXpbfIlWsx5Mc/s1600/dp2.bmp" yya="true" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Connect to the user information list and bind the values to the dropdown . by default<span style="mso-spacerun: yes;"> </span>it takes user id id and name value from the user information list.create some dropdowns and select the user corresponding values(depart ment…) and make it as a hidden fields<span style="mso-spacerun: yes;"> </span>then only the values save into dropdown see the below screen shot..</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjokJhVqMZiYPhHnky-sJPcaUAtpJOLx7_rkUR7KOy0XpRJl7PhwB76TuiWWE6JHE93PZl-CYpQjXSjVa0mM_H1ubhKdGCbqC_I7U37IkvtagPjd02fR7wPTk5-62JLe_8JlT6i_LaF46E/s1600/dp3.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjokJhVqMZiYPhHnky-sJPcaUAtpJOLx7_rkUR7KOy0XpRJl7PhwB76TuiWWE6JHE93PZl-CYpQjXSjVa0mM_H1ubhKdGCbqC_I7U37IkvtagPjd02fR7wPTk5-62JLe_8JlT6i_LaF46E/s1600/dp3.bmp" yya="true" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<span style="font-family: Calibri;"><o:p><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="mso-spacerun: yes;"> </span>And set the field values to the originating name(dropdown) </div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnHtKnaXNQ7UlLzu9ndIHMQsuaKtS_kHJt_Dgup9MQdsavk7ws1gGCWKlHJSTD_K650ym2bnWU2Rr3nMPHZAHuNJ0qImGFctjjeeFEL1SppIPsYrR-2Yv5ZNalUEyR__EogO5wsgBkLP4/s1600/dp4.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnHtKnaXNQ7UlLzu9ndIHMQsuaKtS_kHJt_Dgup9MQdsavk7ws1gGCWKlHJSTD_K650ym2bnWU2Rr3nMPHZAHuNJ0qImGFctjjeeFEL1SppIPsYrR-2Yv5ZNalUEyR__EogO5wsgBkLP4/s1600/dp4.bmp" yya="true" /></a></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<o:p><div class="MsoNormal" style="margin: 0in 0in 10pt;">
Originating groupname set field value: see the below screen shot for displaying the originating group value<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
Here field=originating name(disply originating name field)<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
Value(see the below screen shot)=department is from userinformation list(see the below screen shot) and that value id is equal to originating name(field 4)<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
</div>
</o:p> </o:p></span>
</div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZAJFRPZyav6loSDQiJON1nH8WtUN0ZzhlLM5_oGLtmBIuIO5O18peH5Ciq4f33-3t8lLRFH-HNCp1BpciYIXSJn6Q9iVFRHEo5EbzcwCADbMv0FNUFoRfbFQmhMsw-4NT5R8u3cObtg0/s1600/dp5.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZAJFRPZyav6loSDQiJON1nH8WtUN0ZzhlLM5_oGLtmBIuIO5O18peH5Ciq4f33-3t8lLRFH-HNCp1BpciYIXSJn6Q9iVFRHEo5EbzcwCADbMv0FNUFoRfbFQmhMsw-4NT5R8u3cObtg0/s1600/dp5.bmp" yya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Ery44PN3et-p3H8o59bHGxp8HTucG7Z7Yvrv-QqPe0Bbq8eKpWlZ1A7RQwnWi4RE1-qoqntlDpE4XgMeWimzcBKa2XcfIACz7HBwXqpSukqzmHZlg2kLEnr-T09zzG5Iau0E9ohyA70/s1600/dp6.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1Ery44PN3et-p3H8o59bHGxp8HTucG7Z7Yvrv-QqPe0Bbq8eKpWlZ1A7RQwnWi4RE1-qoqntlDpE4XgMeWimzcBKa2XcfIACz7HBwXqpSukqzmHZlg2kLEnr-T09zzG5Iau0E9ohyA70/s1600/dp6.bmp" yya="true" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Calibri;">Same to remaing fields…<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</div>
chakrihttp://www.blogger.com/profile/09247172048783534579noreply@blogger.com0