[ 
http://mifosforge.jira.com/browse/MIFOS-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jslawinski resolved MIFOS-2711.
-------------------------------

    Fix Version/s: Gazelle C
       Resolution: Fixed

Added in r16742.

Tests on database containing more than 100k clients showed, that performance 
impact to searching is very low.

Average search time before adding CUST_GOVERNMENT_IDX:
accountSearch: 12.67 ms
idSearch: 8.17 ms
governmentIdSearch: 471.75 ms
nameSearch: 11 ms

Average search time after adding CUST_GOVERNMENT_IDX:
accountSearch: 9.69 ms
idSearch: 2.54 ms
governmentIdSearch: 4.15 ms
nameSearch: 11,54 ms

Adding CUST_GOVERNMENT_IDX index to database containing more than 100k clients 
took 3 min 25,62 sec.

> Add ability to search by Government ID
> --------------------------------------
>
>                 Key: MIFOS-2711
>                 URL: http://mifosforge.jira.com/browse/MIFOS-2711
>             Project: mifos
>          Issue Type: New Feature
>          Components: Search
>    Affects Versions: Release 1.4
>            Reporter: Kay Chau
>            Assignee: jslawinski
>             Fix For: Gazelle C
>
>
> Currently in Mifos, in the Search box that shows up both under the Home tab 
> and the Clients & Accounts tab, you can search by name, system ID or account 
> number.
> We want to add the ability to search by a client's "Government ID".  This ID 
> can be renamed under "Define Labels" in Mifos.  Currently this ID can be 
> added when you create a client or editing a client that hasn't been active 
> yet.
> For this feature, add searching by that field.  The search results UI should 
> be the same as when you search by client's Mifos system ID currently.
> On the test server, try searching for 0015-000000100 to see what should show 
> up.
> When searching by Government ID, the results should still be:
> x results for <Government ID> in All Branches
> where x is the number of results and <Government ID> is the search term.
> The results that match should show the same as when searching by client ID 
> For example:
> Client: sakuntala behera: ID 0015-000000100
> Status:   Active Loan Officer: siba prasad behera
> Loan: Account # 000100000000311 
> Note that in the search results, the Government ID won't be in the actual 
> search results.  This is fine, and we will add that as a separate enhancement.
> Another thing to note - it is possible that a Government ID could be the same 
> as a Mifos client ID or even loan account since they're not mutually 
> exclusive.  That is fine, and the expected result is that all search results 
> that match that number would be displayed.
> Leave the string that describes the Search box as is.  We'll add another 
> enhancement to update that string correctly.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to