Project List - Search Function

[cchow32]

Bugs:

• Does not support partial search strings, even if I use LIKE function. (e.g. Project name LIKE "recycling" will return no results, despite us having a project name with the word "recycling" in the system.)
• Organizations, Beneficiaries, Sector and Project status should not be free entry text fields. We should be able to select from the entries we have entered into the system.
• The current implementation is un-intuitive and not user-friendly, especially for users not familiar with DB functions. Please see UI mockup of what I would like the search function to look like:

Here's a breakdown of how I want each search field to function:

1) Project Name: Free text entry. This should support partial entry of name. (e.g. inputting "Kiddy" should return "Kiddy Heart Canteen"

2) Involved Organization: This should be a pull-down menu of all organizations inputted into the system. Only 1 can be selected.

3) Project Start Year: This should be a pull-down menu of years (e.g. 2013, 2009) Only 1 can be selected, and it should return all projects with that start date.

4) Project End Year: Same as Project Start Year

5) Sector: This should be a pull-down bullet list of all sectors inputted into the system. Multiple sectors can be selected and search results should return ALL projects with selected sectors. (e.g. if Education and Environment were selected, the search should return all projects with EITHER Education OR Environment selected as sector.)

6) Beneficiaries: Same as Sector

7) Project Status: This should be a pull-down menu of all project statuses inputted into the system. Only 1 can be selected.

The SQL relationship between all these search fields should be "AND" instead of "OR." blank fields should not be included in the search query.

[jasonpolaris]

It should have be OK, please check. If it is OK please close this issue thanks!

[cchow32]

Interface looks good Jason. There are some inconsistencies when searching multiple sectors and beneficiaries. For example, searching for environment sector projects does not return any results. (we have 1 environment sector project in the system.) Selecting multiple beneficiaries will also return incomplete results. (e.g. searching for students (primary) and students (secondary) together returns incomplete results)

[jasonpolaris]

Please take a look again thanks!

[cchow32]

Looks great! Thanks Jason. Closing the issue