search on words in program name not possible

[Dan MacNeil]

It should be possible to search on words in the name of a program.

Example: "Salem" or "Cyberspace"

[Dan MacNeil (omacneil)]

This is obvious but you should merge trunk. As of 10 minutes ago, there are (easy to resolve) conflicts with Steve's merged app-mvhub/conf/templates/html/search_results.tmpl

[Dan MacNeil (omacneil)]

Commit msgs don't have to list files

   bzr log -v

gives you files effected by a particular commit

[Dan MacNeil (omacneil)]

select char_length(agency_name) AS len,count(*) from agency group by char_length(agency_name) order by len DESC;

[Dan MacNeil (omacneil)]

should be : ' (....)' not '(...)'

+ $name .= $$program{program_alias} ? "($$program{program_alias})" : q//;

to:

+ $name .= $$program{program_alias} ? " ($$program{program_alias})" : q//;

...this is (a) very minor and (b) present in existing agency search, but I will create merge conflict if I fix it.

[Dan MacNeil (omacneil)]

A couple problems:

  1) If you search on 'food pantry' in mvh.csmith.testing123.net , you get
       (3) 'Food Pantry' entries under program.

  2) The three sets of results (agency, category, program) are a bit confusing.

So....

1) Disambiguate the program results by prepending the first 42 char of agency name (96% of agencies have names =< 42 char)

2) append "(main agency record)" to agency results

3) combine agency results with program results

4) Sort results alphabetically

...leaves us with 2 sets of results: Agency+program, category

[Dan MacNeil (omacneil)]

From this query, it looks like truncating and appending '...' looks fine.

select substring(agency_name,0,43), agency_name from agency where length(agency_name) > 43 ;

Greater Lowell Elder Mental Health Collabo...