Add the ability to search records

[GoogleCodeExporter]

Receipts and Line Items are well suited for searching.  The name and 
description fields are suitable for a text based search.

The biggest problem would be finding a way to visualize the search results 
and sorting them in an order that is optimal for the user.

The use case for this feature would be quickly finding a receipt or gathering 
together in one place a group of similar objects to compare the amounts or 
fund allocations.

One way to accomplish this would be to first locate all of the relevant 
records and then generate a budget tree that contains the results.

Original issue reported on code.google.com by jjhatf02 on 21 Mar 2010 at 3:18

[GoogleCodeExporter]

Using an InnoDB does not allow for fulltext searches of fields.  The workaround 
is to 
create a table that duplicates the information and use this for searches.  
Instead of 
that a simple comparison is done on the name and description fields.

The simple version of search only searches for text.  A more advanced version 
could 
search amounts of receipts and even fund allocations.  Another field that could 
be 
searched is the receipt date field.  All of these features would require more 
work 
that will be put into the initial search feature.

Displaying the results is expensive as each result needs to verify if it is 
public 
based off of the parents.  Also, those same parents need to be inspected to 
generate 
the breadcrumb trail starting at the root and ending at the record.

Original comment by jjhatf02 on 25 Mar 2010 at 3:31

• Changed state: Started

[GoogleCodeExporter]

This was fixed by r65.

Original comment by jjhatf02 on 31 Mar 2010 at 1:37

• Changed state: Fixed
• Added labels: Priority-Critical
• Removed labels: Priority-Low