Bazaleel Raja Selwyn: SharePoint

Showing posts with label SharePoint. Show all posts

Sunday, January 06, 2013

Sharepoint Search between two dates

Searching between two dates in a list.
this is not a default view in 2003.
there are links that enable and help is understanding more about it.

in simple terms. Create 2 text boxes in form
and name them start date and end date

create parameter in data view for start date and end date

create filter for start date and end date

set default value for start date as 1500-01-01

default value for end date as 3500-01-01 - this will display all items

connect the boxes and use the format as yy-mm-dd else it wont work
important references:

http://yanlinglei.blogspot.in/2010/02/filter-between-two-dates-using-dataview.html

http://yanlinglei.blogspot.in/2008/11/filter-between-two-dates-date-range.html

http://social.technet.microsoft.com/Forums/eu/sharepointadminlegacy/thread/a8cce2af-3900-4421-8fc0-91d9adc315ad

datepicker() modified as
datepicker({ dateFormat: 'yy-mm-dd'});

http://docs.jquery.com/UI/Datepicker/formatDate

http://stackoverflow.com/questions/7500058/how-to-change-date-format-mm-dd-yy-to-yyyy-mm-dd-in-date-picker

Text boxes sample - form webpart
------------------

<div onkeydown="javascript:if (event.keyCode == 13) _SFSUBMIT_">
<head>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="jquery-ui.css" />
    <script src="jquery-1.8.3.js"></script>
    <script src="jquery-ui.js"></script>
    <link rel="stylesheet" href="style.css" />

<script>
   $(function()
     {
     $( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd'});
     $( "#datepicker1" ).datepicker({ dateFormat: 'yy-mm-dd'});
     });
    </script>
</head>
Start Date: <input type="text" name="T1" id="datepicker" />
End Date : <input type="text" name="T2" id="datepicker1" /><input type="button" value="Go" onclick="javascript:_SFSUBMIT_"/>
</div>
</html>

Wednesday, August 22, 2012

Show hide

Sunday, August 19, 2012

configuring a web part

here's the tip for today.... You know how when you add an out-of-the-box web part that requires configuration you get a nice little message in the web part display that you need to configure it, and a link to open up the toolpane? Add a Page Viewer web part to your site and you'll see what I mean.... Well here's how to add one of those links. This is really useful in exception handling for configuration related exceptions too....
In your RenderWebPart override check to see if your part is configured, if not output something like this:
output.Write(@"Web Part not configured: <a target=""_self"" href=""javascript:MSOTlPn_ShowToolPaneWrapper('1','129','g_" + this.StorageKey.ToString.Replace("-"c, "_"c) + @"');"" target=""_self"">click here</a> to configure<br>");

Sharepoint Allow Customization to users

A lot of people don't realize just how easy it is to create their own “Modify Page” link/button/whatever.... All you really need is something that can have an onClick event.... For example, here's a “Modify Page” button, drop this into a Content Editor web part, strip off the web part frame and you're done...
<input id="btnModifyPage" type="button" class="UserButton" onClick="javascript:MSOWebPartPage_OpenMenu(MSOMenu_SettingsMenu, this);" value="Modify Page" />
So simple, so easy, right? Now because this isn't the actually WebPartPages:SettingsLink web part it will not change text from “Modify Shared Page” and “Modify My Page” depending on the page view you're on.... For most users I don't find that a problem anyway, thus the button text here is “Modify Page” Nice and generic. The functionality is the same however, if a use has access to modify both a personal page and a shared page they can do both from this button..... The javascript command is the same in either case.

Sharepoint Tweeks and tricks

Is this even possible, some might wonder? Well it is, via querystring options on the command line:

Add Web Parts/Browse		ToolPaneView=2
Add Web Parts/Search		ToolPaneView=3
Edit Mode		mode=edit
View Mode		mode=view
Shared Mode		PageView=Shared
Personal Mode		PageView=Personal

So for example, say you wanted to edit the Shared view of the default page:
default.aspx?mode=edit&PageView=Shared
Say you wanted to Browse web parts and add them to your Personal view:
default.aspx?ToolPaneView=2&PageView=Personal
You can mix and match, and the order of the options do not matter....
Hope this helps
-Andy

Thursday, August 02, 2012

Show ID in Sharepoint Edit Page using javascript

multiple Javascripts from one trigger

<input name="Button1" type="button" value="Submit" onclick="javascript: {ddwrt:GenFireServerEvent('__commit;__redirect={/thanks-for-submission.aspx}')}" />

Show ID Column from CEWP

<script type="text/javascript">
// Item ID in DispForm.aspx and EditForm.aspx
// Feedback and questions: Christophe@PathToSharePoint.com
//
function DisplayItemID()
{
var regex = new RegExp("[\\?&]"+"ID"+"=([^&#]*)");
var qs = regex.exec(window.location.href);
var TD1 = document.createElement("TD");
TD1.className = "ms-formlabel";
TD1.innerHTML = "<h3 class='ms-standardheader'>Issue ID</h3>";
var TD2 = document.createElement("TD");
TD2.className = "ms-formbody";
TD2.innerHTML = qs[1];
var IdRow = document.createElement("TR");
IdRow.appendChild(TD1);
IdRow.appendChild(TD2);
var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0];
ItemBody.insertBefore(IdRow,ItemBody.firstChild);
}

