.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Content Query WebPart shows page items with status "draft", and page items that current user does no

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint


I have this issue that CQWP is rendring items that it should not render. I test this with a read-only user, that should NOT see draft pages or pages with different permissions. But the read-only user do see the items, but when I click on the link I get access denied. This access denied is correct, but why does the page items appear in the CQWP at all?


1) I use OOTB CQWP (inherits from ContentByQueryWebPart in my .webpart file) : "<type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart ....." and I have my custom xsl to get the look and feel I need

2) The issue with page items showing when status = drafts only appear when using the PublishingExpirationDate field. When I try creating new pages and give them status draft by using "check in to share draft" (logged on as an contributer/approver user), this item wil NOT appear in the CQWP for the read-only user. When I change a pages' status from approved to draft, this item will still be shown in the CQWP, but this will point correctly to the published version. But after the pages' expired date (PublishingExpirationDate) is expired, the page gets status "draft" (handeled by a timer job I guess), and this page item will still be rendered in the CQWP, but sending the read-only user to an access-

View Complete Post

More Related Resource Links

CSS - formatting block list items for the current page

I have a sidebar containing an un-ordered list (menu). Each list item is contained in a light grey block when the user hovers over it with the mouse. However I would also like the block to stay grey for the current page that the user is on. HTML <div id="sidebar"> <ul> <li><a href="../001.aspx">001</a></li> <li><a href="../002.aspx">002</a></li> <li><a href="../003.aspx">003</a></li> <li><a href="../004.aspx">004</a></li> <li><a href="../005.aspx">005</a></li> </ul> </div> <!-- end #sidebar --> CSS/* Sidebar */ #sidebar { float: left; width: 15%; padding: 10px 0px 0px 40px; } #sidebar ul { margin: 0; padding: 0px; list-style: none; line-height: 0px; } #sidebar li { font-size: 11px; line-height: 280%; text-transform: uppercase; letter-spacing: 2px; font-weight: normal; } #sidebar a { display: block; } #sidebar a:hover { text-decoration: none; font-weight: normal; color: #7584BD; background: #F2F2F2 } Very simple really, and used everywhere. I have been looking at free CSS examples to try and solve this problem, but the only so

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Knowing the event occured in user control in current page




      My web application has user control which uses third party controls called Devexpress controls. The user control is a menu  and is part of the Master page. It is placed there because this needs to be available in all the pages. My user controls raises a even on item clicked. Now, My question is that Is there any way to know that the event has occurred in page_load of the current page in which I am in?

Content Query Web Part (CQWP) fails to show picture items from a document/picture library in an anon

I have a Picture Library and am trying to use the CQWP to display a list of items in the library.  The web part shows the items fine in authenticated mode, but it fails to show the items to anonymous users. The error log message is: Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.SetDocumentIconUrlAndOnClickString(SPWeb web, DataRow row, String strDefaultItemOpen, Boolean fSetDocIcon, Boolean fSetOnClick, String fileRefColumnRef, String progIdColumnRef, String fsobjTypeColumnRef, String permMaskColumnRef)     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.PreProcessForDocumentIconAndOnClickAttribute()     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.AddContentQueryData()     at Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.GetXPathNavigator(String viewPath)     at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform) I'm running SP 2010.  I've tried various scenarios including: 1. Using the default publishing template. 2. Using the blank site template with publishing and lock down features enabled. 3. Us

