Thread:Project:Support desk/"Finding" items in records so that they can turn up in the search

Hi there, I want to setup mediawiki to keep some records about projects which have been implemented by a number of different project developers. I setup a new project record easily enough, and each project record will have 4 items of information: project name, project sponsor and 2 more items of qualitative information. I am setting up a record like this:

--

= Project Name =

= Project Sponsor =

= Main Expected Results and Activities =

= Key Achievements in the project =

Lessons Learned in the project
---

This way, I can put a link on the sidebar and generate a list of projects in the database easily.

I want to be able to generate two lists so users can find projects (and have this accessible from the sidebar):

1)	A project list: An alphabetically sorted list of projects, ideally also showing who the sponsor is next to it (as there could by multiple projects which have similar names). Worse comes to the worse, we can include the project sponsor in brackets in the project title I guess). This I can do already as we can generate a list of all project records which have at the top. 2)	An alphabetically sorted list of sponsors (taken from the second field of data in the project record generated). Once you click on a sponsor in the list, that sponsor’s list of projects should all be displayed, alphabetically and as hyperlinks so we can see which sponsors have funded what projects in the database.

Is this possible please? Many thanks in advance!