_spBodyOnLoadFunctionNames.push("DisplayItemID");
</script>

Thursday, July 26, 2012

Date and Time Difference calculator

Look what I just found!!!

=DATEDIF([In-Progress Time],[Closed time]-(MOD([In-Progress Time],1)>MOD([Closed time],1)),"d")&" days, "&TEXT(MOD([Closed time]-[In-Progress Time],1),"hh "" hrs, "" mm "" mins""")

Wednesday, July 25, 2012

Auto Refresh Page

Sharepoint form redirection

Disable edit on fields on a SharePoint form

<SCRIPT language=javascript>
function DisableField(title)
{
    for(var i = 0; i < document.all.length; i++)
    {
        var el = document.all[i];
        if(el.title == title)
        {
            el.readOnly = true;
            break;
        }
    }
}
DisableField("Bay");
DisableField("Pos");
DisableField("Status");
</SCRIPT>

Hide SharePoint Field on Form

this script will hide the fields selected

<script language="javascript" type="text/javascript" src="SITE/Images1/jquery-1.3.2.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() {
$("input[Title='Pos']").parents('tr:first').hide();
$("input[Title='Delete Item']").parents('tr:first').hide();

});
// this script below till set default value in a edit form
jQuery("select[title$=Status] option[value='Occupied']").attr("selected", "selected");
jQuery("select[title$=Occupancy Hours] option[value='9']").attr("selected", "selected");
</script>

Tuesday, July 24, 2012

SharePoint Full Screen

Digital World Clock

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled 2</title>
<script language="JavaScript">

</script>
<style type="text/css">
.body {
color: #000;
}
.hrow {
font-weight:bold;
color: #000;
}
.hrow td{
padding-top: 20px;
width: 140px;
}
</style>
</head>
<body>
<table cellspacing="5px" align="center">
<tr class="hrow">
<td>GMT</td>
<td>Melbourne</td>
<td>Bangalore</td>
<td>Manila</td>
<td>New York</td>
<td>Auckland</td>
<td>Singapore</td>
</tr>
<tr>
<td><font color="#004165"> <span id="GMT"></span></font></td>
<td><font color="#004165"> <span id="Melbourne"></span></font></td>
<td><font color="#004165"> <span id="Bangalore"></span></font></td>
<td><font color="#004165"> <span id="Manila"></span></font></td>
<td><font color="#004165"> <span id="NewYork"></span></font></td>
<td><font color="#004165"> <span id="NZ"></span></font></td>
<td><font color="#004165"> <span id="Singapore"></span></font></td>
</tr>

</table>

</body>
</html>

Color Gantt Chart

Dynamic Search

Have fun!!

<SCRIPT type="text/javascript"src="SITE/Shared%20Documents/Lib/js/jquery-1.7.1.min.js"></SCRIPT>
<SCRIPT type=text/javascript>
jQuery(document).ready(function($){
    //attach a function to the keyup event on the filter box
    $('#filterInput').keyup(function()
    {
        DynamicFilter($('#filterInput').val());
    });
})
//strip off html taqs
function stripHTML (field) {
    return field.replace(/<([^>]+)>/g,'');
}
function DynamicFilter(text)
{
    //find out list view (default class for a listview is "ms-listviewtable"
    $('table [class="ms-listviewtable"]').find('tr').each(function()
        {
            //don't filter out the header row
            if ($(this).attr("class") != "ms-viewheadertr ms-vhltr")
            {
                //get the html for the row and strip off the html tabs
                source = stripHTML($(this).html());

                //check to see if the filter text exists in the remaining text
                if (source.indexOf(text) < 0)
                {
                    //hide the row if it doesn't contain the text
                    $(this).hide();
                } else {
                    //otherwise show it
                    $(this).show();
                }
            }
        }
    );
}
</script>
<div id="mainDiv">
    <table>
        <tr>
            <td class='Filter' width='125px'>Search: <input type="Text" id="filterInput" ></td>
        </tr>
    </table>
</div>

Bazaleel Raja Selwyn