Hello, I've created a WSS site for task management. Currently there are 6
different task lists on the site. The entry form of each task list contains
an additional field "senior".

I'd like to create one additional list/feature, bringing me back the items
contained in the various task lists having the value "yes" in the "senior"
field.

What would be the easiest way for doing this?

Many thanks,

Christian

Re: Get information from 6 different task lists by Mike

Mike
Wed Aug 17 03:34:33 CDT 2005

There are no free web parts that do consolidation of the contents of several
lists into one.

The Coras Works suite has several consolidation web parts and they work
well, but it is (very) expensive if all you want is one consolidation.

You could consider code accessing the database directly. I have done this
for document libraries (using a SQL Server view that consolidates the
documents in each document library and then sorts them with latest first)
but whether this is possible in a task list I don't know.

If you want to investigate programming methods further, please post an
amended version of this message (saying you want a programming solution) to
the subnewsgroup for WSS Programming issues at
microsoft.public.sharepoint.windowsservices.development

Mike Walsh, Helsinki, Finland
WSS FAQ http://wss.collutions.com
please reply to the newsgroup only

"cbcon" <cbcon@discussions.microsoft.com> wrote in message
news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
> Hello, I've created a WSS site for task management. Currently there are 6
> different task lists on the site. The entry form of each task list
> contains
> an additional field "senior".
>
> I'd like to create one additional list/feature, bringing me back the items
> contained in the various task lists having the value "yes" in the "senior"
> field.
>
> What would be the easiest way for doing this?
>
> Many thanks,
>
> Christian



Re: Get information from 6 different task lists by Loke

Loke
Wed Aug 17 12:16:21 CDT 2005

Try this.
http://www.ideseg.com/CategoryView,category,csegRollUp.aspx
Its very flexible... but you need to understand xslt, which I am an idiot...
;p

--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @ http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai


"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:%23rPCMawoFHA.1088@TK2MSFTNGP14.phx.gbl...
> There are no free web parts that do consolidation of the contents of
> several lists into one.
>
> The Coras Works suite has several consolidation web parts and they work
> well, but it is (very) expensive if all you want is one consolidation.
>
> You could consider code accessing the database directly. I have done this
> for document libraries (using a SQL Server view that consolidates the
> documents in each document library and then sorts them with latest first)
> but whether this is possible in a task list I don't know.
>
> If you want to investigate programming methods further, please post an
> amended version of this message (saying you want a programming solution)
> to the subnewsgroup for WSS Programming issues at
> microsoft.public.sharepoint.windowsservices.development
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ http://wss.collutions.com
> please reply to the newsgroup only
>
> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
>> Hello, I've created a WSS site for task management. Currently there are 6
>> different task lists on the site. The entry form of each task list
>> contains
>> an additional field "senior".
>>
>> I'd like to create one additional list/feature, bringing me back the
>> items
>> contained in the various task lists having the value "yes" in the
>> "senior"
>> field.
>>
>> What would be the easiest way for doing this?
>>
>> Many thanks,
>>
>> Christian
>
>



Re: Get information from 6 different task lists by Mike

Mike
Wed Aug 17 23:10:31 CDT 2005

That web part at the moment only works for SPS 2003 installations. (Reply
from the writer of it only a few days ago). (and this - as you know - is the
WSS newsgroup)

Mike Walsh, Helsinki, Finland

"Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
news:%23SYxk90oFHA.3936@TK2MSFTNGP10.phx.gbl...
> Try this.
> http://www.ideseg.com/CategoryView,category,csegRollUp.aspx
> Its very flexible... but you need to understand xslt, which I am an
> idiot... ;p
>
> --
> Best Regards,
> Kit Kai
> MVP (asp.net)
> SgDotNet Council Member
> Visit Us @ http://www.sgdotnet.org
> My Blog: http://community.sgdotnet.org/blogs/kitkai
>
>
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:%23rPCMawoFHA.1088@TK2MSFTNGP14.phx.gbl...
>> There are no free web parts that do consolidation of the contents of
>> several lists into one.
>>
>> The Coras Works suite has several consolidation web parts and they work
>> well, but it is (very) expensive if all you want is one consolidation.
>>
>> You could consider code accessing the database directly. I have done this
>> for document libraries (using a SQL Server view that consolidates the
>> documents in each document library and then sorts them with latest first)
>> but whether this is possible in a task list I don't know.
>>
>> If you want to investigate programming methods further, please post an
>> amended version of this message (saying you want a programming solution)
>> to the subnewsgroup for WSS Programming issues at
>> microsoft.public.sharepoint.windowsservices.development
>>
>> Mike Walsh, Helsinki, Finland
>> WSS FAQ http://wss.collutions.com
>> please reply to the newsgroup only
>>
>> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
>> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
>>> Hello, I've created a WSS site for task management. Currently there are
>>> 6
>>> different task lists on the site. The entry form of each task list
>>> contains
>>> an additional field "senior".
>>>
>>> I'd like to create one additional list/feature, bringing me back the
>>> items
>>> contained in the various task lists having the value "yes" in the
>>> "senior"
>>> field.
>>>
>>> What would be the easiest way for doing this?
>>>
>>> Many thanks,
>>>
>>> Christian
>>
>>
>
>



Re: Get information from 6 different task lists by cbcon

cbcon
Thu Aug 18 03:19:03 CDT 2005

Many thanks! The code based solution seems to be the best solution for our
purposes.

"Mike Walsh" wrote:

> There are no free web parts that do consolidation of the contents of several
> lists into one.
>
> The Coras Works suite has several consolidation web parts and they work
> well, but it is (very) expensive if all you want is one consolidation.
>
> You could consider code accessing the database directly. I have done this
> for document libraries (using a SQL Server view that consolidates the
> documents in each document library and then sorts them with latest first)
> but whether this is possible in a task list I don't know.
>
> If you want to investigate programming methods further, please post an
> amended version of this message (saying you want a programming solution) to
> the subnewsgroup for WSS Programming issues at
> microsoft.public.sharepoint.windowsservices.development
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ http://wss.collutions.com
> please reply to the newsgroup only
>
> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
> > Hello, I've created a WSS site for task management. Currently there are 6
> > different task lists on the site. The entry form of each task list
> > contains
> > an additional field "senior".
> >
> > I'd like to create one additional list/feature, bringing me back the items
> > contained in the various task lists having the value "yes" in the "senior"
> > field.
> >
> > What would be the easiest way for doing this?
> >
> > Many thanks,
> >
> > Christian
>
>
>

Re: Get information from 6 different task lists by Loke

Loke
Wed Aug 24 08:05:03 CDT 2005

But I just deployed it in one of my client's place. There was a bug, which
he promptly fixed for me, but never did he mentioned that its only for
sps...

--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @ http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai


"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:uOP4Ur6oFHA.3756@TK2MSFTNGP09.phx.gbl...
> That web part at the moment only works for SPS 2003 installations. (Reply
> from the writer of it only a few days ago). (and this - as you know - is
> the WSS newsgroup)
>
> Mike Walsh, Helsinki, Finland
>
> "Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
> news:%23SYxk90oFHA.3936@TK2MSFTNGP10.phx.gbl...
>> Try this.
>> http://www.ideseg.com/CategoryView,category,csegRollUp.aspx
>> Its very flexible... but you need to understand xslt, which I am an
>> idiot... ;p
>>
>> --
>> Best Regards,
>> Kit Kai
>> MVP (asp.net)
>> SgDotNet Council Member
>> Visit Us @ http://www.sgdotnet.org
>> My Blog: http://community.sgdotnet.org/blogs/kitkai
>>
>>
>> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>> news:%23rPCMawoFHA.1088@TK2MSFTNGP14.phx.gbl...
>>> There are no free web parts that do consolidation of the contents of
>>> several lists into one.
>>>
>>> The Coras Works suite has several consolidation web parts and they work
>>> well, but it is (very) expensive if all you want is one consolidation.
>>>
>>> You could consider code accessing the database directly. I have done
>>> this for document libraries (using a SQL Server view that consolidates
>>> the documents in each document library and then sorts them with latest
>>> first) but whether this is possible in a task list I don't know.
>>>
>>> If you want to investigate programming methods further, please post an
>>> amended version of this message (saying you want a programming solution)
>>> to the subnewsgroup for WSS Programming issues at
>>> microsoft.public.sharepoint.windowsservices.development
>>>
>>> Mike Walsh, Helsinki, Finland
>>> WSS FAQ http://wss.collutions.com
>>> please reply to the newsgroup only
>>>
>>> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
>>> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
>>>> Hello, I've created a WSS site for task management. Currently there are
>>>> 6
>>>> different task lists on the site. The entry form of each task list
>>>> contains
>>>> an additional field "senior".
>>>>
>>>> I'd like to create one additional list/feature, bringing me back the
>>>> items
>>>> contained in the various task lists having the value "yes" in the
>>>> "senior"
>>>> field.
>>>>
>>>> What would be the easiest way for doing this?
>>>>
>>>> Many thanks,
>>>>
>>>> Christian
>>>
>>>
>>
>>
>
>



Re: Get information from 6 different task lists by Mike

Mike
Wed Aug 24 01:34:07 CDT 2005

I asked the person who wrote it and he replied to me that it was only for
SPS 2003 but that he was hoping to have a WSS version later. (That was only
a couple of weeks ago)

I suppose I need to test it myself.

P.S. You *did* deploy it in a standalone WSS installation ? (You didn't
exactly say :))

Mike Walsh, Helsinki, Finland

"Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
news:OjdbzxKqFHA.3572@TK2MSFTNGP09.phx.gbl...
> But I just deployed it in one of my client's place. There was a bug, which
> he promptly fixed for me, but never did he mentioned that its only for
> sps...
>
> --
> Best Regards,
> Kit Kai
> MVP (asp.net)
> SgDotNet Council Member
> Visit Us @ http://www.sgdotnet.org
> My Blog: http://community.sgdotnet.org/blogs/kitkai
>
>
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:uOP4Ur6oFHA.3756@TK2MSFTNGP09.phx.gbl...
>> That web part at the moment only works for SPS 2003 installations. (Reply
>> from the writer of it only a few days ago). (and this - as you know - is
>> the WSS newsgroup)
>>
>> Mike Walsh, Helsinki, Finland
>>
>> "Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
>> news:%23SYxk90oFHA.3936@TK2MSFTNGP10.phx.gbl...
>>> Try this.
>>> http://www.ideseg.com/CategoryView,category,csegRollUp.aspx
>>> Its very flexible... but you need to understand xslt, which I am an
>>> idiot... ;p
>>>
>>> --
>>> Best Regards,
>>> Kit Kai
>>> MVP (asp.net)
>>> SgDotNet Council Member
>>> Visit Us @ http://www.sgdotnet.org
>>> My Blog: http://community.sgdotnet.org/blogs/kitkai
>>>
>>>
>>> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>>> news:%23rPCMawoFHA.1088@TK2MSFTNGP14.phx.gbl...
>>>> There are no free web parts that do consolidation of the contents of
>>>> several lists into one.
>>>>
>>>> The Coras Works suite has several consolidation web parts and they work
>>>> well, but it is (very) expensive if all you want is one consolidation.
>>>>
>>>> You could consider code accessing the database directly. I have done
>>>> this for document libraries (using a SQL Server view that consolidates
>>>> the documents in each document library and then sorts them with latest
>>>> first) but whether this is possible in a task list I don't know.
>>>>
>>>> If you want to investigate programming methods further, please post an
>>>> amended version of this message (saying you want a programming
>>>> solution) to the subnewsgroup for WSS Programming issues at
>>>> microsoft.public.sharepoint.windowsservices.development
>>>>
>>>> Mike Walsh, Helsinki, Finland
>>>> WSS FAQ http://wss.collutions.com
>>>> please reply to the newsgroup only
>>>>
>>>> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
>>>> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
>>>>> Hello, I've created a WSS site for task management. Currently there
>>>>> are 6
>>>>> different task lists on the site. The entry form of each task list
>>>>> contains
>>>>> an additional field "senior".
>>>>>
>>>>> I'd like to create one additional list/feature, bringing me back the
>>>>> items
>>>>> contained in the various task lists having the value "yes" in the
>>>>> "senior"
>>>>> field.
>>>>>
>>>>> What would be the easiest way for doing this?
>>>>>
>>>>> Many thanks,
>>>>>
>>>>> Christian
>>>>
>>>>
>>>
>>>
>>
>>
>
>



Re: Get information from 6 different task lists by Loke

Loke
Wed Aug 24 20:19:08 CDT 2005

Oh yes, I did deploy it to a standalone wss installation in adacm mode.
Its pretty cool, because it gives you all the list in xml, and you can just
transform it anyway you like...

--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @ http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai


"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:O$PrpmMqFHA.3204@TK2MSFTNGP10.phx.gbl...
>I asked the person who wrote it and he replied to me that it was only for
>SPS 2003 but that he was hoping to have a WSS version later. (That was only
>a couple of weeks ago)
>
> I suppose I need to test it myself.
>
> P.S. You *did* deploy it in a standalone WSS installation ? (You didn't
> exactly say :))
>
> Mike Walsh, Helsinki, Finland
>
> "Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
> news:OjdbzxKqFHA.3572@TK2MSFTNGP09.phx.gbl...
>> But I just deployed it in one of my client's place. There was a bug,
>> which he promptly fixed for me, but never did he mentioned that its only
>> for sps...
>>
>> --
>> Best Regards,
>> Kit Kai
>> MVP (asp.net)
>> SgDotNet Council Member
>> Visit Us @ http://www.sgdotnet.org
>> My Blog: http://community.sgdotnet.org/blogs/kitkai
>>
>>
>> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>> news:uOP4Ur6oFHA.3756@TK2MSFTNGP09.phx.gbl...
>>> That web part at the moment only works for SPS 2003 installations.
>>> (Reply from the writer of it only a few days ago). (and this - as you
>>> know - is the WSS newsgroup)
>>>
>>> Mike Walsh, Helsinki, Finland
>>>
>>> "Loke Kit Kai [MVP]" <kitkai@community.nospam> wrote in message
>>> news:%23SYxk90oFHA.3936@TK2MSFTNGP10.phx.gbl...
>>>> Try this.
>>>> http://www.ideseg.com/CategoryView,category,csegRollUp.aspx
>>>> Its very flexible... but you need to understand xslt, which I am an
>>>> idiot... ;p
>>>>
>>>> --
>>>> Best Regards,
>>>> Kit Kai
>>>> MVP (asp.net)
>>>> SgDotNet Council Member
>>>> Visit Us @ http://www.sgdotnet.org
>>>> My Blog: http://community.sgdotnet.org/blogs/kitkai
>>>>
>>>>
>>>> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>>>> news:%23rPCMawoFHA.1088@TK2MSFTNGP14.phx.gbl...
>>>>> There are no free web parts that do consolidation of the contents of
>>>>> several lists into one.
>>>>>
>>>>> The Coras Works suite has several consolidation web parts and they
>>>>> work well, but it is (very) expensive if all you want is one
>>>>> consolidation.
>>>>>
>>>>> You could consider code accessing the database directly. I have done
>>>>> this for document libraries (using a SQL Server view that consolidates
>>>>> the documents in each document library and then sorts them with latest
>>>>> first) but whether this is possible in a task list I don't know.
>>>>>
>>>>> If you want to investigate programming methods further, please post an
>>>>> amended version of this message (saying you want a programming
>>>>> solution) to the subnewsgroup for WSS Programming issues at
>>>>> microsoft.public.sharepoint.windowsservices.development
>>>>>
>>>>> Mike Walsh, Helsinki, Finland
>>>>> WSS FAQ http://wss.collutions.com
>>>>> please reply to the newsgroup only
>>>>>
>>>>> "cbcon" <cbcon@discussions.microsoft.com> wrote in message
>>>>> news:C1836D23-65D7-4D15-9B13-490D1BDA3F35@microsoft.com...
>>>>>> Hello, I've created a WSS site for task management. Currently there
>>>>>> are 6
>>>>>> different task lists on the site. The entry form of each task list
>>>>>> contains
>>>>>> an additional field "senior".
>>>>>>
>>>>>> I'd like to create one additional list/feature, bringing me back the
>>>>>> items
>>>>>> contained in the various task lists having the value "yes" in the
>>>>>> "senior"
>>>>>> field.
>>>>>>
>>>>>> What would be the easiest way for doing this?
>>>>>>
>>>>>> Many thanks,
>>>>>>
>>>>>> Christian
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>