Link / join lists dynamically / programmatically

Question

Hello.

I tried making Linked lists in Sharepoint designer and it worked well - I was able to link multiple sources of lists in 1 source.

However I want to link these lists programmatically (by coding), so I could add/remove some lists based on condition (well actually I want a list with template number X added to linked source automatically).

How can I achieve that?

Answer 1

You can use the Content Query Webpart (available in MOSS) and use the ListsOverride method to specify custom list templates to be included in your search. You can do this both from your code as well as from the interface.

Here are more details, you will need to specify the list templates as

<List>

elements, according to the WSS SDK 3.0 reference.