.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

Problem with Filter on Status in CQWP

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

I have set up a task list (straight OOB) in each sub-site of a site. The Manager wants me to set up a CQWP on the top-level site that will show her all of the tasks on every sub-site that have a Status column value of "Not Started". I have tried filtering to the exact value (Not Started), filtering to "contains, Not", etc. None of these filters will produce the desired result. No success, nothing shows. I can filter on Priority just fine using either exact values or "contains". Is there something about the Status column that causes this to fail in a CQWP?

I tested Views and I can set a View to show all tasks equal to "Not Started. So I am perplexed why I cannot do the same thing in a CQWP.



View Complete Post

More Related Resource Links

Problem with CQWP "There is a problem with one or more of the field values below"

Hi, I'm trying out the content query webpart combined with content types. First I created a new site collection. In this site collection, these are the steps I did: - I enabled "SharePoint Server Publishing Infrastructure" feature at the site collection level - I enabled "SharePoint Server Publishing" feature at the site level - I created a new site column "Is Meat Eater", which is a yes/no field and added this to a new custom group called "Zoo" - I created a new content type called "Zoo Animal" that inherits from "Item" in category "List", and added this to a new custom group called "Zoo" - I added my site column "Is Meat Eater" to this content type (so now I have Title + Is Meat Eater) - I created a new custom list called "SharePoint Zoo" - I enabled content types on this list - I added "Zoo Animal" from the existing content types - I removed the default content type "Item" from the list (so now only 1 content type left, my own) - I added a few animals in the list - I added a content query web part on the homepage - As source I chose "Show items from all sites in this site collection" - As List Type I chose "custom list" - As Content Type Group I chose "Zoo" - As Content Type I chose "Zoo Animal" - I hit apply at

Webs Webservices problem : The request failed with HTTP status 401: Unauthorized

I am trying to run this code to get the web collection details. I am running this code in debug mode in Visual Studio 2005. I am running this code on sharepoint.acme.com, the same machine on which MOSS 2007 is installed.

        Webs websService = new Webs();
        System.Net.SystemNetworkCredential credentials =
        websService.Credentials = System.Net.CredentialCache.DefaultCredentials;
        websService.Url = "http://sharepoint.acme.com/_vti_bin/Webs.asmx";

        System.Xml.XmlNode myNode = websService.GetAllSubWebCollection();

I get this error. "The request failed with HTTP status 401: Unauthorized" in the last line while debug mode running. Earlier it used to work fine, but today I see this problem. Both acme\administrator and sharepoint\administrator can log into SharePoint. I tried running this code by logging in to my win2k3 desktop as acme\administrator once and launching Visual Studio 2005 and sharepoint\administrator another time. Both time it I got the same error.

Could someone please help me in resolving this error?

Apply a Filter in a Select statement Problem


Hello all

I need to select some rows from a table and apply a distinct on two of the columns (keeping the most recent one) and get all the attributes of the selected rows.

for example

if I have a table with the following rows and coloumns

1 1 1 1/1/2010
2 1 1 2/1/2010
3 1 2 1/1/2010

I need to do a select distinct on columns A and B keeping the most recent row and return all the coloumns of the selected rows

so i need the result to be rows 2 and 3 and discard row 1 because there is another row (2) having the same data in columns A and B and the other row (2) is more recent.

I tryed creating a veiw, use a common table expression and create a stored procedure...

but my knowledge with sql is limited and cannot get the result i want...

Is there a way of getting that result without having to change the database structure?

Any suggestions are welcome


Problem trying row filtering - Need Filter Template for string columns


I'm still really new at DD.

I need to do straightforward filtering of tables on columns that are simple string/text/varchar type.

I'm trying to follow the direction given in http://blogs.msdn.com/b/morebits/archive/2009/04/14/customize-table-rows-filtering-in-dynamic-data.aspx 

 I have added the DynamicFilter in my markup like this:

<asp:DynamicFilter ID="SellerFilterID" DataField="SellerUserId" runat="server" OnFilterChanged="DynamicFilter_FilterChanged" />

I have added the QueryExtender and Dynamic Filter expression like this:

            <asp:QueryExtender ID="CustomerCustomQueryExtenderID" TargetControlID="GridDataSource" runat="server">
                <asp:DynamicFilterExpression  ControlID="SellerFilterID" />
I get the error that I expected because the blog warned that "It will throw a 

Problem with "Current User Filter"


I am trying to create a page that displays documents based on the company of the current user.  The problem that i am experiencing is that the Company field is not available from the Current User Filter.  Any suggestions on how I can filter on this user property.


Thanks in advance



CQWP and managed metadata field filter


Hi everybody,

I want use the CQWP to list all documents from all document libraries of concrete site and i want filter the result with a custom managed metadata field. When I set the query to do in a concrete document library, CQWP allows me to select the managed metadata field that I want to use to filter. But when I select a site and I set the List type to 'Document Library' the fields listed in the filter not shows my custom field.

Anybody knows how resolve it?

Thanks in advance,

Sergio Calleja

Approval Workflow blank status problem.


We noticed an issue in our environments where under certain conditions an approval workflow has a blank status.

I have since been able to replicate this in a vanilla environment, and have tried up to the June 2010 CU. I will be trying on Oct 2010 CU soon.

Steps to reproduce...

1. Create a document library
2. In versioning set Require Check Out to Yes.
2. Create at least one document in the newly created document library and check in.
3. Create an Approval Workflow by using a workflow template (go to Settings -> Document Library Settings -> Workflow settings and then set up an approval workflow). Ensure that this workflow is configured to started when items are modified, and is used for content approval (after workflow is completed, update the approval status).
4. Modify one of the documents contained within the newly created document library. The workflow starts automatically.
5. On the newly created document library page, you will notice that the <workflow name> column is displayed but it does NOT show the status of the workflow.

If you look at the workflow on the item it will show up as "in progress" but on the library is is blank.

So far it looks like this only occurs when required check out is turned on.

Any ideas anyone? Are we missing something?



Problem with ViewState on Foreign Key Filter


I have a site that is no longer working properly in preserving viewstate on a QueryableFilterRepeater, particularly on Foreign Key fields.

To explain, suppose you have a drop down list autogenerated through the QueryableFilterRepeater control on List.aspx of Products, showing a list of products with a drop down list of Parent Categories.  Choose a Category (say "Toys"), and the List filters properly.  Now, when I hit the BACK button on the browser, the List goes back to the original ALL products, but the drop down control no longer returns to "All", but stays at the previously selected "Toys".

I cannot determine WHERE in the code my viewstate (or other setting) is preventing the drop down control to reset itself as the grid does after hitting the BACK button.

Any help appreciated. 

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Regrading Sharpoint 2010 problem and solutions

We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Virtual Path Problem


 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-


Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"

        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http

Strange Photo upload problem


I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

thaks for your help in advance

ASP.Net Caching problem ??


I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

Could some one tell me whats the Problem with this String Manipulation ??? C#.net



I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????

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