MySite user profile site creation of My Content page is created as provisioned failed (unprovisioned

I've been trying to troubleshoot our User Profile Sync and have noticed the profile pages weren't getting updated with everything.  Most content was but things like memberships and the content tabs weren't.  I also saw this error in ULS: ProfSynch: Exception attempting to enumerate site 25a72070-4249-4698-ae99-c2a45d25b08e for ContentDB 23a6e3ef-6d56-4bde-825e-95c6924e2f91: Microsoft.Office.Server.UserProfiles.ProfileSynchronizationInternalException: ProfSynch: The site with ID 25a72070-4249-4698-ae99-c2a45d25b08e cannot be synchronized due to an unprovisioned root web.      at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.GetSynchInfoForSite(SqlDataReader dr, SynchInfo info)      at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.<get_Elements>d__0.MoveNext() I checked in the MySite database under the webs table and noticed all the My Content sites for all of our users had the flag column with the number 1315 in them - (meaning unprovisioned as the error above states).  Cross checking with the User Sync Profile database under the SiteSynch table I noticed all of the sites have NULL for the value under both the LastSynch and ChangeToken columns (The User Profile Service Application - User Profile to SharePoint Full Synchronization  timer job takes care of populating that).&

webdav xmlhttprequest to query current users exchange mailbox items


I would like to use xmlhttp request to display the current users unread email count in a webpart.  I can get this to work if the user enters their username & pw, but I'm not able to get any pass-thru credentials to work.  How can we set this up to pass through the current user's credentials.  We tried to set the sharepoint wfe with kerberos trusted delegation, but this doesn't seem to work.

We do not want to create an account with full access to all private mailboxes.

I cant print listview items to second page




I have a listview...

Here is the code...

Dim alta As Integer = 0
Dim yana As Integer = 0
txt.Text = 0
txtsayfa.Text = 0

Static pagenum As Integer = 0

For i = 0 To LV.items.count-1


            Dim aralik As New RectangleF(yana + 20, ust + alta, W / 4 - 15, H)
            e.Graphics.DrawString((LV.Items(i).SubItems(2).Text), font, Brushes.Black, aralik, trim)

            pagenum = pagenum + 1
            txt.Text = txt.Text + 1
            yana = yana + W / 4
            alta = alta + 200

            txtsayfa.Text = txtsayfa.Text + 1

            If txt.Text = 1 Then
                yana = 0

Keep Items in Rectangle on single page


Hi all,

I am using SSRS 2005. My report has a table, followed by a rectangle containing textboxes which display the selected parameters for the report.

I would like all the textboxes in my rectangle to always print on a single page - and thought this was the behaviour of rectangle...

However, when i run the report and render to PDF - and, if the number of records in my table takes up a good portion of a page - the text boxes contained in the rectangle can be split over 2 pages.

I do not want to always start a new page for the parameters, only if it cannot fit all together.

Any assitance greatly appreciated.

Thanks, Clay

Content Query Webpart Missing Content Type and Approval Status


I'm a great fan o the CQWP , and love the changes made in 2010 on this webpart. What bothers me is that I use to Filter Documents by Approval Status, thus showing Draft or Pending Documents and Group these by their Content Type.

Both these were available in 2007, but removed from 2010 CQWP. Any idea why, or how to bring this back? sample or URL guidance would be great. My gut feeling is custom XSLT but id like to confirm this first.

Thx a lot



Dataview paging problem - 2nd page of items being repeated for subsequent pages.


I have a dataview displaying items from a sharepoint list. There are over 2000 items in the list.

When I add paging to the dataview, asking it to display in sets of 20, it looks like it has worked as it has the paging links 1-20, 21-40 etc but on pages 41-60 upwards it just repeats the set of records shown on page 21-40.

This is happening on various pages/dataviews. I have re-added the dataview from scratch but this hasn't made any difference.

Any ideas why this is happening?

Content Editor Webpart not working in web part page


I Have a CEWP, i have written jquery for displaying the same.It works fine when i do the following:

Site Actions --> Edit page -->Add a Webpart --> CEWP --> and in the Source control editor, i paste the jquery. My jquery does a calculation by comparing two values A and B in a list. If A is greater, one image is shown, if it is less another image will be shown.When the user clicks the image the list gets opened and on the change in the values the image will be changed. This works perfectly when i do the above.

But when i create a Webpart page, it gets created in the Shared Documents site. And when i add a web part and does the same thing, my CEWP is not showing the correct image.




Customize content query web part in custom page layout


I am trying to build a custom page layout which should have the following web parts:

1. Announcements,

2. Doc Library

3. custom list items

And the data in these web parts should be from the site in which we create this page. For example, if we try to create a page in site A, then the announcements displayed should be from site-A, doc lib that is in site-A...

And I am trying to insert a content query web part in the page layout using sharepoint designer, and modify the query to insert the announcements list in the site. But how can I query to pull the data from corresponding site.

Thanks for the help.

create custom application page with a ribbon and user control webpart


i am in stress how to start this what should be the first step

i want to create custom application page with a ribbon and some user
control web part to show document item properties.

Please help me regarding this


thanks in advance 



wasikhan junior software ENG

Unique content within master page based on conditions met


 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?


Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008


I am having problems with a user control. I want my solution to have a separate project for holding my user controls.

The main project can get a reference to this user control project and can import this user control dll into my main project. 

Thanks in advance,

Dheeraj Mittal


Passing Linq Statement between master and content page


I usually work with windows forms, and am just starting to work with ASP.Net, so appologies if this is a dumb question!

I have a master page which has a search button on it. The results of this are built up using a Linq statement and if there are any results, I want to display the results in a contents page.

On the masterpage, I have the following code:

Private _res

    Public Overridable ReadOnly Property SearchRes()
            Return _res
        End Get
    End Property

 Private Sub DoSearch()
   'some code to get a linq result

    If res.Any Then
            _res = res
            Server.Transfer("SearchResults.aspx", True)
            'no results
            LabelNoRes.Visible = True
        End If
 End Sub

On the SearchResults.aspx page I have this code.

Dim m As pxSite = CType(Page.Master, MasterPage)
        If m.SearchRes IsNot Nothing Then
            Label1.Text = "Results found = " & m.SearchRes.Count
        End If

m.searchRes is always nothing. 

What am I doing wrong here?


Content page control passes as argument to javascript function


Here is the content page:


<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="JavaDynamicCopyValue.aspx.cs" Inherits="JavaDynamicCopyValue" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <script type="text/javascript" >
 function copyValue(input, output )
   ouput.value = input.value;
   return true;
 <asp:TextBox ID="txt1" runat="server" onchange="copyValue(this,document.getElementById('<%=txt2.ClientID%>'))"></asp:TextBox>
    <br />
    <br />
    <asp:TextBox ID="txt2" runat="server"></asp:TextBox>


I got a javascript run time error says output is undefined. if I view source of the page, the txt1 markup became:

<input name="ctl00$ContentPlaceHol

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend