Fetching Task List for the logged in User with LINQ/CAML/SQL query

Hi All,

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

The Task list should come from across site collections of a Web Application.

Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.

Thnx,

Alex

Hi All,

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

The Task list should come from across site collections of a Web Application.

Hence,The Scopen should be WebApplication.
How do I achieve the same? Need help ASAP.

Thnx,

Alex

Hi All,

The requirement is as follows..

We have some workflows which are been created already. The tasks are been assigned to users for their approval. Now, when the approver logs in it should display the Tasks List which are belonging to that particular user only. OR if the normal user logs inn, it should display Tasks belonging to that User only. A web part should display this. Pls. note that I have to show the Tasks from both "Workflow Task" & "Task".

How do I achieve the same?

Thnx,

Alex

Hey Frnds,

I am using the System.DirectoryServices.UserPrincipal.Current.EmailAddress to fetch the Currently logged in users email from AD.

If  debug my sol am getting the Exact mail id of that Particular user for ex:john@in.domain.com.

If i host My Application on iis

And Access my App am getting some other Email id instead of the john@in.domain.com.

I have changed the Application Pool identity to NetWorkService.

Can any one tell what could be wrong

Thanks

Regards

N.Balaji

I have an array list called Customer. I t holds a list of array list which has the account details.

proj.customer -> collection of arraylist of type customer

proj.customer.account -> collection of arraylist of type account

Account array list holds type account and it has a poperty account balance. How can I query all accounts which has account balance  >100

I tried the following one

var Accountlist= from Account accountdetails in proj.customer.account

where accountid.balance >100

select accountdetails.id

But it is always throwing an error saying cannot cast type customer to type account

Please help

Hello

I have a GridView in my page. I want to use below code in code beind. query nothwing DB using linq . add linq query result to new list and then bind list as gridview Datasource

I use below code . But I don't know how to add results to List? Could any one tell me how !

Public Class OrderCity
        Private _name As String
        Private _city As String
        Public Property name As String
            Get
                Return _name
            End Get
            Set(ByVal value As String)
                _name = value

            End Set
        End Property
        Public Property city As String
            Get
                Return _city
            End Get
            Set(ByVal value As String)
                _city = value

            End Set
        End Property
    End Class
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Dim dbe As New SFFAV1DataContext
        Dim latestadsDs = From p In dbe.Products _
                            Select New With {p.Title, p.ProducedCity} _
                             Take (2)

        Dim FilteredList As New List(Of OrderCity)()
        For Each result In latestadsDs
            Dim Menedfcou = Nothing
            FilteredList.Insert(0, Menedfcou)
        Next
     
         GridView1.Da

hi all,

I have to filter the MyTask according to "Assigned To" = "SharePoint Group" and "TaskStatus" = "InProgress", I have created the SPLinq.cs file using the SPMetal.exe for the particular webapplication but I am not able to get the "TaskStatus" field in the linq MyTask Object, also have checked the SPLinq.cs file it's having the definition of "Assigned To" and "TaskStatus".

Please Help me how to do filter the MyTask according to "Assigned To" = "SharePoint Group" and "status" = "InProgress" by using Linq.

Regards,

Arun Kumar

hi guys,

in order to prepopulate some user information, i used query to search the sharepoint list. my question is how to search loggin user's info in the list.

i used following testing query function. it works fine. however, it can only search specific text, cannot be changed according different user.

SPList IsExist;
                    IsExist = SPContext.Current.Web.Lists["somelist"];
                    SPQuery query = new SPQuery();
                    
                    query.Query = @"
                        <Where>
                            <And>
                                <Eq> 
                                    <FieldRef Name='First_x0020_Name'/>
                                    <Value Type='Text'>XXX</Value> 
                                </Eq>
                                <Eq> 
                                    <FieldRef Name='Last_x0020_Name'/>
                                    <Value Type='Text'>XXX</Value> 
                                </Eq>
                            </And>
                        </Where>";
                    SPListItemCollection found = IsExist.GetItems(query);
                    

Hey all,

I'm in the process of creating a Silverlight Application that needs to pull data from a SharePoint list.  Unfortunately, some of the data is within sub-folders, and calling the List.GetItems(CamlQuery) function is only returning the root level (no sub-folder content).

I noticed from searching around for the solution to this that an attribute exists for doing a recursive check, so all the list items could be returned, but all the times this solution is mentioned is in regards to getting an SPList and using an SPQuery. The SPQuery variable has a ViewAttributes property to do this, apparently, but I don't seem to have that specific of a choice with the CamlQuery variable type here.

Any help?

Hi,

I have a "Collect data from user" task which naturally shows the Workflow Tasks list when the user clicks "Complete Task" and the task form closes.  This is a little confusing for the user who thinks they are working on items in the base list.  Is there a way I can choose which list is shown after the user clicks "Complete Task" (or any action which closes a workflow task)?

I am using SharePoint 2007 Standard Edition and SPD 2007

Many thanks for your help,

Kirsten

I've got a nested query caml which basically should check 3 things:

1. Check if a task has been assigned directly to the ucrrent user
2. Check if a task has been assigned to a group the user is in
3. Check if the user is member of a specific

The first to bullet points work like a charm, but I can't figure out how to get the last one to work. Here is what I thought should work:

query += "<Where>";
query += "<Eq><Membership Type=\"CurrentUserGroups\">";
query += "<Value Type=\"String\">Name of my specific group</Value>";
query += "</Membership></Eq>";
query += "</Where>";

Somehow it doesn't seem to be the correct approach, is there somebody who can help me out on this? Thanks